Prob 12.1

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

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

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

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

View Full Document
52f7ab13951f6e9625ba6b70c98c0f9b00d8128c.xls data A B C D E F G H I J K L 38 39 40 41 42 43
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

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

View Full Document
52f7ab13951f6e9625ba6b70c98c0f9b00d8128c.xls data M N O P Q R S T U 38 39 40 41 42 43
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.

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

View Full Document
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
Ask a homework question - tutors are online