Scribd Logo
Upload

Welcome to Scribd!

  • 102 views

    Regression Analysis

    Uploaded by

    Sufiya
    The document contains sales data for 31 Marengo car models including sales volume, price, mileage, and top speed. A regression analysis was performed to determine the relationship between sales volume and the other variables. The regression found that price and top speed were significant predictors of sales volume, while mileage was not a significant predictor. Specifically, sales volume decreased with increased price and increased with higher top speed. The analysis suggests the regression model is a good fit with an R-squared value of 0.86.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Regression Analysis

    Uploaded by

    Sufiya
    102 views9 pages
    The document contains sales data for 31 Marengo car models including sales volume, price, mileage, and top speed. A regression analysis was performed to determine the relationship between sales volume and the other variables. The regression found that price and top speed were significant predictors of sales volume, while mileage was not a significant predictor. Specifically, sales volume decreased with increased price and increased with higher top speed. The analysis suggests the regression model is a good fit with an R-squared value of 0.86.

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains sales data for 31 Marengo car models including sales volume, price, mileage, and top speed. A regression analysis was performed to determine the relationship between sales volume and the other variables. The regression found that price and top speed were significant predictors of sales volume, while mileage was not a significant predictor. Specifically, sales volume decreased with increased price and increased with higher top speed. The analysis suggests the regression model is a good fit with an R-squared value of 0.86.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    102 views9 pages

    Regression Analysis

    Uploaded by

    Sufiya
    The document contains sales data for 31 Marengo car models including sales volume, price, mileage, and top speed. A regression analysis was performed to determine the relationship between sales volume and the other variables. The regression found that price and top speed were significant predictors of sales volume, while mileage was not a significant predictor. Specifically, sales volume decreased with increased price and increased with higher top speed. The analysis suggests the regression model is a good fit with an R-squared value of 0.86.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 9

    Top

    Sales Price Mileage


    Cars speed
    (in 1,000 units) (in lakh rupees) (Km/ltr) (Km/hr)
    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
    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 Total profit
    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.997881
    R Square 0.995766
    Adjusted R Square 0.995356
    Standard Error 2.307792
    Observations 35

    ANOVA
    df SS MS F Significance F
    Regression 3 38827.62 12942.54 2430.112 7.4472712E-37 P> 0.5 regression is not
    Residual 31 165.103 5.325902
    Total 34 38992.72

    Coefficients
    Standard Error t Stat P-value Lower 95% Upper 95%
    Intercept 50.72313 5.292103 9.584683 8.739E-11 39.9298121862 61.51644

    Price
    (in lakh rupees) -0.795026 0.254333 -3.125926 0.003833 -1.3137421693 -0.276311
    Mileage
    (Km/ltr) 8.306331 0.100181 82.91298 5.784E-38 8.10200997005 8.510652
    Top speed (Km/hr) -0.018573 0.030558 -0.607776 0.547763 -0.0808964961 0.043751

    Salea+pice+Mileage
    50.7231+(0.7950)+8.3063

    Rocinan Mareng
    Specifications
    te36 o32
    Price 8 42
    Manufacturing cost 6 33
    22 15
    Mileage
    km/litre km/litre
    140 210
    Top speed
    km/hr km/hr
    total sales*(Price-Manufacturing cost)

    456000
    P> 0.5 regression is not possiable

    Lower 95.0%
    Upper 95.0%
    39.92981 61.51644 not sign

    -1.313742 -0.276311 Sign

    8.10201 8.510652 not sign


    -0.080896 0.043751 Sign
    Top
    Sales Price Mileage
    Cars speed
    (in 1,000 units) (in lakh rupees) (Km/ltr) (Km/hr)
    Marengo 1 20.896 42.5 9.3 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

    Total profit
    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.9290251332
    R Square 0.8630876981
    Adjusted R Square 0.8478752201
    Standard Error 2.3067303951
    Observations 31

    ANOVA
    df SS MS F Significance F
    Regression 3 905.669817745 301.88993925 56.73551 8.7448816E-12 Here p>0.5 regression is n
    Residual 27 143.667138126 5.3210051158
    Total 30 1049.336955871

    Coefficients Standard Error t Stat P-value Lower 95% Upper 95%


    Intercept -13.447648888 4.453794028933 -3.019369284 0.005479 -22.586079391 -4.309218

    Price
    (in lakh rupees) -0.1867281721 0.055438363262 -3.3682122113 0.002288 -0.3004782976 -0.072978
    Mileage
    (Km/ltr) 0.041301187 0.206640301103 0.1998699516 0.84308 -0.3826896887 0.465292
    Top speed (Km/hr) 0.220801682 0.017223150084 12.820052137 5.388E-13 0.18546269711 0.256141

    Specifications Rocinante36 Marengo32


    Price 8 42
    Manufacturing cost 6 33
    Mileage 22 km/litre 15 km/litre
    Top speed 140 km/hr 210 km/hr

    total sales*(Price-
    Manufacturing cost)

    468189
    Here p>0.5 regression is not possiable

    Lower 95.0%
    Upper 95.0%
    -22.58608 -4.309218 Significance

    -0.300478 -0.072978 Significance

    -0.38269 0.465292 not Significance


    0.185463 0.256141 not Significance
    With an increase in price of 1 lakh for each model:

    Rocinante36:
    Sales Price – Manufactured Cost
    8Lacks - 6 Lacks = 2Lacks
    Profit is 227.8972*2Lacks = 455.7944

    Marengo32:
    Sales Price – Manufactured Cost
    42Lacks - 33Lacks = 9Lacks
    Profit is 25.26485*8= 227.383 lacks

    You might also like