As indicated by the opening vignette to this chapter, a motel chain could use regression to determine good locations for new motels from data on existing motels. The data in the file P10_63.xlsx provide one possibility. The Existing Sites sheet contains data on 90 motels in the chain. The cell comments in row 1 explain the variables, and the last variable, Operating Margin, is used as the dependent variable. The Potential Sites sheet contains data on five potential sites, but the dependent variable for these sites is unknown. Run a regression on the first sheet and discuss the results. Then use the regression equation to predict Operating Margin for the potential sites. Where would you suggest the company should locate one or more new motels? Note that the data on Indoor Pool have been omitted for the potential sites. After all, the company gets to decide whether to build an indoor pool. How should you handle this variable in the predictions?