Mode 1 2 3 2 3 Model 1 2 2 R Square .886 .938 .970 a. Predictors: (Constant), X3 - Advertising Expenditures ($) b. Predictors: (Constant), X3 - Advertising Expenditures ($), X4 - Personal Selling Expenditures ($) Model 1 R .941a .968b .985€ Model 1 c. Predictors: (Constant), X3 - Advertising Expenditures ($), X4 - Personal Selling Expenditures ($), X2 - Price ($) d. Dependent Variable: X1 - Units Sales Regression Residual Total Model 3 Regression Residual Total Sum of Squares 3594214.924 463076.742 4057291.667 3804567.477 252724.190 4057291.667 3934437.548 122854.119 Total 4057291.667 11 a. Predictors: (Constant), X3- Advertising Expenditures ($) b. Predictors: (Constant), X3 - Advertising Expenditures ($), X4 - Personal Selling Expenditures ($) Regression Residual Model 3 (Constant) X3 - Advertising Expenditures ($) (Constant) Model Summary Adjusted R Square X3 - Advertising Expenditures ($) X4 - Personal Selling Expenditures ($) a. Dependent Variable: X1 - Units Sales (Constant) X3 - Advertising Expenditures ($) (Constant) X3 - Advertising Expenditures ($) (Constant) X3 - Advertising Expenditures ($) X4 - Personal Selling Expenditures ($) a. Dependent Variable: X1 - Units Sales .874 .924 958 (Constant) X3 - Advertising Expenditures ($) ANOVA X4 - Personal Selling Expenditures ($) X2 - Price ($) a. Dependent Variable: X1 - Units Sales df c. Predictors: (Constant), X3 - Advertising Expenditures ($), X4 - Personal Selling Expenditures ($), X2 - Price ($) d. Dependent Variable: X1 - Units Sales Partial X4 - Personal Selling Expenditures ($) X2 - Price ($) a. Dependent Variable: X1 - Units Sales Coefficients Unstandardized Coefficients B 154.801 -706.137 .051 .701 11 .093 .941 1 10 11 2 1902283.738 9 28080.466 3 8 .048 .674 Correlations Partial Std. Error of the Estimate .036 .066 -.296 Coefficientsa .674 Mean Square 3594214.924 46307.674 .852 -.717 215.192 167.572 123.922 1311479.183 15356.765 Correlations Coefficientsa Part Std. Error Unstandardized Coefficients B -117.513 220.730 .011 358.456 .941 .245 .228 Part .017 .017 Coefficientsa Std. Error .159 .283 -.179 Durbin- Watson 333.526 .014 .014 .102 1.000 2.052 Collinearity Statistics Tolerance VIF .224 Standardized Coefficients Beta .224 F 77.616 67.744 85.401 .192 .180 .802 .941 .518 .481 1.000 4.461 Standardized Coefficients Beta 4.461 .362 Collinearity Statistics Tolerance VIF .668 -.200 5.214 5.551 1.247 Sig. .000a .000b .000€ t .701 8.810 -1.970 2.946 2.737 t -.352 2.579 4.607 -2.908 Sig. .499 .000 .080 .016 .023 Sig. .734 .033 .002 .020 Correlatio ns Zero-order .941 .941 .937 Correlatio ns Zero-order .941 .937 -.016

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

INTERPRET THE RESULT
1) Check for consistency in the relationship between quantity demand and the three explanatory variables as postulated in demand theory by indicating the change in the quantity demanded of the commodity for each unit change in the explanatory variables.

2)Find and interpret the adjusted and the unadjusted coefficient of determination.

Mode
I
2
3
2
Model
1
2
R Square
.886
.938
.970
a. Predictors: (Constant), X3 - Advertising Expenditures ($)
b. Predictors: (Constant), X3 - Advertising Expenditures ($), X4 - Personal Selling
Expenditures ($)
R
.941a
.968b
.985€
Model
1
c. Predictors: (Constant), X3 - Advertising Expenditures ($), X4 - Personal Selling
Expenditures ($), X2 - Price ($)
d. Dependent Variable: X1 - Units Sales
Sum of
Squares
3594214.924
463076.742
4057291.667
3804567.477
252724.190
4057291.667
3934437.548
122854.119
Total
4057291.667
11
a. Predictors: (Constant), X3 - Advertising Expenditures ($)
Model
1
Regression
Residual
Total
Regression
Residual
Total
Model
3
Regression
Residual
Model
3
Model Summaryd
Adjusted R
Square
(Constant)
X3 - Advertising
Expenditures ($)
(Constant)
X3 - Advertising
Expenditures ($)
X4 - Personal Selling
Expenditures ($)
a. Dependent Variable: X1 - Units Sales
(Constant)
X3 - Advertising
Expenditures ($)
(Constant)
X3 - Advertising
Expenditures ($)
(Constant)
X3 - Advertising
Expenditures ($)
.874
.924
.958
X4 - Personal Selling
Expenditures ($)
a. Dependent Variable: X1 - Units Sales
ANOVA
(Constant)
X3 - Advertising
Expenditures ($)
b. Predictors: (Constant), X3 - Advertising Expenditures ($), X4 - Personal Selling
Expenditures ($)
df
c. Predictors: (Constant), X3 - Advertising Expenditures ($), X4 - Personal Selling
Expenditures ($), X2 - Price ($)
d. Dependent Variable: X1 - Units Sales
X4 - Personal Selling
Expenditures ($)
X2 - Price ($)
a. Dependent Variable: X1 - Units Sales
Partial
X4 - Personal Selling
Expenditures ($)
X2 - Price ($)
a. Dependent Variable: X1 - Units Sales
Unstandardized Coefficients
B
154.801
Coefficientsa
1
10
11
-706.137
.701
.093
.941
2
9
11
3 1311479.183
8
15356.765
.051
.048
.674
Partial
Std. Error of
the Estimate
215.192
167.572
123.922
Correlations
Coefficientsa
Mean Square
3594214.924
46307.674
.066
-.296
.674
1902283.738
28080.466
036
.852
-.717
Correlations
Coefficientsa
Std. Error
Part
Unstandardized Coefficients
B
-117.513
220.730
.941
358.456
.017
.245
.228
Part
.011
.017
Coefficientsa
Std. Error
.159
.283
-.179
333.526
Durbin-
Watson
.014
.014
.102
1.000
2.052
Collinearity Statistics
Tolerance
VIF
.224
F
77.616
Standardized
Coefficients
Beta
.224
67.744
85.401
.192
.180
.802
.941
.518
.481
1.000
4.461
Standardized
Coefficients
Beta
4.461
.362
Collinearity Statistics
Tolerance
VIF
.668
-.200
5.214
5.551
1.247
Sig.
.000ª
.000b
.000⁰
t
.701
8.810
-1.970
2.946
2.737
t
-.352
2.579
4.607
-2.908
Sig.
.499
.000
.080
.016
.023
Sig.
.734
.033
.002
020
Correlatio
ns
Zero-order
.941
.941
.937
Correlatio
ns
Zero-order
.941
.937
-.016
Transcribed Image Text:Mode I 2 3 2 Model 1 2 R Square .886 .938 .970 a. Predictors: (Constant), X3 - Advertising Expenditures ($) b. Predictors: (Constant), X3 - Advertising Expenditures ($), X4 - Personal Selling Expenditures ($) R .941a .968b .985€ Model 1 c. Predictors: (Constant), X3 - Advertising Expenditures ($), X4 - Personal Selling Expenditures ($), X2 - Price ($) d. Dependent Variable: X1 - Units Sales Sum of Squares 3594214.924 463076.742 4057291.667 3804567.477 252724.190 4057291.667 3934437.548 122854.119 Total 4057291.667 11 a. Predictors: (Constant), X3 - Advertising Expenditures ($) Model 1 Regression Residual Total Regression Residual Total Model 3 Regression Residual Model 3 Model Summaryd Adjusted R Square (Constant) X3 - Advertising Expenditures ($) (Constant) X3 - Advertising Expenditures ($) X4 - Personal Selling Expenditures ($) a. Dependent Variable: X1 - Units Sales (Constant) X3 - Advertising Expenditures ($) (Constant) X3 - Advertising Expenditures ($) (Constant) X3 - Advertising Expenditures ($) .874 .924 .958 X4 - Personal Selling Expenditures ($) a. Dependent Variable: X1 - Units Sales ANOVA (Constant) X3 - Advertising Expenditures ($) b. Predictors: (Constant), X3 - Advertising Expenditures ($), X4 - Personal Selling Expenditures ($) df c. Predictors: (Constant), X3 - Advertising Expenditures ($), X4 - Personal Selling Expenditures ($), X2 - Price ($) d. Dependent Variable: X1 - Units Sales X4 - Personal Selling Expenditures ($) X2 - Price ($) a. Dependent Variable: X1 - Units Sales Partial X4 - Personal Selling Expenditures ($) X2 - Price ($) a. Dependent Variable: X1 - Units Sales Unstandardized Coefficients B 154.801 Coefficientsa 1 10 11 -706.137 .701 .093 .941 2 9 11 3 1311479.183 8 15356.765 .051 .048 .674 Partial Std. Error of the Estimate 215.192 167.572 123.922 Correlations Coefficientsa Mean Square 3594214.924 46307.674 .066 -.296 .674 1902283.738 28080.466 036 .852 -.717 Correlations Coefficientsa Std. Error Part Unstandardized Coefficients B -117.513 220.730 .941 358.456 .017 .245 .228 Part .011 .017 Coefficientsa Std. Error .159 .283 -.179 333.526 Durbin- Watson .014 .014 .102 1.000 2.052 Collinearity Statistics Tolerance VIF .224 F 77.616 Standardized Coefficients Beta .224 67.744 85.401 .192 .180 .802 .941 .518 .481 1.000 4.461 Standardized Coefficients Beta 4.461 .362 Collinearity Statistics Tolerance VIF .668 -.200 5.214 5.551 1.247 Sig. .000ª .000b .000⁰ t .701 8.810 -1.970 2.946 2.737 t -.352 2.579 4.607 -2.908 Sig. .499 .000 .080 .016 .023 Sig. .734 .033 .002 020 Correlatio ns Zero-order .941 .941 .937 Correlatio ns Zero-order .941 .937 -.016
Model
1
2
Model
1
X2 - Price ($)
.605
X4 - Personal Selling
.481a
.023
Expenditures ($)
2
X2 - Price ($)
-.200b
.020
a. Predictors in the Model: (Constant), X3- Advertising Expenditures ($)
1
2
Dime
Mode nsio
3
X2 - Price ($)
X4 - Personal Selling
Expenditures ($)
X2 - Price ($)
n
Charts
WN - N -P
Regression Standardized Predicted
Value
b. Predictors in the Model: (Constant), X3- Advertising Expenditures ($), X4 - Personal Selling
Expenditures ($)
c. Dependent Variable: X1 - Units Sales
VIF
1.002
.998
4.461
.224
1.247
.180
a. Predictors in the Model: (Constant), X3- Advertising Expenditures ($)
b. Predictors in the Model: (Constant), X3 - Advertising Expenditures ($), X4 -
Personal Selling Expenditures ($)
c. Dependent Variable: X1 - Units Sales
1
2
1
2
3
1
2
A WN-
3
Eigenvalue
1.960
.040
2.956
.040
.004
3.932
.057
.007
4
Predicted Value
Std. Predicted Value
Standard Error of
Predicted Value
Adjusted Predicted Value
Residual
O
Excluded Variables
Beta In
.003
a. Dependent Variable: X1 - Units Sales
O
-.060a
Excluded Variables
-1
Std. Residual
Stud. Residual
Deleted Residual
Stud. Deleted Residual
Mahal. Distance
Cook's Distance
Centered Leverage Value
a. Dependent Variable: X1 - Units Sales
Minimum
1,029.26
-1.658
41.974
1,043.92
-146.247
Condition
Index
-1.180
-1.562
-280.854
-1.752
.345
.000
.031
Collinearity Statistics
Minimum
Tolerance
1.000
6.963
1.000
8.551
27.487
1.000
8.300
23.164
33.916
t
-.537
2.737
-2.908
Residuals Statisticsa
Collinearity Diagnostics
(Constant)
O
1.532
2.706
592.346
8.699
6.558
3.881
.596
.02
O
888888
.98
0
.00
.23
.77
Maximum Mean
3,133.35 2,020.83
1.860
.000
102.152
69.953
3,280.85
1,997.70
189.842 2.15E-13
.00
.03
Sig.
.09
Scatterplot
.000
.064
23.138
.558
2.750
.440
.250
Partial
Correlation
Advertising
Expenditures
($)
Dependent Variable: X1 - Units Sales
O
Variance Proportions
X3 -
.02
.98
.00
.22
.78
.00
.15
.00
.85
Std. Deviation
598.060
1.000
15.682
614.712
105.681
.853
1.212
226.912
2.732
1.653
1.102
.150
-.176
.674
-.717
1
Regression Standardized Residual
O
Collinearit
y
Statistics
X4 - Personal
Selling
Expenditures
($)
N
Tolerance
.998
.224
.802
.00
.00
1.00
.00
.00
.00
.99
O
12
12
12
12
12
12
12
12
12
12
12
12
X2 Price ($)
-N
2
.00
.05
.72
.23
Transcribed Image Text:Model 1 2 Model 1 X2 - Price ($) .605 X4 - Personal Selling .481a .023 Expenditures ($) 2 X2 - Price ($) -.200b .020 a. Predictors in the Model: (Constant), X3- Advertising Expenditures ($) 1 2 Dime Mode nsio 3 X2 - Price ($) X4 - Personal Selling Expenditures ($) X2 - Price ($) n Charts WN - N -P Regression Standardized Predicted Value b. Predictors in the Model: (Constant), X3- Advertising Expenditures ($), X4 - Personal Selling Expenditures ($) c. Dependent Variable: X1 - Units Sales VIF 1.002 .998 4.461 .224 1.247 .180 a. Predictors in the Model: (Constant), X3- Advertising Expenditures ($) b. Predictors in the Model: (Constant), X3 - Advertising Expenditures ($), X4 - Personal Selling Expenditures ($) c. Dependent Variable: X1 - Units Sales 1 2 1 2 3 1 2 A WN- 3 Eigenvalue 1.960 .040 2.956 .040 .004 3.932 .057 .007 4 Predicted Value Std. Predicted Value Standard Error of Predicted Value Adjusted Predicted Value Residual O Excluded Variables Beta In .003 a. Dependent Variable: X1 - Units Sales O -.060a Excluded Variables -1 Std. Residual Stud. Residual Deleted Residual Stud. Deleted Residual Mahal. Distance Cook's Distance Centered Leverage Value a. Dependent Variable: X1 - Units Sales Minimum 1,029.26 -1.658 41.974 1,043.92 -146.247 Condition Index -1.180 -1.562 -280.854 -1.752 .345 .000 .031 Collinearity Statistics Minimum Tolerance 1.000 6.963 1.000 8.551 27.487 1.000 8.300 23.164 33.916 t -.537 2.737 -2.908 Residuals Statisticsa Collinearity Diagnostics (Constant) O 1.532 2.706 592.346 8.699 6.558 3.881 .596 .02 O 888888 .98 0 .00 .23 .77 Maximum Mean 3,133.35 2,020.83 1.860 .000 102.152 69.953 3,280.85 1,997.70 189.842 2.15E-13 .00 .03 Sig. .09 Scatterplot .000 .064 23.138 .558 2.750 .440 .250 Partial Correlation Advertising Expenditures ($) Dependent Variable: X1 - Units Sales O Variance Proportions X3 - .02 .98 .00 .22 .78 .00 .15 .00 .85 Std. Deviation 598.060 1.000 15.682 614.712 105.681 .853 1.212 226.912 2.732 1.653 1.102 .150 -.176 .674 -.717 1 Regression Standardized Residual O Collinearit y Statistics X4 - Personal Selling Expenditures ($) N Tolerance .998 .224 .802 .00 .00 1.00 .00 .00 .00 .99 O 12 12 12 12 12 12 12 12 12 12 12 12 X2 Price ($) -N 2 .00 .05 .72 .23
Expert Solution
steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman