1. 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
The forecast equation is: Ft = 64.875 - 6.1375Qtr1t + 32.325Qtr2t + 86.0375Qtr3t + 1.2875 (t).
Forecast the summer of year 5 and spring of year 6
2. The average SAT verbal score for students from one high school over the last ten exams is
508, 490, 502, 505, 493, 506, 492, 490, 503, 501
Estimate the parameter (b0, b1) of the linear trend equation: T = b0 + b1 t, where T = trend value of the time series in period t.
Must fully show all work in word format (no excel)