Questions from Spreadsheet Modeling

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: 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: Create a Double Moving Average model (with k 5 4)

Create a Double Moving Average model (with k 5 4) for the data set. a. Prepare a line graph comparing the Double Moving Average predictions against the original data. b. What are the forecasts for t...

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. Prepare a line graph co...

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. Do the moving averag...

Q: Use regression to estimate the parameters of a 6th order polynomial model

Use regression to estimate the parameters of a 6th order polynomial model for this data. That is, estimate the least squares estimates for the parameters in the following estimated regression equati...

Q: A used-car broker needs to transport his inventory of cars

A used-car broker needs to transport his inventory of cars from locations 1 and 2 in Figure 5.39 to used-car auctions being held at locations 4 and 5. The costs of transporting cars along each of the...

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: Use the additive seasonal technique for stationary data to model the data

Use the additive seasonal technique for stationary data to model the data. 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 com...

Q: Use the multiplicative seasonal technique for stationary data to model the data

Use the multiplicative seasonal technique for stationary data to model the data. 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 gra...