week3_

docx

School

Texas Christian University *

*We aren’t endorsed by this school

Course

40313

Subject

Industrial Engineering

Date

Dec 6, 2023

Type

docx

Pages

3

Uploaded by grac2209

Report
a. Calculate both the three-month and the five-month averages for these data. Both the three-month and the five-month averages are in excel sheet attached. a. Plot the data to examine the possible existence of trend and seasonality. a. Prepare the following two (2) separate forecasting models to examine the thermostat’s sales data using monthly data:
o An exponential smoothing model (α=0.38, smoothing constant for the level) o Holt’s model (α=0.04, smoothing constant for the level; β=0.07, smoothing constant for the trend)
b. Examine the accuracy of the forecast given by each model ( four models: MA 3, MA 5, Simple Exponential smoothing and Holt's Method) by calculating the root mean square error (RMSE) for each during the historical period. ES: 28.23922135 HOLTS: 41.13729597 MA3:29 MA5: 28.2491499 e. Which model does minimize the RMSE? Carefully explain which characteristics of the original data caused one of these models to minimize the RMSE. For this data, the simple exponential smoothing method resulted in the lowest RMSE. This suggest that SES is well suited for the data we have. One possible reason this could be is because SES is specifically designed for time series data, where values are chronologically ordered. And this data represents a time series, SES captures the underlying patterns and trends effectively. f. Using Holt's method forecast 12 months of thermostat sales for 2017.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help