Use a stepwise process in excel to complete the following regression and report your analysis of each regression including a correlation matrix, a coefficient of determination, ANOVA, regression equation, F test, and goodness of fit analysis.

Y and X₁

Y and X₂

Y and X₃

Y and X₄

Y, X₁ and X₂

Y, X₁ and X₃

Y, X₁ and X₄

Y, X₂ and X₃

Y, X₂ and X₄

Y, X₃ and X₄

Y, X₁, X₂ and X₃

Y X₂, X₃ and X₄

Y, X₁, X₂, X₃ and X₄

2. Time series data. Use the data set provided to assess autocorrelation, check the ACF, determine the differencing needed, run the regression and give your analysis.

3. Time series data. Use the data set provided to do a moving average estimation, and give your analysis of the results.

Week	Pharmaceutical Sales (thousands
1	10618.1
2	10567.9
3	10209.3
4	10553
5	9934.9
6	10534.5
7	10193.5
8	10511.8
9	10089.6
10	10571.2
11	10239.4
12	10827.2
13	10640.8
14	10517.8
15	10154.2
16	9969.5
17	10260.4
18	10737
19	10430
20	10689
21	10430.3
22	10002.4
23	10135.7
24	10289.1
25	10589.9
26	10551.9
27	10280.3
28	10334.5
29	10450.1
30	10357.6
31	10202.3
32	10219.3
33	10382.7
34	10820.5
35	10358.7
36	10494.6
37	10497.6
38	10431.5
39	10447.8
40	10654.4
41	10176.5
42	10616
43	10627.7
44	10246.7
45	10265
46	10090.4
47	9881.1
48	10446.7
49	10276.3
50	10449.7
51	10175.2
52	10212.5
53	10395.5
54	10545.9
55	10335.7
56	10265.2
57	10551.6
58	10358.2
59	10286.2
60	10171.3
61	10393.1
62	1062.3
63	10164.5
64	10327
65	10365.1
66	10755.9
67	10463.6
68	10082.5
69	10479.6
70	9980.9
71	10039.2
72	10246.1
73	10368
74	10446.3
75	10535.3
76	10786.9
77	9975.8
78	10160.9
79	10422.1
80	10757.2
81	10463.8
82	10307
83	10134.7