The owner of a restaurant has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data appear in the file P10_23.xlsx.

a. Estimate a regression equation for sales as a function of population, advertising in the current year, and advertising in the previous year. Can you expect predictions of sales in future years to be very accurate if they are based on this regression equation? Explain.