Questions from Spreadsheet Modeling

Q: Each month, Joe’s Auto Parts uses exponential smoothing (with a

Each month, Joe’s Auto Parts uses exponential smoothing (with a 5 0.25) to predict the number of cans of brake fluid that will be sold during the next month. In June, Joe forecast that he would sell 3...

Q: Prepare a line graph of these data. Do the data appear

Prepare a line graph of these data. Do the data appear to be stationary or nonstationary?

Q: Compute the two-period and four-period moving average predictions

Compute the two-period and four-period moving average predictions for the data set. a. Prepare a line graph comparing the moving average predictions against the original data. b. Compute the MSE for...

Q: Use Solver to determine the weights for a four-period weighted

Use Solver to determine the weights for a four-period weighted moving average on the data set that minimizes the MSE. a. What are the optimal values for the weights? b. Prepare a line graph comparing...

Q: A company has three warehouses that supply four stores with a given

A company has three warehouses that supply four stores with a given product. Each warehouse has 30 units of the product. Stores 1, 2, 3, and 4 require 20, 25, 30, and 35 units of the product, respecti...

Q: Create an exponential smoothing model that minimizes the MSE for the data

Create an exponential smoothing model that minimizes the MSE for the data set. Use Solver to estimate the optimal value of a. a. What is the optimal value of a? b. Prepare a line graph comparing the e...

Q: Use Holt’s method to create a model that minimizes the MSE for

Use Holt’s method to create a model that minimizes the MSE for the data set. Use Solver to estimate the optimal values of a and b. a. What are the optimal values of a and b? b. Are these values surpri...

Q: Use regression analysis to fit a linear trend model to the data

Use regression analysis to fit a linear trend model to the data set. a. What is the estimated regression function? b. Interpret the R2 value for your model. c. Prepare a line graph comparing the linea...

Q: Use regression analysis to fit a quadratic trend model to the data

Use regression analysis to fit a quadratic trend model to the data set. a. What is the estimated regression function? b. Compare the adjusted-R2 value for this model to that of the linear trend model....

Q: Use Holt’s method to create a model that minimizes the MSE for

Use Holt’s method to create a model that minimizes the MSE for the data set. Use Solver to determine the optimal values of a and b. a. What are the optimal values of a and b? b. Prepare a line graph c...