The data to the left 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 excel to conduct the regression analysis.

PLEASE PROVIDE STEP BY STEP AND EXCEL COMMANDS FOR A BETTER UNDERSTANDNG.

THANKS

a. What is the Coefficient of Determination from the regression results?

b. What is the linear equation for determining over head 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. Test at alpha equal to .05?

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?

Week	Overhead ($)	LaborHrs	MachineHrs
1	53421	695	239
2	44167	531	173
3	60085	839	329
4	55181	379	335
5	44484	602	152
6	68154	807	365
7	49415	515	276
8	63090	851	314
9	55935	774	289
10	56159	766	140
11	51862	537	311
12	54799	642	215
13	42067	434	199
14	49108	741	143
15	55467	995	144
16	53907	675	245
17	64376	935	261
18	48639	638	232
19	77800	1128	361
20	54077	744	191
21	29521	180	172
22	43676	188	254
23	51639	755	187
24	57315	1014	244
25	35410	371	181
26	59348	758	280
27	47437	662	185
28	49433	721	172
29	55003	811	229
30	57783	944	176
31	57084	1184	159
32	69759	1024	290
33	51315	772	162
34	52124	635	244
35	62643	630	286
36	48950	417	246
37	54092	665	257
38	58513	682	286
39	57237	1046	228
40	56184	887	194
41	65824	706	437
42	44095	520	204
43	55454	813	261
44	36927	387	179
45	48322	444	265
46	39093	725	144
47	58789	875	223
48	70844	1026	372
49	38749	407	199
50	60821	815	256
51	65585	706	372
52	77651	1231	338