# Question

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 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.

b. The company would like to predict sales in the next year (year 20). It doesn’t know what the population will be in year 20, so it assumes no change from year 19. Its planned advertising level for year 20 is $30,000. Find a prediction and a 95% prediction interval for sales in year 20.

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.

b. The company would like to predict sales in the next year (year 20). It doesn’t know what the population will be in year 20, so it assumes no change from year 19. Its planned advertising level for year 20 is $30,000. Find a prediction and a 95% prediction interval for sales in year 20.

## Answer to relevant Questions

A power company located in southern Alabama wants to predict the peak power load (i.e., Y, the maximum amount of power that must be generated each day to meet demand) as a function of the daily high temperature (X). A random ...The file P11_47.xlsx contains the quarterly revenues (in millions of dollars) of a utility company for a seven-year period. The goal is to use these data to build a multiple regression model that can be used to forecast ...The file P11_54.xlsx contains monthly data on fatal automobile crashes in the U.S. in each of eight three-hour intervals. Suppose you didn’t have the data on the midnight to 3AM time interval. How well could multiple ...The file P11_62.xlsx has (somewhat old) data on several countries. The variables are listed here.• Country: name of country• GNPCapita: GNP per capita• PopGrowth: average annual percentage change in population, ...Suppose you are trying to explain variations in salaries for technicians in a particular field of work. The file P11_71.xlsx contains annual salaries for 200 technicians. It also shows how many years of experience each ...Post your question

0