{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

HW04b_sol_X

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

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

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

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

View Full Document
Point forecast 2.080 2.119 0.424 0.420 s f
00 350 400 450 500 es Produced 00 350 400 450 500

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

View Full Document
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 =

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

View Full Document
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

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

View Full Document
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
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

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

View Full Document

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

View Full Document
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
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

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.

{[ snackBarMessage ]}