Hogs & Dawgs is an ice cream parlor on the border of north-central Louisiana and southern Arkansas
Question:
a. Construct a time series plot of hourly sales and a scatter plot of outdoor temperature and hourly sales. What types of relationships exist in the data?
b. Use a simple regression model with outside temperature as the causal variable to develop an equation to account for the relationship between outside temperature and hourly sales in the data. Based on this model, compute an estimate of hourly sales for today from 2:00 p.m. to 3:00 p.m. if the temperature at 2:00 p.m. is 93°.
c. Use a multiple linear regression model with the causal variable outside temperature and dummy variables as follows to develop an equation to account for both seasonal effects and the relationship between outside temperature and hourly sales in the data in the data: Hour1 = 1 if the sales were recorded between 1:00 p.m. and 2:00 p.m., 0 otherwise; Hour2 = 1 if the sales were recorded between 2:00 p.m. and 3:00 p.m., 0 otherwise; . . . Hour8 = 1 if the sales were recorded between 8:00 p.m. and 9:00 p.m., 0 otherwise. When the values of the 8 dummy variables are equal to 0, the observation corresponds to the 9:00-to-10:00-p.m. hour. Based on this model, compute an estimate of hourly sales for today from 2:00 p.m. to 3:00 p.m. if the temperature at 2:00 p.m. is 93°.
d. Is the model you developed in part b or the model you developed in part c more effective? Justify your answer.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Essentials of Business Analytics
ISBN: 978-1285187273
1st edition
Authors: Jeffrey Camm, James Cochran, Michael Fry, Jeffrey Ohlmann, David Anderson, Dennis Sweeney, Thomas Williams
Question Posted: