Prob 12.4 - 10365.00 means 60.00 43.00 b1 = (E7 -...

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

View Full Document Right Arrow Icon
2d46d6bd5ae1b987682a6c951bda9ba324e0dd2f.xls data % working 67 49 45 21 73 65 54 47 61 33 % management 20 40 60 80 20 40 60 80 % working % management 20 40 60 80 20 40 60 80 f(x) = 1.3x - 35 R² = 0.72 % working 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
Background image of page 1

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

View Full DocumentRight Arrow Icon
2d46d6bd5ae1b987682a6c951bda9ba324e0dd2f.xls data A B C D E F G H I J K L 37 38 39 40 41 42 43
Background image of page 2
2d46d6bd5ae1b987682a6c951bda9ba324e0dd2f.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
Background image of page 3

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

View Full DocumentRight Arrow Icon
2d46d6bd5ae1b987682a6c951bda9ba324e0dd2f.xls data M N O P Q R S T U 37 38 39 40 41 42 43
Background image of page 4
2d46d6bd5ae1b987682a6c951bda9ba324e0dd2f.xls regression calcs calcs x^2 x*y y^2 67 49 4489 3283 2401 45 21 2025 945 441 73 65 5329 4745 4225 54 47 2916 2538 2209 61 33 3721 2013 1089 sums 300.00 215.00 18480.00 13524.00
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 10365.00 means 60.00 43.00 b1 = (E7 - (5*B8*C8)) / (D7 - (5*B8^2)) = 1.30 b0 = C8 - (E11*B8)-35.00 Therefore, by regression, the single straight line which best models the data is: Y = 1.30*x - 35.0 where Y is the calculated % management expected for x % working. r = (E15 - (12*A16*B16)) / SQRT((C15-(12*A16^2))*(D15-(12*B16^2))) = 0.8510 R^2 = r x r = 0.7243 height (in, x) weight (lbs, y) 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...
View Full Document

Page1 / 5

Prob 12.4 - 10365.00 means 60.00 43.00 b1 = (E7 -...

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

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