excel hw fr 33010

excel hw fr 33010 - SUMMARY OUTPUT Regression Statistics...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: SUMMARY OUTPUT Regression Statistics Multiple R 0.96 R Square 0.93 Adjusted R 0.92 Standard E 4.61 Observatio 10 ANOVA df SS MS F ignificance F Regression 1 2272 2272 106.92 Residual 8 170 21.25 Total 9 2442 Coefficients tandard Err t Stat P-value Lower 95%Upper 95% Lower 95.0%pper 95.0% Intercept 80 3.08 26.01 72.91 87.09 72.91 87.09 X Variable 4 0.39 10.34 3.11 4.89 3.11 4.89 % Person Years Sales(000'S0 1 1 80 2 3 97 3 4 92 4 4 102 5 6 103 6 8 111 7 10 119 8 10 123 9 11 117 10 13 136 SUMMARY OUTPUT Regression Statistics Multiple R 0.96 Y(X) = 80 + (4)16 R Square 0.93 Adjusted R 0.92 144000 sales Standard E 4.61 Observatio 10 ANOVA df SS MS F ignificance F Regression 1 2272 2272 106.92 Residual 8 170 21.25 Total 9 2442 Coefficients tandard Err t Stat P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% Intercept 80 3.08 26.01 72.91 87.09 72.91 87.09 X Variable 4 0.39 10.34 3.11 4.89 3.11 4.89 % SUMMARY OUTPUT Regression Statistics Multiple R 0.99 R Square 0.98 Adjusted R 0.98 Standard E 1.28 Observatio 7 ANOVA df SS MS F ignificance F...
View Full Document

  • Spring '10
  • Luksh
  • Military units and formations of the Waffen-SS, 95.0%, Friedrich-Wilhelm Bock, 1 2 3 4 5 6 7 8 9 10 Years, thous. Sq

{[ snackBarMessage ]}

Page1 / 19

excel hw fr 33010 - SUMMARY OUTPUT Regression Statistics...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online