Use a stepwise process in excel to complete the following regression and report your analysis of each
Question:
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 X1
Y and X2
Y and X3
Y and X4
Y, X1 and X2
Y, X1 and X3
Y, X1 and X4
Y, X2 and X3
Y, X2 and X4
Y, X3 and X4
Y, X1, X2 and X3
Y X2, X3 and X4
Y, X1, X2, X3 and X4
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 |
Cost Accounting A Managerial Emphasis
ISBN: 978-0133392883
6th Canadian edition
Authors: Horngren, Srikant Datar, George Foster, Madhav Rajan, Christ