Given the candy data set (in the file candy.xlsx), use linear regression to find the coefficients for a linear equation that has length as the response variable and thickness as the predictor: LENGTH predicted = a0 + a1 THICKNESS a0 = ________,pa0 = _________, Confidence interval: _________________ a1 _________, pa1 = _________, Confidence interval: _________________ R2 = ______________ Based on the analysis above, is the model a good fit? (yes, no) Attach a scanned copy of the regression analysis output from the spreadsheet.

#	Color	thickness(mm)	length(mm)	diam/stck(mm)	mass(gm)	diam/candy(mm)
1	Purple	10.12	86.37	3.14	5.89	21.37
2	Yellow	8.6	91.22	3.46	6.01	24.25
3	Green	9.13	88.05	3.26	5.93	23.19
4	Red	7.74	89.5	3.15	5.86	25.2
5	Orange	9.71	87.7	3.16	5.74	23.84
6	Purple	9.01	86.3	3.09	5.21	22.88
7	Yellow	9.19	89.22	3.13	6.02	24.74
8	Green	9.91	87.15	3.14	6	23.23
9	Red	8.89	89.15	3.27	5.8	24.41
10	Orange	9.4	87	3.11	6.02	23.06
11	Purple	9.56	88.11	3.11	5.86	22.34
12	Yellow	8.71	89.38	3.11	6.04	24.77
13	Green	10.03	87.1	3.4	5.98	23.5
14	Red	8.56	90.57	3.19	5.84	25.34
15	Orange	9.48	86.67	3.53	6.03	23.81
16	Purple	9.29	87.07	3.14	5.78	23.81
17	Yellow	8.43	90.57	3.17	6.02	24.55
18	Green	9.36	85.52	3.36	5.7	22.58
19	Red	7.64	91.53	3.19	5.96	24.32
20	Orange	9.39	87.29	3.07	6	22.76
21	Purple	10.62	86.53	3.06	5.23	21.76
22	Yellow	9.37	90	3.2	5.93	22.36
23	Green	9.17	86.52	3.2	5.71	22.69
24	Red	7.97	91.39	3.21	5.83	24.55
25	Orange	9.51	87.9	3.16	5.81	22.52
26	Yellow	8.42	89.17	3.16	5.82	24.18
27	Red	8.38	90.52	3.19	5.84	25.28
28	Orange	8.39	88.9	2.29	6.03	22.8
29	Yellow	8.34	90.52	3.17	5.98	24.11
30	Orange	9.46	87.59	3.17	5.68	22.29