Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Computer Homework 3 Develop a regression model using the manufacturing.xlsx file. Use Number of employees, Value Added by manufacturing, Value of industrial shipments, New capital
Computer Homework 3 Develop a regression model using the manufacturing.xlsx file. Use Number of employees, Value Added by manufacturing, Value of industrial shipments, New capital expenditures, and End of year inventory to predict Cost of materials. Set up and solve this problem in Excel. Use highlighting to emphasize important cells. Insert text boxes to provide answers to the following questions, based on your final output (run the regression a second time, if appropriate): 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 in the initial solution not significant? If yes, list them. 4. Are there any outliers? 5. What is the final regression equation? Please name your file in the following manner: [your last name] CH3, and save to your computer. Go to the Submit Computer Homework 3 link in this folder. Browse your computer to select your file and then submit. Number of Value of Number of production Value Added by Cost of industrial New capital End of year Industrial employees workers manufacturing Materials shipments expenditures inventory group 52 47 2471 4219 2 292 929 3 74 63 4307 5357 2 454 1427 3 13 12 673 1061 1 20 325 3 17 13 817 707 1 84 267 3 169 147 8986 10421 3 534 2083 3 51 41 3145 4140 2 220 697 3 55 44 4076 7125 2 176 1446 3 84 76 3806 8994 2 423 1014 3 61 47 4276 5504 2 464 1291 3 27 22 1239 716 1 22 356 4 200 178 9423 8926 3 200 2314 4 294 250 11045 11121 3 189 2727 4 38 32 1916 2283 1 29 682 4 17 14 599 364 1 21 197 4 34 28 2063 1813 1 20 450 4 1 1 34 71 1 2 17 4 31 25 1445 1321 1 16 526 4 224 179 10603 12376 3 465 2747 4 83 68 5775 9661 3 539 578 5 172 147 10404 19285 4 1071 3979 5 257 209 13274 18632 4 711 3329 5 51 43 1909 2170 1 88 355 5 82 68 4606 7290 2 182 580 5 94 78 5518 8135 2 715 1604 5 273 233 12464 12980 3 481 3535 6 70 53 5447 4011 2 358 829 6 37 29 2290 5101 2 128 447 6 81 61 4182 3755 2 177 956 6 54 39 2818 2694 2 109 718 6 15 11 2201 3279 2 698 725 7 116 90 18848 20596 4 3143 4257 7 55 42 9655 10604 3 2360 1502 7 212 163 15668 24634 4 1352 3976 7 232 182 25918 28963 4 1750 5427 7 403 136 30692 8483 4 1277 894 8 121 16 17982 6940 3 311 1216 8 136 57 17857 8863 3 618 3736 8 69 25 9699 2823 2 144 874 8 604 437 38407 29572 4 2959 4300 8 41 28 3878 3811 2 198 688 8 21 12 3989 1047 2 66 577 8 65 50 4388 2055 2 130 504 8
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started