The owners of a chain of ice cream stores have the business objective of improving the forecast of daily sales so that staffing shortages can be minimized during the summer season. As a starting point, the owners decide to develop a simple linear regression model to predict daily sales based on atmospheric temperature. They select a sample of 21 consecutive days and store the results in IceCream. a. Assuming a linear relationship, use the least-squares method to compute the regression coefficients b 0 and b 1 . b. Predict the sales for a day in which the temperature is 83 ∘ F . c. Plot the residuals versus the time period. d. Compute the Durbin-Watson statistic. At the 0.05 level of significance, is there evidence of positive autocorrelation among the residuals? e. Based on the results of (c) and (d), is there reason to question the validity of the model? f. What conclusions can you reach concerning the relationship between sales and atmospheric temperature?
The owners of a chain of ice cream stores have the business objective of improving the forecast of daily sales so that staffing shortages can be minimized during the summer season. As a starting point, the owners decide to develop a simple linear regression model to predict daily sales based on atmospheric temperature. They select a sample of 21 consecutive days and store the results in IceCream. a. Assuming a linear relationship, use the least-squares method to compute the regression coefficients b 0 and b 1 . b. Predict the sales for a day in which the temperature is 83 ∘ F . c. Plot the residuals versus the time period. d. Compute the Durbin-Watson statistic. At the 0.05 level of significance, is there evidence of positive autocorrelation among the residuals? e. Based on the results of (c) and (d), is there reason to question the validity of the model? f. What conclusions can you reach concerning the relationship between sales and atmospheric temperature?
Solution Summary: The author explains how to find the regression coefficients using least-squares method assuming a linear relationship.
The owners of a chain of ice cream stores have the business objective of improving the forecast of daily sales so that staffing shortages can be minimized during the summer season. As a starting point, the owners decide to develop a simple linear regression model to predict daily sales based on atmospheric temperature. They select a sample of 21 consecutive days and store the results in IceCream.
a. Assuming a linear relationship, use the least-squares method to compute the regression coefficients
b
0
and
b
1
.
b. Predict the sales for a day in which the temperature is
83
∘
F
.
c. Plot the residuals versus the time period.
d. Compute the Durbin-Watson statistic. At the 0.05 level of significance, is there evidence of positive autocorrelation among the residuals?
e. Based on the results of (c) and (d), is there reason to question the validity of the model?
f. What conclusions can you reach concerning the relationship between sales and atmospheric temperature?
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY