Steel production

Steel production - A B C D E F G H 1 2 3 4 5 6 7 8 9 10 11...

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

View Full Document Right Arrow Icon
ee5b8919ce29b5b79f3c614b28060224211a078a.xls Year Index, x Output, y (ktons) x*y x^2 y^2 1986 1 9.4 9.4 1 88.36 1987 2 10.7 21.4 4 114.49 1988 3 11.0 33 9 121 1990 5 16.2 81 25 262.44 1991 6 22.1 132.6 36 488.41 1992 7 25.8 180.6 49 665.64 1993 8 23.0 184 64 529 1994 9 24.7 222.3 81 610.09 1995 10 27.3 273 100 745.29 1996 11 31.6 347.6 121 998.56 Sums 62 201.8 1484.9 490 4623.28 Means 6.2 20.18 b1 = (D13-(10*B15*C15))/(E13-(10*B15*B15)) = 2.213 b0 = C15 - (E18*B15) = 6.457 r = (D13-(10*B15*C15)) / SQRT((E13-(10*B15*B15))*(F13-(10*C15*C15))) = 0.9690 R^2 = r*r = 0.9390 Y = 2.213*x + 6.457, Y in ktons and x a year counter 0 2 4 6 8 10 12 0.0 5.0 10.0 15.0 20.0 25.0 30.0 35.0 9.4 10.7 11.0 16.2 22.1 25.8 23.0 24.7 27.3 31.6 f(x) = 2.21x + 6.46 R² = 0.94 Year Index (x) Annual Output (y, ktons)
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: A B C D E F G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 ee5b8919ce29b5b79f3c614b28060224211a078a.xls SUMMARY OUTPUT Regression Statistics Multiple R 0.97 R Square 0.94 Adjusted R Square 0.93 Standard Error 2.05 Observations 10 ANOVA df SS MS F Significance F Regression 1 517.37 517.37 123.24 Residual 8 33.58 4.2 Total 9 550.96 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 6.46 1.4 4.63 3.24 9.68 X Variable 1 2.21 0.2 11.1 1.75 2.67...
View Full Document

This note was uploaded on 01/26/2011 for the course OM 210 taught by Professor Singer during the Fall '08 term at George Mason.

Page1 / 2

Steel production - A B C D E F G H 1 2 3 4 5 6 7 8 9 10 11...

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

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