Purchase Solution

Regression Analysis using Standby Hours

Not what you're looking for?

Ask Custom Question

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 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 (Excel attached)
A. Use Excel to state the multiple regression equation. Make sure to explain any verbal answers with reference to the appropriate table and numbers.
B. Interpret the meaning of the slopes, bi and b2.
C. Explain why the regression coefficient, b0, has no practical meaning in the context of this problem.
D. Predict the standby hours for a week in which the total staff present have 310 people-days and the remote hours are 400.
E. Interpret the estimated adjusted coefficient of determination and construct a 95% confidence interval estimate for the mean standby hours for weeks in which the total staff present have 310 people-days and the remote hours are 400.

Attachments
Purchase this Solution
Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

View More Free Quizzes
Related BrainMass Solutions

  • Multiple Regression Analysis

    State the multiple regression equation for predicting labor hours, using the number of cubic feet moved and whether there is an elevator. b. Interpret the regression coefficients in (a). c.

  • Multiple Regression & Time Series Analysis

    State the multiple regression equation for predicting labor hours, using the number of cubic feet moved and whether there is an elevator. b. Interpret the regression coefficients in ( a). c.

  • Multiple Regression Analysis & Time-Series Forecasting

    State the multiple regression equation for predicting labor hours, using the number of cubic feet moved and whether there is an elevator B. Interpret the regression coefficients in (a) C.

  • Multiple Regression Analysis & Time-Series Forecasting

    414477 Multiple Regression Analysis and Time-Series Forecasting...

  • Systems Engineering or Statics for MTBF and probability of failure

    Calculate the reliability of a system consisting of one operating unit and one identical standby unit operating for a period of 200 hours.

  • Regression Analysis for US Navy's 16 selected hospitals

    Navy selected 16 hospitals that it believes to be efficiently run and conducted a regression analysis to evaluate the performance of its hospitals in terms of how many labor hours are used relative to how many labor hours are needed.

  • THE HOSPITAL LABOR NEEDS CASE

    (Fig 1) gives the Excel output of a regression analysis of the data using the model Excel Output of a Regression Analysis of the Hospital Labor Needs Data Using the Model y = b0 + b1 x1 + b2 x2 + b3 x3 + e days (a hospital has one occupied bed day

  • Overhead Costing High-Low Method

    The analysis should be useful in helping predict variable and fixed costs under normal operating conditions. B. Prepare an estimate of overhead cost for a volume of 3,000 machine hours by using Regression No. 1. C.

  • Statistics Analysis and Efficiency Tests

    Navy selected 16 hospitals that it believes to be efficiently run and conducted a regression analysis to evaluate the performance of its hospitals in terms of how many labor hours are used relative to how many labor hours are needed.

View More Related Solutions