Perform multiple regression analysis to determine how housing start data affect direct labor hours in the following month for the Heartwood Cabinets Installation Subsidiary. You can do so by replicating Analysis Tasks #$2$ and #$3$ in Lab $4\mathrm{.}1.$ Use the Alt Lab $4\mathrm{.}1$ Data.xlsx dataset. Be sure to include all five years of data, and create an additional column to look at the effect of housing starts on labor in the subsequent month.

Data Dictionary

Month Month and year

Large$\_$MultiFam Construction starts for multifamily buildings with at least $5$ units

Small$\_$MultiFam Construction starts for multifamily buildings with $2$ to $4$ units

SingFam Construction starts for single$-$family units

DLH Direct labor hours

The data file contains eight years of regional housing start data, along with five years of labor data for Heartwood.

Master the Data

Heartwood Cabinets has gathered two more years of historical direct labor data, and it wants to determine how the regression analysis will change when adding the additional data to the analysis. Use the Alt Lab $4\mathrm{.}1$ Data.xlsx dataset.

Perform the Analysis

Alternate Labs $-$ On Your Own don't have step$-$by$-$step instruction. Apply your experience from the original lab. If needed, reference the text or eBook for instructions and steps from the original lab.

Answer the following questions based on the details provided.