Problem $5(20$ Points$)$

The ChatCamp Outdoor Company is a catalog sales operation that specializes in outdoor recreational

clothing. Demand for its items is very seasonal, peaking during the Christmas season and

during the spring. It has accumulated the following data for orders per season $($quarter$)$ during the

past $5$ years:

a$.$ Calculate the overall average demad.

b$.$ Calculate the average demad per quarter in the space given in the above table.

c$.$ Calculate the seasonal index in the space given in the above table.

d$.$ Develop a linear trend line $($simple linear regression line$)$ forecast for each of the four seasons season for year $6.$

$($Create a separate table as we did in the Chapter $15$ Assessment, then find the intercept and the slope of the trend line.$)$

Intercept

Time $($Slope$)$

Forecast using trend $($only$)$

e$.$ Draw a time$-$series plot with original data and the trend line.

f$.$ Calculate he Mean Squared Error $($MSE$)$ for the trend$-$line$-$only forca MSE

g$.$ Projection for quarters $1$ through $4$ of year $6$ using trend and seasonal index. Please Show steps in EXCEL!