Prob 12.1 - r = (E15 - (12*A16*B16)) /

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

View Full Document Right Arrow Icon
52f7ab13951f6e9625ba6b70c98c0f9b00d8128c.xls data x y 1 3 2 7 3 5 4 11 5 14 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 0 2 4 6 8 10 12 14 16 Age (years) Maintence cost ($/year) A B C D E F G H I J K L 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
Background image of page 1

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

View Full DocumentRight Arrow Icon
52f7ab13951f6e9625ba6b70c98c0f9b00d8128c.xls data A B C D E F G H I J K L 38 39 40 41 42 43
Background image of page 2
52f7ab13951f6e9625ba6b70c98c0f9b00d8128c.xls data M N O P Q R S T U 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
Background image of page 3

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

View Full DocumentRight Arrow Icon
52f7ab13951f6e9625ba6b70c98c0f9b00d8128c.xls data M N O P Q R S T U 38 39 40 41 42 43
Background image of page 4
52f7ab13951f6e9625ba6b70c98c0f9b00d8128c.xls regression calcs x y x^2 x*y y^2 1 3 1 3 9 2 7 4 14 49 3 5 9 15 25 4 11 16 44 121 5 14 25 70 196 sums 15 40 55 146 400 means 3 8 b1 = (E7 - (5*B8*C8)) / (D7 - (5*B8^2)) = 2.60 b0 = C8 - (E11*B8) 0.20 Therefore, by regression, the single straight line which best models the entire demand time series is: Y = 2.60*x + 0.20 where Y is the calculated value expected for y for a value x.
Background image of page 5

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

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

Unformatted text preview: r = (E15 - (12*A16*B16)) / SQRT((C15-(12*A16^2))*(D15-(12*B16^2))) = 0.9192 R^2 = r x r = 0.8450 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 52f7ab13951f6e9625ba6b70c98c0f9b00d8128c.xls regression graphs x y 1 3 2 7 3 5 4 11 5 14 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 2 4 6 8 10 12 14 16 f(x) = 2.6x + 0.2 R = 0.85 x y 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 2 4 6 8 10 12 14 16 x A B C D E F G H I J 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...
View Full Document

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

Page1 / 6

Prob 12.1 - r = (E15 - (12*A16*B16)) /

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