For this problem use the data in the worksheet named below.

The data shows the "quarterly" energy bills for a school system in units of $1000.

Answer the following questions.

t	Quarter	y
1	1	344.39
2	2	246.63
3	3	131.53
4	4	298.87
5	1	313.45
6	2	189.76
7	3	179.10
8	4	221.10
9	1	246.84
10	2	209.00
11	3	51.21
12	4	133.89
13	1	277.01
14	2	197.98
15	3	50.68
16	4	218.08
17	1	365.10
18	2	207.51
19	3	54.63
20	4	214.09
21	1	267.00
22	2	230.28
23	3	230.32
24	4	436.41
25	1	467.06
26	2	306.03
27	3	253.23
28	4	279.46
29	1	336.56
30	2	196.67
31	3	152.15
32	4	319.67
33	1	440.00
34	2	315.04
35	3	216.42
36	4	339.78
37	1	434.66
38	2	399.66
39	3	330.80
40	4	539.78

1.Plot the data and fit a 2nd degree polynomial trend line. What are the estimated coefficient values for b₂, b₁ and b₀, respectively?

Group of answer choices

0.2998, -7.6987, 258.91

0.3093, -8.1805, 262.07

0.3056, -7.9321, 259.49

0.3093, -8.1805, 262.07

2.What is the coefficient of determination?

Group of answer choices

0.3325

0.338

0.3253

0.3429

3. We decide to fit the following seasonal polynomial model on the consumption data.

y_t = b₀ + b₁ t + b₂ t² + b₃ DQ1 + b₄ DQ2 + b₅ DQ3 +

Add the required variables to the dataset and run a multiple regression model.

What values do you get for b₁, b₂ and b₅, respectively?

Group of answer choices

-7.500, 0.302, -129.641

-7.458, 0.301, -127.611

-7.253, 0.296, -129.645

-7.746, 0.305, -131.732

4.Are all the coefficients significant at 95% confidence level?

Group of answer choices

Yes, they are all significant

Yes, except DQ1, DQ2 and DQ3

No, none are significant

Yes, except DQ2