HW04b_sol_X

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

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: 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 Point forecast 2.080 2.119 0.424 0.420 s f 00 350 400 450 500 es Produced 00 350 400 450 500 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 = 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 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 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....
View Full Document

Page1 / 40

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

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

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