Report Calculation Toyota Camry.xlsx - Miles(1000s Price($1000s 22 16.2 29 16 36 13.8 47 11.5 63 12.5 77 12.9 73 11.2 87 13 92 11.8 101 10.8 110 8.3 28

Report Calculation Toyota Camry.xlsx - Miles(1000s...

This preview shows page 1 - 8 out of 8 pages.

Miles (1000s) Price ($1000s) 22 16.2 29 16 36 13.8 47 11.5 63 12.5 77 12.9 73 11.2 87 13 92 11.8 101 10.8 110 8.3 28 12.5 59 11.1 68 15 68 12.2 91 13 42 15.6 65 12.7 110 8.3 0 20 0 2 4 6 8 10 12 14 16 18
Image of page 1
Image of page 2
SUMMARY OUTPUT Regress Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total Intercept Miles (1000s) RESIDUAL OUTPUT Observation 1 2 3 4 5 6 7 8 9 10 11 40 60 80 100 120 Price ($1000s)
Image of page 3
12 13 14 15 16 17 18 19
Image of page 4
sion Statistics 0.7339328287 0.538657397 0.5115195968 1.5413769786 19 df SS MS F ignificance F 1 47.1580375885 47.15804 19.84897 0.000348 17 40.3893308325 2.375843 18 87.5473684211 Coefficients Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0% 16.4697550331 0.9487641533 17.35917 2.99E-012 14.46804 18.47147 14.46804 -0.0587739319 0.0131921552 -4.455218 0.000348 -0.086607 -0.030941 -0.086607 Regression Equation Predicted Price ($1000s) Residuals Y = 16.4697+(-0.0588)X
Image of page 5
Image of page 6
Image of page 7
Image of page 8

You've reached the end of your free preview.

Want to read all 8 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture