Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematics For Liberal Arts Majors

Authors: Christopher Thomas

1st Edition

0071544305, 9780071544306

More Books

Students also viewed these Mathematics questions

Question

4. What is the goal of the others in the network?

Answered: 1 week ago

Question

2. What we can learn from the past

Answered: 1 week ago