{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

HW04b_sol_X - Problem 6-12 Direct Labor Cost vs Copies...

Info icon This preview shows pages 1–14. Sign up to view the full content.

View Full Document Right Arrow Icon
Problem 6-12 Direct Labor Cost vs. Copies Produced Copies Produced Direct Labor Cost Residuals Copies Produced Sample Population Correlation coefficient 0.867 0.846 Intercept 0.83112 0.94755 Slope 0.00500 0.00469 0.41413 0.41853 0.752 0.716 0.00068 0.00025 t 7.379 18.669 s yx R 2 s b1 0 50 100 150 200 250 30 0.0 1.0 2.0 3.0 4.0 Direct Labor Cost vs. Copie Copies Produced Direct Labor Cost 0 50 100 150 200 250 30 (1.00) (0.50) 0.00 0.50 1.00 Residuals Copies Produced Residuals
Image of page 1

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

View Full Document Right Arrow Icon
Point forecast 2.080 2.119 0.424 0.420 s f
Image of page 2
00 350 400 450 500 es Produced 00 350 400 450 500
Image of page 3

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

View Full Document Right Arrow Icon
Obs. X Y 4 20 1.3 9 40 1.4 22 80 0.6 30 110 1.2 31 110 0.8 43 160 1.7 45 170 1.6 56 200 2.5 67 240 1.6 79 290 2.8 87 300 2.0 92 320 2.8 99 350 2.5 100 350 2.8 107 370 2.6 110 390 2.9 113 400 2.7 118 420 3.5 125 450 2.4 127 450 3.0 - - Total 5,220 42.7 - - Count 20 Average 261 2.1 Percent of total Min 0.6 20 Max 3.5 450 CORREL 0.867 Correlation coefficient 0.867 LINEST 0.83112 Intercept 0.83112 LINEST 0.00500 Slope 0.00500 LINEST 0.41413 0.41413 LINEST 0.752 0.752 75.2% of th LINEST 0.00068 0.00068 t = 7.379 250 Point forecast = 2.080 0.424 Interval 1.344 2.816 s yx = R 2 = s b1 = s f =
Image of page 4
Image of page 5

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

View Full Document Right Arrow Icon
XY Yhat (Y - Yhat) 400 1.7 26 58,081 0.93 0.37 0.70 1,600 2.0 56 48,841 1.03 0.37 0.54 6,400 0.4 48 32,761 1.23 (0.63) 2.36 12,100 1.4 132 22,801 1.38 (0.18) 0.87 12,100 0.6 88 22,801 1.38 (0.58) 1.78 25,600 2.9 272 10,201 1.63 0.07 0.19 28,900 2.6 272 8,281 1.68 (0.08) 0.29 40,000 6.3 500 3,721 1.83 0.67 0.13 57,600 2.6 384 441 2.03 (0.43) 0.29 84,100 7.8 812 841 2.28 0.52 0.44 90,000 4.0 600 1,521 2.33 (0.33) 0.02 102,400 7.8 896 3,481 2.43 0.37 0.44 122,500 6.3 875 7,921 2.58 (0.08) 0.13 122,500 7.8 980 7,921 2.58 0.22 0.44 136,900 6.8 962 11,881 2.68 (0.08) 0.22 152,100 8.4 1131 16,641 2.78 0.12 0.59 160,000 7.3 1080 19,321 2.83 (0.13) 0.32 176,400 12.3 1470 25,281 2.93 0.57 1.86 202,500 5.8 1080 35,721 3.08 (0.68) 0.07 202,500 9.0 1350 35,721 3.08 (0.08) 0.75 - - - - - - 1,736,600 103.6 13,014 374,180 0.00 12.43 - - - - - - 100.0% (0.68) 0.67 he total variation in y can be explained by the linear relationship between x and y X 2 Y 2 (X - Xavg) 2 (Y - Yavg) 2
Image of page 6
Image of page 7

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

View Full Document Right Arrow Icon
Residual terms in terms of standard errors 1.45 0.14 0.89 1.22 0.14 0.89 0.82 0.40 1.52 0.57 0.03 0.44 0.57 0.34 1.40 0.25 0.00 0.17 0.21 0.01 0.19 0.09 0.45 1.62 0.01 0.18 1.04 0.02 0.27 1.26 0.04 0.11 0.80 0.09 0.14 0.89 0.20 0.01 0.19 0.20 0.05 0.53 0.30 0.01 0.19 0.42 0.01 0.29 0.48 0.02 0.31 0.63 0.33 1.38 0.89 0.46 1.64 0.89 0.01 0.19 - - 9.34 3.09 - - 75.2% 24.8% 0.17 1.64 (Yhat - Yavg) 2 (Y - Yhat) 2
Image of page 8
Problem 6-14 Market Value vs. Assessed Value Market Value Assessed Value Correlation coefficient 0.613 Parcel 1 Intercept 60.71056 2 Slope 0.41350 3 4 2.44521 5 6 0.376 7 8 0.10067 9 t = 4.107 10 11 Point forecast = 98.132 12 2.900 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 s yx = R 2 = s b1 = s f = 60 70 80 85 90 95 100 Market Value vs. Assess Assessed Value Market Value
Image of page 9

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

View Full Document Right Arrow Icon
Image of page 10
Image of page 11

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

View Full Document Right Arrow Icon
Residual (1.5) (3.6) (0.2) 0.1 2.1 0.6 (3.7) (0.4) (1.4) (0.2) (0.2) (0.9) (0.1) (0.3) 1.3 (2.9) 2.8 (1.2) (0.8) (2.2) (1.7) (3.0) (1.7) 3.7 1.4 6.7 4.1 (1.4) 3.2 1.4 80 90 sed Value
Image of page 12
Assessed Market Parcel X Y 1 68.2 87.4 2 74.6 88.0 3 64.6 87.2 4 80.2 94.0 5 76.0 94.2 6 78.0 93.6 7 76.0 88.4 8 77.0 92.2 9 75.2 90.4 10 72.4 90.4 11 80.0 93.6 12 76.4 91.4 13 70.2 89.6 14 75.8 91.8 15 79.2 94.8 16 74.0 88.4 17 72.8 93.6 18 80.4 92.8 19 74.2 90.6
Image of page 13

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

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

{[ snackBarMessage ]}