# Question: Let Yt be the sales during month t in thousands

Let Yt be the sales during month t (in thousands of dollars) for a photography studio, and let Pt be the price charged for portraits during month t. The data are in the file S11_45.xlsx. Use regression to fit the following model to these data:

Yt = a + b1Yt - 1 + b2Pt + et

This equation indicates that last monthâ€™s sales and the current monthâ€™s price are explanatory variables. The last term, et, is an error term.

a. If the price of a portrait during month 21 is $10, what would you predict for sales in month 21?

b. Does there appear to be a problem with autocorrelation of the residuals?

Yt = a + b1Yt - 1 + b2Pt + et

This equation indicates that last monthâ€™s sales and the current monthâ€™s price are explanatory variables. The last term, et, is an error term.

a. If the price of a portrait during month 21 is $10, what would you predict for sales in month 21?

b. Does there appear to be a problem with autocorrelation of the residuals?

**View Solution:**## Answer to relevant Questions

The file S12_75.xlsx contains five years of monthly data for a particular company. The first variable is Time (1 to 60). The second variable, Sales1, contains data on sales of a product. Note that Sales1 increases linearly ...Amanta Appliances sells two styles of refrigerators at more than 50 locations in the Midwest. The first style is a relatively expensive model, whereas the second is a standard, less expensive model. Although weekly demand ...Using the graphical solution of the product mix model as a guide, suppose there are only 2800 testing hours available. How do the answers to the previous problem change? Suppose that you want to increase all three of the resource availabilities in the product mix model simultaneously by the same percentage. You want this percentage to vary from -25% to 50% in increments of 5%. Modify the ...Modify the Pigskin spreadsheet model in the following way. Assume that the timing of demand and production are such that only 70% of the production in a given month can be used to satisfy the demand in that month. The other ...Post your question