Scribd
Upload
8 views5 pages

Multiple Linear Regression Assignment

The document presents regression analysis results for the demand of coach seats, showing two different models with varying statistics. The first model indicates a strong relationship with a multiple R of 0.9 and significant coefficients for price, competitor price, and consumer income. The second model has a lower multiple R of 0.8 and highlights the impact of coach seat price and competitor pricing on sales, but with less overall explanatory power.

Uploaded by

Mary Rose Toralba Anoa'i
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
8 views5 pages

Multiple Linear Regression Assignment

The document presents regression analysis results for the demand of coach seats, showing two different models with varying statistics. The first model indicates a strong relationship with a multiple R of 0.9 and significant coefficients for price, competitor price, and consumer income. The second model has a lower multiple R of 0.8 and highlights the impact of coach seat price and competitor pricing on sales, but with less overall explanatory power.

Uploaded by

Mary Rose Toralba Anoa'i
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.9
R Square 0.8
Adjusted R Square 0.7
Standard Error 14.8
Observations 16

ANOVA
df SS MS F
Regression 3 9089.6 3029.9 13.9
Residual 12 2616.4 218.0
Total 15 11706.0

Coefficients Standard Error t Stat P-value


Intercept 28.8 174.7 0.2 0.9
Price of Coach Seats (P) -2.1 0.3 -6.2 0.0
Average Competitor Price (P°) 1.0 0.5 2.2 0.0
Average Consumer Income (I) 3.1 1.0 3.1 0.0

DEMAND EQUATION= 28.8-2.1P+1P°+3.1I

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.8
R Square 0.6
Adjusted R Square 0.5
Standard Error 19.0
Observations 16

ANOVA
df SS MS F
Regression 2 7004.1 3502.0 9.7
Residual 13 4701.9 361.7
Total 15 11706.0

Coefficients Standard Error t Stat P-value


Intercept 388.9 167.7 2.3 0.0
Price of Coach Seats (P) -1.6 0.4 -4.2 0.0
Average Competitor Price (P°) 0.3 0.5 0.6 0.5
Significance F
0.0

Lower 95% Upper 95% Lower 95.0% Upper 95.0%


-351.7 409.4 -351.7 409.4
-2.9 -1.4 -2.9 -1.4
0.0 2.1 0.0 2.1
0.9 5.3 0.9 5.3

Significance F
0.0

Lower 95% Upper 95% Lower 95.0% Upper 95.0%


26.5 751.2 26.5 751.2
-2.4 -0.8 -2.4 -0.8
-0.8 1.5 -0.8 1.5
Year and Quarter Qty of Coach Seats Sold (Q) Price of Coach Seats (P)
YI QI 64.8 250
Q2 33.6 265
Q3 37.8 265
Q4 83.3 240
Y1 Q1 111.7 230
Q2 137.5 225
Q3 109.5 225
Q4 96.8 220
W Q1 59.5 230
Q2 83.2 235
Q3 90.5 245
Q4 105.5 240
Y4 Q1 75.7 250
Q2 91.6 240
Q3 112.7 240
Q4 102.2 235
Average Competitor Price (P°) Average Consumer Income (I) Predicted Q
250 104 76.2000000000001
250 101.5 36.95
240 103 31.6
240 105 90.3
240 100 95.8
260 96.5 115.45
250 93.3 95.53
240 95 101.3
240 97 86.5
250 99 92.2000000000001
250 102.5 82.05
240 105 90.3
220 108.5 60.15
230 108.5 91.15
250 108 109.6
240 109 113.2
28.8-2.1P+1P°+3.1I

You might also like