#### Question Details

The business problem facing the director of broadcasting operations for a television station was the issue of standby hours (i.e., hours in which unionized graphic artists 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

Total staff present (X1)?Weekly total of people-days

Remote hours (X2)?Total number of hours worked by employees at locations away from the central plant

Data were collected for 26 weeks; these data are organized and stored in [Standby].?Perform a multiple regression in Excel.

 Standby Total Staff Remote Dubner Total Labor 245 338 414 323 2001 177 333 598 340 2030 271 358 656 340 2226 211 372 631 352 2154 196 339 528 380 2078 135 289 409 339 2080 195 334 382 331 2073 118 293 399 311 1758 116 325 343 328 1624 147 311 338 353 1889 154 304 353 518 1988 146 312 289 440 2049 115 283 388 276 1796 161 307 402 207 1720 274 322 151 287 2056 245 335 228 290 1890 201 350 271 355 2187 183 339 440 300 2032 237 327 475 284 1856 175 328 347 337 2068 152 319 449 279 1813 188 325 336 244 1808 188 322 267 253 1834 197 317 235 272 1973 261 315 164 223 1839 232 331 270 272 1935

1. State the multiple regression equation.
2. determine whether there is a significant relationship between standby hours and the two independent variables (total staff present and remote hours) at the 0.05 level of significance.

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Oct 07, 2020

Solution~0002174721.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Oct 07, 2020

EXPERT

Tutor