Explore BrainMass
Share

Seasonally Adjusted Forecast

This content was STOLEN from BrainMass.com - View the original, and get the solution, here!

From the given data develop a seasonally adjusted forecast for 2006. (Use a linear trend line model to develop a forecast estimate for 2006.)

Year Quarter Ice cream sales (gal)

2003 1 350
2 510
3 750
4 420

2004 5 370
6 480
7 860
8 500

2005 9 450
10 550
11 820
12 570

© BrainMass Inc. brainmass.com September 23, 2018, 7:48 pm ad1c9bdddf - https://brainmass.com/statistics/general-linear-model/seasonally-adjusted-forecast-313623

Solution Summary

This solution is comprised of detailed analysis and step-by-step calculations of Seasonally Adjusted Forecast in EXCEL. The solution provides students with a clear perspective of the various aspects of forecast analysis, e.g. calculation of Seasonal Indices, Linear Trendline, Prediction Value, etc.

$2.19