Answer:
a) The 3-day moving average forecast for today = 92
b) The 2-day moving average forecast for today = 93
c) mean absolute deviation based on a two-day moving average, covering all days in which you can have a forecast and an actual temperature = 1.713
Step-by-step explanation:
Daily high temperatures in the city of Houston for the last week have been
90, 93, 90 92, 90, 88, 98
a) To forecast the high temperature today using the three-day moving average.
The 3-day moving average involves generating a new set of data by combining the daily high temperature in threes, and then taking the average.
The required forecast is the data generated by combining and taking the average of the last 3 days.
N | T | 3-day moving average
1 | 90 |
2 | 93 |
3 | 90 |
4 | 92 | 91
5 | 90 | 91.6666667
6 | 88 | 90.666667
7 | 98 | 90
The 3-day moving average forecast for today is then given as (90+88+98)/3 = 92
Note that
91 = (90+93+90)/3
91.666667 = (93+90+92)/3
90.666667 = (90+92+90)/3
90 = (92+90+88)/3
92 = (90+88+98)/3
The 3-day moving average forecast for today = 92
b) To forecast the high temperature today using the two-day moving average.
The 2-day moving average involves generating a new set of data by combining the daily high temperature in twos, and then taking the average.
The required forecast is the data generated by combining and taking the average of the last 2 days.
N | T | 2-day moving average
1 | 90 |
2 | 93 |
3 | 90 | 91.5
4 | 92 | 91.5
5 | 90 | 91
6 | 88 | 91
7 | 98 | 89
The 2-day moving average forecastfor today = (88+98)/2 = 93
Just like the calculation in (a),
91.5 = (90+93)/2
91.5 = (93+90)/2
91 = (90+92)/2
And so on....
The 2-day moving average forecast for today is 93.
c) mean absolute deviation based on a two-day moving average, covering all days in which you can have a forecast and an actual temperature.
MAD = {Σ|x - μ|}/N
μ = mean = (90+93+90+92+90+88+98)/7
μ = 91.57
MAD using the 2-day moving average data will use, 91.5, 91.5, 91, 91, 89 and 93
MAD = [|91.5-91.57| + |91.5-91.57| + |91-91.57| + |91-91.57| + |89-91.57| + |93-91.57|] ÷ 6
MAD = 10.28/6 = 1.713
Hope this Helps!!!