Question
he data below is from an operation where it is showing labor hours and machine hours (independent variables) and resulting overhead cost in dollars (dependent
he data below is from an operation where it is showing labor hours and machine hours (independent variables) and resulting overhead cost in dollars (dependent variable). The data is for 52 weeks of operation. Run a multiple regression analysis to determine if there is a linear relationship between overhead dollars to labor hours and machine hours. Answer the following questions. Use either SPSS or excel to conduct the regression analysis.
a. What is the Coefficient of Determination from the regression results?
b. What is the linear equation for determining overhead dollars?
c. What would be the value of overhead for 520 labor hours and 335 machine hours
d. Provide an ANOVA table for the regression model
e. is there a relationship between the independent and dependent variables (x and y) at a Test at alpha equal to .05? I. What is the Calculated F value? II. What is the Critical F Value? III. What is the P-Value? IV. Is there a relationship between x and y? Explain*
f. Conduct a utility test at the alpha equal .05 level to determine if the labor hours variable contributes to model relationship. Does the labor hours variable contribute to the relationship of x and y? Why or why not?*
g. Conduct a utility test at the alpha equal .05 level to determine if the machine hours variable contributes to model relationship. Does the machine hours variable contribute to the relationship of x and y? Why or why not?*
h. Conduct a utility test at the alpha equal .05 level to determine if the intercept constant contributes to model relationship. Does the intercept constant contribute to the relationship? Why or why not?*
Weeks:1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
Overhead ($): 53421 44167 60085 55181 44484 68154 49415 63090 55935 56159 51862 54799 42067 49108 55467 53907 64376 48639 77800 54077 29521 43676 51639 57315 35410 59348 47437 49433 55003 57783 57084 69759 51315 52124 62643 48950 54092 58513 57237 56184 65824 44095 55454 36927 48322 39093 58789 70844 38749 60821 65585 77651
Labor Hrs: 695 531 839 379 602 807 515 851 774 766 537 642 434 741 995 675 935 638 1128 744 180 188 755 1014 371 758 662 721 811 944 1184 1024 772 635 630 417 665 682 1046 887 706 520 813 387 444 725 875 1026 407 815 706 1231
Machine Hrs: 239 173 329 335 152 365 276 314 289 140 311 215 199 143 144 245 261 232 361 191 172 254 187 244 181 280 185 172 229 176 159 290 162 244 286 246 257 286 228 194 437 204 261 179 265 144 223 372 199 256 372 338
Please fully answer parts E to H including the explanations.
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