Question

The business problem facing the director of broadcasting operations for a television station was the issue of standby hours (i.e hours in which employees at the station are paid but are not actually involved in any activity) and what factors were related to standby hours. The study included the following variables:

Standby Hours (Y)- Total number of standby hours in a week.

Weekly staff count (X₁)- Weekly total of people-days

Remote engineering hours (X₂)- Total number of engineering hours worked by employees at locations away from the central plant.

Data was collected for 26 weeks:

Standby	Total Staff	Remote
245	338	414
177	333	598
271	358	656
211	372	631
196	339	528
135	289	409
195	334	382
118	293	399
116	325	343
147	311	338
154	304	353
146	312	289
115	283	388
161	307	402
274	322	151
245	335	228
201	350	271
183	339	440
237	327	475
175	328	347
152	319	449
188	325	336
188	322	267
197	317	235
261	315	164
232	331	270

a.) determine whether there is a significant relationship between standy hours and the twon independent variables (total staff presnet and remote engineering hours) at the 0.05 level of significance (please show work)

b.) interpret the meaning of the p-value (and please explain why)

c.) compute the coefficent of multiple determination, r² , and interpret its meaning (show work/explain)

d.) compute the adjusted r²

e) What is the p-value and interpret its results?

^{Please use in depth Excel}

Answer 1