# Question: The owner of a restaurant in Bloomington Indiana has recorded

The owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The entire data set appears in the file P10_23.xlsx.

a. Estimate a simple linear regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret the R2 value.

b. Add another explanatory variable—annual advertising expenditures—to the regression equation in part a. Estimate and interpret this expanded equation. How does the R2 value for this equation compare to the equation in part a? Explain any difference between the two R2 values. What, if anything, does the adjusted R2 value for the revised equation indicate?

c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous year’s advertising expenditure. How does the inclusion of this third explanatory variable affect the R2 and adjusted R2 values, in comparison to the corresponding values for the equation of part b? Explain any changes in these values.

a. Estimate a simple linear regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret the R2 value.

b. Add another explanatory variable—annual advertising expenditures—to the regression equation in part a. Estimate and interpret this expanded equation. How does the R2 value for this equation compare to the equation in part a? Explain any difference between the two R2 values. What, if anything, does the adjusted R2 value for the revised equation indicate?

c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous year’s advertising expenditure. How does the inclusion of this third explanatory variable affect the R2 and adjusted R2 values, in comparison to the corresponding values for the equation of part b? Explain any changes in these values.

## Answer to relevant Questions

Continuing Problem 8 on the 2009 golfer data in the file P10_08.xlsx, the simple linear regressions for Earnings per Round were perhaps not as good as you expected. Explore several multiple regressions for Earnings per ...The file P10_11.xlsx contains annual observations (in column B) of the American minimum wage. The basic question here is whether the minimum wage has been growing at roughly a constant rate over this period. a. Create a time ...Continuing Problem 18, suppose that the antique collector believes that the rate of increase of the auction price with the age of the item will be driven upward by a large number of bidders. How would you revise the multiple ...The file P10_44.xlsx contains data that relate the unit cost of producing a fuel pressure regulator to the cumulative number of fuel pressure regulators produced at an automobile production plant. For example, the 4000th ...Repeat Problem 51 with the football data in the file P03_57.xlsx. a. Rearrange the data so that there are four long columns: Team, Year, Salary, and Wins. There should be 6*30 values for each. b. Create a scatter plot of ...Post your question