Question 7 (2 points) Quarterly billing for water usage is shown below. quarter
ID: 3334502 • Letter: Q
Question
Question 7 (2 points) Quarterly billing for water usage is shown below. quarter year 1 year 2 year 3 year 4 606468 72 99 103 107 111 154 158162166 69 737781 with dummy variables to develop an additive decomposition forecasting model for these data. Model the trend component using the time periods, numbersd 1 16 1:3 (use quarter 4 as the baseline). Model the seasonality using dummy variebles for guarten ata into E Hints: Copy-and-paste d quarter 1 quarter 2, and quarter 3. Fll in the blanke below with the coefficients that you estimate from the cata. x period + Save Gaite Subrait QuizExplanation / Answer
Period
Year
Quarter
Billing
Q1
Q2
Q3
Period
1
1
1
60
1
0
0
1
2
1
2
99
0
1
0
2
3
1
3
154
0
0
1
3
4
1
4
69
0
0
0
4
5
2
1
64
1
0
0
5
6
2
2
103
0
1
0
6
7
2
3
158
0
0
1
7
8
2
4
73
0
0
0
8
9
3
1
68
1
0
0
9
10
3
2
107
0
1
0
10
11
3
3
162
0
0
1
11
12
3
4
77
0
0
0
12
13
4
1
72
1
0
0
13
14
4
2
111
0
1
0
14
15
4
3
166
0
0
1
15
16
4
4
81
0
0
0
16
SUMMARY OUTPUT
Regression Statistics
Multiple R
1
R Square
1
Adjusted R Square
1
Standard Error
6.61339E-15
Observations
16
ANOVA
df
SS
MS
F
Significance F
Regression
4
21908
5477
1.25226E+32
4.9195E-174
Residual
11
4.81107E-28
4.3737E-29
Total
15
21908
Coefficients
Standard Error
t Stat
P-value
Lower 95%
Upper 95%
Intercept
65
4.96004E-15
1.31047E+16
6.4171E-173
65
65
Q1
-6
4.8061E-15
-1.24841E+15
1.0942E-161
-6
-6
Q2
32
4.73447E-15
6.75894E+15
9.3407E-170
32
32
Q3
86
4.69097E-15
1.83331E+16
1.5975E-174
86
86
Period
1
3.697E-16
2.7049E+15
2.2151E-165
1
1
Predicted Billing=65+1*Period-6*Q1+32*Q2+86*Q3
Period
Year
Quarter
Billing
Q1
Q2
Q3
Period
1
1
1
60
1
0
0
1
2
1
2
99
0
1
0
2
3
1
3
154
0
0
1
3
4
1
4
69
0
0
0
4
5
2
1
64
1
0
0
5
6
2
2
103
0
1
0
6
7
2
3
158
0
0
1
7
8
2
4
73
0
0
0
8
9
3
1
68
1
0
0
9
10
3
2
107
0
1
0
10
11
3
3
162
0
0
1
11
12
3
4
77
0
0
0
12
13
4
1
72
1
0
0
13
14
4
2
111
0
1
0
14
15
4
3
166
0
0
1
15
16
4
4
81
0
0
0
16
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.