Utility usage data

Budget planners for a local business office want to predict electricity costs for the next year. They collect data on utility usage during the previous 84 billing periods to predict future usage.

You can use this data to demonstrate Winters' Method, Decomposition, ARIMA, and other analyses that use time series data that have seasonal patterns for forecasting.

Worksheet column Description
Electric Charges The monthly electric usage