Ch 8 HW 6.xlsx - Year 1 2 3 4 5 6 7 8 Cost\/Unit($ 20.0 24.5 28.2 27.5 26.6 30.0 31.0 36.0 15.93 35.92 Cost\/Unit($ 40.0 35.0 30.0 25.0 20.0 15.0 10.0 5.0

Ch 8 HW 6.xlsx - Year 1 2 3 4 5 6 7 8 Cost/Unit($ 20.0...

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

Year Cost/Unit ($) 1 20.0 2 24.5 3 28.2 4 27.5 5 26.6 6 30.0 7 31.0 8 36.0 15.93 35.92
Image of page 1
Trend Pattern 0 1 2 3 4 5 6 7 8 9 0.0 5.0 10.0 15.0 20.0 25.0 30.0 35.0 40.0 Cost/Unit ($)
Image of page 2
SUMMARY OUTPUT Regression Statistics Multiple R 0.92187792 R Square 0.8498589 Adjusted R S 0.82483538 Standard Erro 1.97256983 Observations 8 ANOVA df SS MS F Significance F Regression 1 132.14881 132.14881 33.9624085 0.00112321 Residual 6 23.3461905 3.89103175 Total 7 155.495 CoefficientsStandard Erro t Stat P-value Lower 95% Upper 95% Intercept 19.99 1.53701403 13.0075957 1.272E-005 16.2319193 23.753795 Year 1.77 0.30437413 5.82772756 0.00112321 1.02903285
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 4 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes