Question 11.32

11.32 Architectural firm billings.

A summary of firms engaged in commercial architecture in the Indianapolis, Indiana, area provides firm characteristics, including total annual billing in the current year, total annual billing in the previous year, the number of architects, the number of engineers, and the number of staff employed in the firm.9 Consider developing a model to predict current total billing using the other four variables.

arch

  1. Using numerical and graphical summaries, describe the distribution of current and past year total billing and the number of architects, engineers, and staff.
  2. For each of the 10 pairs of variables, use graphical and numerical summaries to describe the relationship.
  3. Carry out a multiple regression. Report the fitted regression equation and the value of the regression standard error .
  4. Analyze the residuals from the multiple regression. Are there any concerns?
  5. A firm did not report its current total billing but had $1 million in billing last year and employs three architects, one engineer, and 17 staff members. What is the predicted total billing for this firm?