Multiple Regression Analysis: Estimation and Inference

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 (X¹)—Weekly total of people-days

Remote hours (X²)—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.

Step 1

Copy data on to an excel sheet.

StandbyTotal StaffRemoteDubnerTotal Labor
2453384143232001
1773335983402030
2713586563402226
2113726313522154
1963395283802078
1352894093392080
1953343823312073
1182933993111758
1163253433281624
1473113383531889
1543043535181988
1463122894402049
1152833882761796
1613074022071720
2743221512872056
2453352282901890
2013502713552187
1833394403002032
2373274752841856
1753283473372068
1523194492791813
1883253362441808
1883222672531834
1973172352721973
2613151642231839
2323312702721935
estimation inference and prediction image 1

Step 2

Go to data and select the data analysis add in. Click on it and select regression.

estimation inference and prediction image 2

Step 3

  • Select A1 to A27 as y range and B1 to E27 as x range. Click on label so that it can automatically take the first cell of every column as a label and doesn’t produce error results.
  • Click ok to proceed
  • You will find the following table:
estimation inference and prediction image 3

Now we can answer the question using the table:

A. State the multiple regression equation

From the results obtained we can write the regression equation as follows:

{`
  Y = -330.831 + 1.76X1 – 0.13X2
  Where, 
  Y= standby hours
  X1= Total staff present
  X2= Remote hours
  b0= -330.67
  b1= 1.76
  b2= -0.13
  `}

B. Interpret the meaning of the slopes, b¹ and b², in this problem

The slope b1 means that with a 1 unit increase in total staff present the standby hours increase by 1.76 units.

The slope b2 means that if 1 unit of change is seen in remote hours then the standby hours would decrease by 0.13 units.

Thus we can conclude that standby hours are directly proportional to total staff present while remote hours and standby hours are inversely related.

C. Explain why the regression coefficient, bº, has no practical meaning in the context of this problem

The slope b0 has no practical meaning as time is never negative. And to have an intercept for time is absurd.

D. Predict the standby hours for a week in which the total staff present have 310 people-days and the remote hours are 400

{`
  Total staff present = 310
  Remote hours = 400
  Y=1.76*310 – 0.13*400
  = 493.6 hours
  `}

E. 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.

Yhat =Y± tn-2,α/2) sY

To calculate t α/2 select the function TINV in excel and put α =0.05 while degree of freedom as 23 (=n-2-1).

estimation inference and prediction image 4

{`
  t23,0.05 = 2.06 
  Yhat = 493.6 + (2.06*35.38)
  = 566.27
  Or Yhat = 493.6 - (2.06*35.38)
  = 420.93
  Confidence interval = (420.93, 566.27)
  `}

Excel Econometrics Tutorials

Multiple Regression Analysis

Time Series Analysis

Data Analysis