Top
Sales Price Mileage
Cars speed
(in 1,000 units) (in lakh rupees) (Km/ltr)
Rocinante 1 171.877 6.1 15.8 (Km/hr)
168.2
Rocinante 2 139.796 6.1 12.1 149.6
Rocinante 3 178.947 9.9 17 173.4
Rocinante 4 140.022 5.8 11.6 170.6
Rocinante 5 186.476 10 17.2 175
Rocinante 6 192.123 6.5 17.6 173.1
Rocinante 7 175.085 5.5 16 184.6
Rocinante 8 146.882 8.4 13 175.7
Rocinante 9 202.847 6.6 19.3 166.7
Rocinante 10 149.933 8.8 13.3 175.4
Rocinante 11 171.579 9.5 15.8 150.9
Rocinante 12 201.512 9.2 19.2 140.5
Rocinante 13 142.604 8.1 11.7 150.2
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
Rocinante 17 202.875 5.8 19.7 178.9
Rocinante 18 204.406 7.7 19.5 168.2
Rocinante 19 107.331 7.2 7.5 164.7
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
Rocinante 36 227.897 7 22 140
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.99788
R Square 0.99577
Adjusted R Square 0.99536
Standard Error 2.30779
Observations 35
ANOVA
df SS MS
Regression 3 38827.618 12942.539
Residual 31 165.103 5.326
Total 34 38992.72097
Coefficients Standard Error t Stat
Intercept
Price 50.72313 5.292 9.585
(in lakh rupees)
Mileage -0.79503 0.254 -3.126
(Km/ltr) 8.30633 0.1 82.913
Top speed (Km/hr) -0.01857 0.031 -0.608
Regression Equation Sales = 50.723-0.795*Price+8.306*Mileage
Specifications Rocinante36 Marengo32
Price Rs 7 lakh Rs 41 lakh
Manufacturing cost Rs 6 lakh Rs 33 lakh
Mileage 22 km/litre 15 km/litre
Top speed 140 km/hr 210 km/hr
Car impacted by Price Increase
Specifications Rocinante36 Marengo32
Price Rs 7 lakh Rs 41 lakh
New Price 8 42
Manufacturing cost Rs 6 lakh Rs 33 lakh
Mileage 22 km/litre 15 km/litre
Top speed 140 km/hr 210 km/hr
adjusted R sqaure - New
regression removing Top speed
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.997855374
R Square 0.995715346
Adjusted R Square 0.995447556
Standard Error 2.28493913
Observations 35
ANOVA
df SS MS
Regression 2 38825.65067 19412.82534
Residual 32 167.0702985 5.220946829
Total 34 38992.72097
Coefficients Standard Error t Stat
Intercept
Price 47.77996402 2.113441421 22.60765951
(in lakh rupees)
Mileage -0.782925328 0.251041783 -3.118705252
(Km/ltr) 8.294466497 0.097287931 85.25689061
Rocinante36 Marengo32
Old adjusted R square 0.99536 0.84788
New adjusted R square 0.99545 0.85309
F Significance F
2430.112 0
P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
0 39.93 61.516 39.93 61.516
0.004 -1.314 -0.276 -1.314 -0.276
0 8.102 8.511 8.102 8.511
0.548 -0.081 0.044 -0.081 0.044
227890
Oevrall 227890
Predicted Profit
Regression EquatSales = 50.723- 227.095 227095
Old sales 227890
New Sales 227095
Impact -795
F Significance F
3718.257621 1.29E-38
P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
3.04E-21 43.47502472 52.08490332 43.47502472 52.08490332
0.003827345 -1.294280706 -0.271569949 -1.294280706 -0.271569949
2.60E-39 8.096297467 8.492635528 8.096297467 8.492635528
Top
Sales Price Mileage
Cars speed
(in 1,000 units) (in lakh rupees) (Km/ltr)
Marengo 1 20.896 42.5 9.3 (Km/hr)
199.4
Marengo 2 31.048 36 9.7 235.2
Marengo 3 29.904 54.7 16.6 240.8
Marengo 4 28.792 42.7 11.7 232.5
Marengo 5 16.776 44.9 13.7 188.8
Marengo 6 18.928 35.5 9.6 184.2
Marengo 7 22.776 51.3 13.7 207.7
Marengo 8 36.824 30.4 12.6 249.5
Marengo 9 22.216 38.4 16.2 175.8
Marengo 10 35.456 32.2 9.6 245.6
Marengo 11 28.576 59.4 11.3 223.3
Marengo 12 33.648 50.8 13.6 240
Marengo 13 33.44 57.5 13.5 250
Marengo 14 34.912 44.6 11.1 247.4
Marengo 15 24.016 34.6 14.1 192
Marengo 16 20.992 56.4 13.4 201.2
Marengo 17 21.696 41.4 12.8 193.3
Marengo 18 17.832 53.7 16 202
Marengo 19 25.624 44.8 12.7 208.9
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
Marengo 32 25.2648 41 210 15
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.929025133
R Square 0.863087698
Adjusted R Square 0.84787522
Standard Error 2.306730395
Observations 31
ANOVA
df SS MS F
Regression 3 905.67 301.89 56.736
Residual 27 143.667 5.321
Total 30 1049.337
Coefficients Standard Error t Stat P-value
Intercept
Price -13.44765 4.454 -3.019 0.005
(in lakh rupees)
Mileage -0.18673 0.055 -3.368 0.002
(Km/ltr) 0.0413 0.207 0.2 0.843
Top speed (Km/hr) 0.2208 0.017 12.82 0
Regression Equation Sales = -13.447-0.186*Price+0.220*Top Speed 25.127
Oevrall Predicted
Specifications Rocinante36 Marengo32 Profit
Price Rs 7 lakh Rs41 lakh
Manufacturing cost Rs 6 lakh Rs 33 lakh
Mileage 22 km/litre 15 km/litre
Top speed 140 km/hr 210 km/hr
Car impacted by Price Increase
Regression
Specifications Rocinante36 Marengo32 Equation
Price Rs 7 lakh Rs 41 lakh Old sales
New Price 8 42 New Sales
Manufacturing cost Rs 6 lakh Rs 33 lakh Impact
Mileage 22 km/litre 15 km/litre
Top speed 140 km/hr 210 km/hr
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.928916104
R Square 0.862885129
Adjusted R Squa 0.853091209
Standard Error 2.266839379
Observations 31
ANOVA
df SS MS
Regression 2 905.4572542 452.7286271
Residual 28 143.8797016 5.138560772
Total 30 1049.336956
Coefficients Standard Error t Stat
Intercept
Price -12.97013136 3.693759764 -3.511363
(in lakh rupees) -0.18247382 0.05030398 -3.62742313
Top speed (Km/h 0.22013989 0.016609587 13.25378439
Significance F
0
25127
201016
Sales = -13.448-
0.187*Price+0.221*Top Speed 25.108 25108
25295
25108
-187
F Significance F
88.10416908 8.30E-13
P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
0.001530549 -20.53645524 -5.403807481 -20.53645524 -5.40381
0.001130003 -0.285516852 -0.079430788 -0.285516852 -0.07943
1.38E-13 0.186116693 0.254163088 0.186116693 0.254163