QBA Homework 5.xlsx - Model Fierro 7B HX 5000 Durbin Ultralight Schmidt WSilton Advanced bicyclette v\u00e9lo Supremo Team XTC Racer D\u2019Onofrio Pro

QBA Homework 5.xlsx - Model Fierro 7B HX 5000 Durbin...

This preview shows page 1 - 25 out of 75 pages.

Model Weight Price Fierro 7B 17.9 2200 HX 5000 16.2 6350 Durbin Ultralight 15.0 8470 Schmidt 16.0 6300 WSilton Advanced 17.3 4100 bicyclette vélo 13.2 8700 Supremo Team 16.3 6100 XTC Racer 17.2 2680 D’Onofrio Pro 17.7 3500 Americana #6 14.2 8100 SUMMARY OUTPUT Regression Statistics Multiple R 0.929366 R Square 0.863722 Adjusted R Square 0.846687 Standard Error 942.2661 Observations 10 ANOVA df SS MS F ignificance F Regression 1 45017877 45017877 50.703498131 9.99E-005 Residual 8 7102923 887865.3 Total 9 52120800 Coefficients tandard Erro t Stat P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% Intercept 28818.00 3267.257 8.820244 2.14888E-005 21283.7 36352.31 21283.7 36352.31 Weight -1439.006 202.0895 -7.120639 9.99374E-005 -1905.026 -972.9872 -1905.026 -972.9872 7232.9070837167 for price of 15lb bike
Image of page 1
Image of page 2
% 12.0 13.0 14.0 15.0 16.0 17.0 18.0 19.0 0 1000 2000 3000 4000 5000 6000 7000 8000 9000 10000 Weight Price
Image of page 3
Image of page 4
Image of page 5
Image of page 6
Image of page 7
Image of page 8
13 17.0 10 22.0 20 30.0 28 37.0 32 47.0 17 30.5 24 32.5 31 39.0 40 51.5 38 40.0 SUMMARY OUTPUT Regression Statistics Multiple R 0.9252981946 R Square 0.8561767488 Adjusted R Square 0.8381988424 Standard Error 4.2496183853 Observations 10 ANOVA df SS MS F ignificance F Regression 1 860.0509 860.0509 47.62383 0.000124 Residual 8 144.4741 18.05926 Total 9 1004.525 Coefficients tandard Erro t Stat P-value Lower 95%Upper 95% Intercept 10.5279568756 3.744867 2.811303 0.022797 1.892277 19.16364 Weekly Usage (hours 0.9534404397 0.13816 6.901002 0.000124 0.634844 1.272037 20.4229255585 maintenance contract for $3000/year is close to regression line. Weekly Usage (hours) Annual Maintenance Expense Annu
Image of page 9
Image of page 10
Lower 95.0% Upper 95.0% 1.892277 19.16364 0.634844 1.272037 5 10 15 20 25 30 35 40 45 0.0 10.0 20.0 30.0 40.0 50.0 60.0 Weekly Usage ual Maintenance
Image of page 11
Image of page 12
Image of page 13
Image of page 14
Image of page 15
Image of page 16
Age of Bus (years) Annual Maintenance Cost ($) 1 350 2 370 2 480 2 520 2 590 3 550 4 750 4 800 5 790 5 950 SUMMARY OUTPUT Regression Statistics Multiple R 0.9340776459 R Square 0.8725010485 Adjusted R Square 0.8565636796 Standard Error 75.4983443527 Observations 10 ANOVA df SS MS F ignificance Regression 1 312050 312050 54.74561 7.63E-005 Residual 8 45600 5700 Total 9 357650 Coefficients tandard Erro t Stat P-value Lower 95% Intercept 220.00 58.48077 3.761921 0.005529 85.14311 Age of Bus (years) 131.6666666667 17.79513 7.399028 7.63E-005 90.63102 680.845 annual maintenance cost for a 3.5 year old bus Maintena
Image of page 17
Image of page 18
F Upper 95%Lower 95.0% Upper 95.0% 354.8569 85.14311 354.8569 172.7023 90.63102 172.7023 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 0 100 200 300 400 500 600 700 800 900 1000 Age of Bus ance
Image of page 19
Image of page 20
Image of page 25

You've reached the end of your free preview.

Want to read all 75 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture