Crusty Pizza executives are considering opening several new stores and they would like a forecast of monthly profit for each store. Use data in two worksheets.

a) Use the data from the first worksheet. Perform simple linear regression on the key variables to address the key study objective.

b) Comment on goodness of fit and discuss which variables would be good indicators of profit, and why.

c) Use regression models developed, along with Worksheet "Case 3a" to predict monthly profit for each of the 20 stores.

List the top five, and bottom five locations you would recommend to Crusty Pizza Company to open.