question archive The High Volt Electric Company has a difficult time predicting the quarterly salesfor its room air conditioner line due to the substantial seasonality in productsales
The High Volt Electric Company has a difficult time predicting the quarterly salesfor its room air conditioner line due to the substantial seasonality in productsales
Subject:StatisticsPrice: Bought3
The High Volt Electric Company has a difficult time predicting the quarterly salesfor its room air conditioner line due to the substantial seasonality in productsales. Quarterly sales data for the last three years are shown as follows:Last Year Two Years Ago Three Years AgoQuarter Units Quarter Units Quarter Units1 34000 1 30000 1 270002 82000 2 73000 2 700003 51000 3 48000 3 410004 16000 4 15000 4 13000(a) Determine the best straight-line trend using simple regression analysis. (8)(b) Determine the seasonal indices for each quarter using the trendline values inyour seasonal index computations. (6)(c) Using classic time series decomposition, forecast the sales for the next fourquarters.
