Top
Sales Price Mileage
Cars speed
(in 1,000 units) (in lakh rupees) (Km/ltr)
(Km/hr) SUMMARY OUTPUT
Rocinante 1 171.877 6.1 15.8 168.2
Rocinante 2 139.796 6.1 12.1 149.6
Rocinante 3 178.947 9.9 17 173.4 Multiple R
Rocinante 4 140.022 5.8 11.6 170.6 R Square
Rocinante 5 186.476 10 17.2 175 Adjusted R
Rocinante 6 192.123 6.5 17.6 173.1 Standard E
Rocinante 7 175.085 5.5 16 184.6 Observatio
Rocinante 8 146.882 8.4 13 175.7
Rocinante 9 202.847 6.6 19.3 166.7 ANOVA
Rocinante 10 149.933 8.8 13.3 175.4
Rocinante 11 171.579 9.5 15.8 150.9 Regression
Rocinante 12 201.512 9.2 19.2 140.5 Residual
Rocinante 13 142.604 8.1 11.7 150.2 Total
Rocinante 14 135.158 5.4 11.2 146.2
Rocinante 15 107.322 5.6 7.8 151.2
Rocinante 16 199.699 6.3 19 143.2 Intercept
Price
(in lakh
Rocinante 17 202.875 5.8 19.7 178.9 rupees)
Mileage
Rocinante 18 204.406 7.7 19.5 168.2 (Km/ltr)
Rocinante 19 107.331 7.2 7.5 164.7 Top speed
Rocinante 20 190.345 8.4 18.1 182.7
Rocinante 21 108.419 8.4 7.9 165.7
Rocinante 22 150.249 5.7 12.6 137
Rocinante 23 155.882 5.5 12.9 173.9
Rocinante 24 100.98 8.4 7.6 165.1
Rocinante 25 182.679 5.6 16.7 160.1
Rocinante 26 166.752 9.9 15.5 155.6
Rocinante 27 121.561 6.2 9.5 155.4
Rocinante 28 174.256 9.9 16.3 161.9
Rocinante 29 119.018 6.5 9.1 146.8
Rocinante 30 169.842 7.1 15.3 149.5
Rocinante 31 198.311 9.6 19.1 146.5
Rocinante 32 204.875 5.8 19.4 178.9
Rocinante 33 119.561 6.2 9.4 175.4
Rocinante 34 203.875 5.9 19.4 175.9
Rocinante 35 118.561 6.1 9.4 165.4
SUMMARY OUTPUT
Regression Statistics
0.99788065450456
0.995765800634449
0.995356039405525
2.30779153196702
35
df
3
31
34
Coefficients
50.7231271792463
-0.795026440875324
8.30633109237939
-0.0185725639929489
4a
Intercept
Price
(in lakh rupees)
Mileage
(Km/ltr)
Top speed (Km/hr)
4b
Predicted sales (Y) =50.72312718 + (-0.795026441*Price) +(8.306331092*Mileage)
4c
Predicted sales (Y) = 50.72312718 + (-0.795026441*7) +(8.306331092*22)
5 - Predicted Profit - sales* ( price - Cost )
227897
Rocinante Model
Which car is most affected by 1 lakh price increase
Old sales
New Sales
Change
8 - Return the regression using only significant variables & compare the adjusted r square
Parameter
R Square
Adjusted R Square
SS MS F Significance F
38827.6180187373 12942.5393395791 2430.1122955 7.4472712E-37
165.102954405579 5.32590175501867
38992.7209731429
Standard Error t Stat P-value Lower 95% Upper 95%Lower 95.0% Upper 95.0%
5.29210288470814 9.58468274035523 8.7390239E-11 39.9298121862 61.51644 39.92981 61.516442172
0.254333076043226 -3.12592625876236 0.003833463 -1.3137421693 -0.276311 -1.313742 -0.2763107124
0.100181306818659 82.9129840301932 5.7835638E-38 8.10200997005 8.510652 8.10201 8.5106522147
0.0305582354491913 -0.60777606167179 0.5477630261 -0.0808964961 0.043751 -0.080896 0.0437513681
Coefficients P-value p<0.05, sign
50.7231271792463 0.00000 significant
-0.795026440875324 0.00383 significant
8.30633109237939 0.00000 significant
-0.018572563992949 0.54776 not significant
Regression Equation
Sales
227.897411204
227.897411204
227.102199676
-0.795211527999982
Rocinante
All Variables Significant variables
0.995765800634449 0.995715346496514
0.995356039405525 0.995447555652547
SUMMARY OUTPUT - non significant
Regression Statistics
Multiple R 0.997855
R Square 0.995715
Adjusted R 0.995448
Standard E 2.284939
Observatio 35
ANOVA
df SS MS F Significance F
Regression 2 38825.65 19412.83 3718.258 1.29E-38
Residual 32 167.0703 5.220947
Total 34 38992.72
Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Intercept 47.77996 2.113441 22.60766 3.038E-21 43.47502 52.0849 43.47502
Price
(in lakh
rupees) -0.782925 0.251042 -3.118705 0.003827 -1.294281 -0.27157 -1.294281
Mileage
(Km/ltr) 8.294466 0.097288 85.25689 2.603E-39 8.096297 8.492636 8.096297
Upper 95.0%
52.0849
-0.27157
8.492636
Top
Sales Price Mileage
Cars speed
(in 1,000 units) (in lakh rupees) (Km/ltr)
(Km/hr) SUMMARY OUTPUT
Marengo 1 20.896 42.5 9.3 199.4
Marengo 2 31.048 36 9.7 235.2 Regression Statistics
Marengo 3 29.904 54.7 16.6 240.8 Multiple R
Marengo 4 28.792 42.7 11.7 232.5 R Square
Marengo 5 16.776 44.9 13.7 188.8 Adjusted R Square
Marengo 6 18.928 35.5 9.6 184.2 Standard Error
Marengo 7 22.776 51.3 13.7 207.7 Observations
Marengo 8 36.824 30.4 12.6 249.5
Marengo 9 22.216 38.4 16.2 175.8 ANOVA
Marengo 10 35.456 32.2 9.6 245.6
Marengo 11 28.576 59.4 11.3 223.3 Regression
Marengo 12 33.648 50.8 13.6 240 Residual
Marengo 13 33.44 57.5 13.5 250 Total
Marengo 14 34.912 44.6 11.1 247.4
Marengo 15 24.016 34.6 14.1 192 Coefficients
Marengo 16 20.992 56.4 13.4 201.2 Intercept
Price
Marengo 17 21.696 41.4 12.8 193.3 (in lakh rupees)
Mileage
Marengo 18 17.832 53.7 16 202 (Km/ltr)
Marengo 19 25.624 44.8 12.7 208.9 Top speed (Km/hr)
Marengo 20 21.92 32.4 13.6 176.9
Marengo 21 24.792 40.9 11.6 218.2
Marengo 22 22.256 44.1 11.4 190
Marengo 23 15.488 46.6 16.3 176.8
Marengo 24 21.64 31.4 14.5 178.9
Marengo 25 23.264 54.7 14.3 192.3
Marengo 26 19.328 37.9 9.4 184.1
Marengo 27 27.216 52.9 15.3 240.3
Marengo 28 23.096 42.7 15 192.1
Marengo 29 17.824 54.9 13.5 199
Marengo 30 19.144 44 11.8 181.1
Marengo 31 21.6 42.2 9.3 181.2
Cars Sales Price Top speed Mileage
(in 1,000 units) (in lakh rupees) (Km/hr) (Km/ltr)
Marengo 1 20.896 42.5 199.4 9.3
Marengo 2 31.048 36 235.2 9.7
Marengo 3 29.904 54.7 240.8 16.6
Marengo 4 28.792 42.7 232.5 11.7
Marengo 5 16.776 44.9 188.8 13.7
Marengo 6 18.928 35.5 184.2 9.6
Marengo 7 22.776 51.3 207.7 13.7
Marengo 8 36.824 30.4 249.5 12.6
Marengo 9 22.216 38.4 175.8 16.2
Marengo 10 35.456 32.2 245.6 9.6
Marengo 11 28.576 59.4 223.3 11.3
Marengo 12 33.648 50.8 240 13.6
Marengo 13 33.44 57.5 250 13.5
Marengo 14 34.912 44.6 247.4 11.1
Marengo 15 24.016 34.6 192 14.1
Marengo 16 20.992 56.4 201.2 13.4
Marengo 17 21.696 41.4 193.3 12.8
Marengo 18 17.832 53.7 202 16
Marengo 19 25.624 44.8 208.9 12.7
Marengo 20 21.92 32.4 176.9 13.6
Marengo 21 24.792 40.9 218.2 11.6
Marengo 22 22.256 44.1 190 11.4
Marengo 23 15.488 46.6 176.8 16.3
Marengo 24 21.64 31.4 178.9 14.5
Marengo 25 23.264 54.7 192.3 14.3
Marengo 26 19.328 37.9 184.1 9.4
Marengo 27 27.216 52.9 240.3 15.3
Marengo 28 23.096 42.7 192.1 15
Marengo 29 17.824 54.9 199 13.5
Marengo 30 19.144 44 181.1 11.8
Marengo 31 21.6 42.2 181.2 9.3
ression Statistics
0.929025
0.863088
0.847875
2.30673
31
df SS
3 905.669817744951
27 143.667138126017
30 1049.33695587097
Coefficients Standard Error
-13.44765 4.45379402893311
-0.186728 0.0554383632621942
0.041301 0.206640301103274
0.220802 0.017223150084434
4a
Intercept
Price
(in lakh rupees)
Mileage
(Km/ltr)
Top speed (Km/hr)
4b
Predicted sales (Y) = -13.44764889+ (-0.186728172* Price) +(0.220801682*Speed)
4c
25.264849278
5 - Predicted Profit = sales* ( price - Cost )
202118.79424
Marengo Model
Which car is most affected by 1 lakh price increase
Old sales
New Sales
Change
8 - Return the regression using only significant variables & compare the adjusted r square
Parameter
R Square
Adjusted R Square
MS F Significance F
301.889939248317 56.7355100548808 0.00
5.32100511577839
t Stat P-value Lower 95% Upper 95%Lower 95.0%Upper 95.0%
-3.01936928402737 0.00547896316725 -22.586079391 -4.309218 -22.58608 -4.309218
-3.36821221134266 0.002288376733801 -0.3004782976 -0.072978 -0.300478 -0.072978
0.199869951641267 0.843080033902266 -0.3826896887 0.465292 -0.38269 0.465292
12.820052136582 5.388274943617E-13 0.18546269711 0.256141 0.185463 0.256141
Coefficients P-value p<0.05, sign
-13.4476488883451 0.00547896316725 Significant
-0.18672817211657 0.002288376733801 Significant
0.041301186988648 0.843080033902266 not significant
0.22080168203862 0.00 Significant
Regression Equation
Sales
25.264849278
25.078121106
-0.186728172
Marengo
All Variables Significant variables
0.863087698072379 0.862885128727765
0.847875220080421 0.853091209351177
SUMMARY OUTPUT - non significant
Regression Statistics
Multiple R 0.928916
R Square 0.862885
Adjusted R Square 0.853091
Standard Error 2.266839
Observations 31
ANOVA
df SS MS F Significance F
Regression 2 905.4573 452.7286 88.10417 8.302E-13
Residual 28 143.8797 5.138561
Total 30 1049.337
Coefficients
Standard Error t Stat P-value Lower 95%
Intercept -12.97013 3.69376 -3.511363 0.001531 -20.53646
Price
(in lakh rupees) -0.182474 0.050304 -3.627423 0.00113 -0.285517
Top speed (Km/hr) 0.22014 0.01661 13.25378 1.38E-13 0.186117
Significance F
Upper 95%Lower 95.0%
Upper 95.0%
-5.403807 -20.53646 -5.403807
-0.079431 -0.285517 -0.079431
0.254163 0.186117 0.254163