DATA: 2055 1. What proportion of the variance in the dependent variable is accou
ID: 3307361 • Letter: D
Question
DATA:
2055
1. What proportion of the variance in the dependent variable is accounted for by the combined effect of the independent variables?
2. Does it appear that an appropriate number of variables are used? Explain.
3. Were any variables that were included in the initial solution not significant? If yes, list them.
4. Are there any outliers? If yes, list them.
5. What is the final regression equation?
Number of employees Number of production workers New capital expenditures End of year inventory Industrial group Cost of Materials 52 47 292 929 3 4219 74 63 454 1427 3 5357 13 12 20 325 3 1061 17 13 84 267 3 707 169 147 534 2083 3 10421 51 41 220 697 3 4140 55 44 176 1446 3 7125 84 76 423 1014 3 8994 61 47 464 1291 3 5504 27 22 22 356 4 716 200 178 200 2314 4 8926 294 250 189 2727 4 11121 38 32 29 682 4 2283 17 14 21 197 4 364 34 28 20 450 4 1813 1 1 2 17 4 71 31 25 16 526 4 1321 224 179 465 2747 4 12376 83 68 539 578 5 9661 172 147 1071 3979 5 19285 257 209 711 3329 5 18632 51 43 88 355 5 2170 82 68 182 580 5 7290 94 78 715 1604 5 8135 273 233 481 3535 6 12980 70 53 358 829 6 4011 37 29 128 447 6 5101 81 61 177 956 6 3755 54 39 109 718 6 2694 15 11 698 725 7 3279 116 90 3143 4257 7 20596 55 42 2360 1502 7 10604 212 163 1352 3976 7 24634 232 182 1750 5427 7 28963 403 136 1277 894 8 8483 121 16 311 1216 8 6940 136 57 618 3736 8 8863 69 25 144 874 8 2823 604 437 2959 4300 8 29572 41 28 198 688 8 3811 21 12 66 577 8 1047 65 50 130 504 82055
Explanation / Answer
1)
it is given by R^2 = 0.91722354 ,
hence 91.722 % of the variance in the dependent variable is accounted for by the combined effect of the independent variables
2)
the model has significance F = 1.32648E-20 << 0.05
hence the model is significant , it appear that an appropriate number of variables are used
3)
If p-value > 0.05 the variable is not significant
here p-value of wach independent variable is less than 0.05
hence all are significant
5)
y^ = 52.42166 + 20.3897 *number of production worker + 2.87935 * new capital expenditure + 2.94447 *end of year inventory
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.