Squirt Squad is a cleaning service that sends crews to residential homes on either a once a month or a twice a month schedule, depending on the customer’s preference. The owner would like to predict the amount of time required to clean a house based on the square footage of the house, the total number of rooms in the house, the number of bathrooms it has, the size of the cleaning crew, the frequency of the cleaning schedule, and whether the household has children. Data from randomly selected homes can be found in the Excel file Squirt Squad 2.xlsx.

a. Using PH_Stat, construct a regression model using all of the independent variables.

b. Test the significance of the overall regression model using α = 0.05.

c. Interpret the meaning of the regression coefficient for the Rooms, Crew, Children, and Frequency variables.

d. Using the p values, identify which independent variables are significant with α = 0.05.

e. Construct a regression model using only the significant variables found in part d and predict the average time to clean a house that has 2,250 square feet, 11 total rooms, 3.5 bathrooms, and no children. This house is cleaned once a month with a crew of four employees.