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, and whether the household has children. Data from randomly selected homes can be found in the Excel file Squirt Squad 3. xlsx.

a. Using PH_Stat, check for the presence of multicollinearity.

b. If multicollinearity is present, take the necessary steps to eliminate it.

c. Perform a best subsets regression and choose the most appropriate model for these data.

d. Perform a residual analysis with the model in part c to verify that the conditions for the model are met.