Seasonal Index and Regression Models
Quarterly billing for water usage is shown below.
Year
Quarter 1 2 3 4
Winter 64 66 68 73
Spring 103 103 104 120
Summer 152 160 162 176
Fall 73 72 78 88
a. Find the seasonal index for each quarter.
b. Deseasonalize the data.
c. Find the trend line.
d. Assume there is no cyclical component (don't forget: there IS a seasonal component). Forecast the summer billing for year 5.
2. The following table shows the annual maintenance costs for several cars, as well as their age.
age of car annual expenses ($)
1 100
2 375
2 325
3 455
3 520
4 485
4 530
5 595
5 515
6 700
6 800
7 1000
7 950
What would a regression model that relates maintenance costs (dependent variable) as a function of age (independent variable) predict the annual cost of maintaining an eight-year-old car to be?
Seasonal Index and Regression Models are investigated. The solution is detailed and well presented. The response received a rating of "5/5" from the student who originally posted the question.
- Plain text response
- Attached file(s):
- 116890.xls
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- Seasonal Index and Trendlines - Quarterly billing for water usage is shown below. Year 1 Year 2 Year 3 Year 4 Winter 64 66 68 73 Spring 103 103 104 120 Summer 152 160 162 176 Fall 73 72 78 88 a. Find the seasonal in ...
- Linear Programming : Seasonal Factors - Quarterly sales is given for the past 3 years, determine the seasonal factors for each quarter. Winter Spring Summer Fall Year 1 4800 4500 4100 5500 Year 2 5700 3800 4500 6000 Year 3 6000 460 ...
- Ratio to moving average - Please see attachment. Ratio to moving average method An analyst wants to use the ratio-to-moving average method to forecast a company's sales for the next few quarters. Beginning in Quarter of ...
- Ratio to Moving Average Method - Ratio to moving average method An analyst wants to use the ratio-to-moving average method to forecast a company's sales for the next few quarters. Beginning in Quarter 4 of 2005, the analyst collect ...
- Ratio to Moving Average Method - Ratio-to-moving average method An analyst wants to use the ratio-to-moving average method to forecast a company's sales for the next few months. Beginning in December of 2005, the analyst collects t ...
