Question

Please refer to the Anova and Simple Regression Projects.

Your company would like you to complete their sales prediction model. They would like you to ascertain if the other variables for which they have data also affect sales. A complete model will have to include advertising expenditures and package design along with the other variables listed above.

1. Create three dummy variables named DA, DB, and DC to capture the effects of the four levels of the categorical variable. Then use Tools > Data Analysis > Regression, to fit a regression of Sales as a function of all the variables in your data set (variables 3 through 7 above), plus the three dummies DA, DB, and DC.
2. Conduct the F-test for model significance and report your results.
3. Does your model appear to be adequate for the purpose intended? (Refer to goodness-of-fit measures, in particular, R², adjusted R², and the standard error of estimate.)
4. Your boss wants to know what you predict will be the effect on company sales if the company increases its price. What will be your response?
5. Do changes in your competitor's price have a significant impact on your company's sales and, if so, at what significance level?
6. Are any of the other variables in your model significant in determining sales at the 5% significance level or better?
7. Your boss also wants to know about the effectiveness of the various advertising methods. Report your findings with regard to this variable.

63.6 44.4 40.6 0.73 2.90 2.76 D
75.8 53.8 36.0 0.76 2.68 2.37 B
88.7 54.5 38.7 0.77 2.94 1.96 D
79.3 44.8 37.1 0.77 2.41 1.96 A
101.5 59.0 42.4 0.75 2.42 2.78 D
119.0 46.7 39.6 0.68 2.33 2.52 C
76.6 46.3 39.2 0.76 2.81 1.61 D
114.5 50.7 44.7 0.78 3.01 2.36 C
103.1 55.3 38.3 0.66 2.86 2.05 C
108.3 48.0 43.1 0.77 2.63 2.18 D
83.9 53.7 38.1 0.70 2.94 2.92 D
126.2 49.9 39.8 0.85 2.57 2.37 C
101.7 50.8 40.8 0.68 2.55 1.90 D
76.0 52.1 37.1 0.66 2.81 1.88 A
84.8 43.3 43.6 0.72 2.39 3.38 A
52.6 53.8 38.5 0.86 3.32 1.96 A
70.5 51.0 38.1 0.70 2.81 3.37 B
78.9 47.7 39.6 0.78 3.11 1.96 B
69.8 54.7 37.7 0.76 2.87 2.53 A
78.3 54.4 35.0 0.80 2.61 2.71 B
77.0 40.7 36.1 0.78 2.93 2.34 C
45.8 49.5 36.1 0.74 3.04 1.77 A
71.3 43.8 39.6 0.80 2.78 2.22 B
96.2 40.1 42.1 0.79 2.81 2.38 C
90.0 49.9 39.9 0.81 3.37 2.95 C
73.3 52.3 42.7 0.68 3.31 2.26 B
83.9 50.0 42.2 0.72 2.76 2.72 A
81.0 49.9 36.2 0.71 2.51 1.56 D
83.9 52.8 36.8 0.82 2.82 2.30 B
147.5 54.3 43.3 0.64 2.00 2.36 C
124.5 62.1 42.5 0.72 2.19 2.72 D
103.2 51.0 36.2 0.74 2.77 2.09 D
110.9 47.3 44.1 0.79 2.67 3.39 D
92.6 45.8 41.0 0.76 2.72 2.86 B
98.5 53.4 37.0 0.83 2.83 2.48 D
108.6 52.6 36.1 0.80 2.76 3.05 C
76.8 53.5 38.3 0.82 2.95 2.11 D
103.4 49.7 40.4 0.69 2.52 3.07 B
74.4 39.8 38.9 0.76 2.64 3.05 D
123.7 51.9 44.7 0.83 2.94 3.25 C
81.3 37.4 43.8 0.79 2.65 2.19 D
105.1 52.0 35.5 0.69 2.55 3.14 C
123.8 59.7 44.0 0.77 3.14 2.06 C
65.5 39.3 39.1 0.74 2.67 2.70 A
97.6 50.4 44.9 0.68 2.82 3.19 B
31.9 40.6 35.1 0.68 3.05 2.13 A
78.9 51.3 35.5 0.75 2.85 1.93 B
94.8 52.9 38.7 0.75 3.15 3.23 C
110.6 43.9 41.7 0.78 2.55 2.11 C
65.5 43.4 35.1 0.72 2.84 1.87 A
63.7 52.4 40.0 0.81 3.08 1.88 A
89.7 52.1 42.8 0.68 3.08 1.66 A
93.1 55.0 39.1 0.79 2.87 2.91 B
82.6 42.2 35.6 0.80 2.89 1.59 B
123.7 48.9 41.1 0.84 2.39 2.65 C
106.7 47.3 41.6 0.76 2.64 2.59 C
108.4 59.1 35.9 0.76 2.37 3.47 D
83.6 54.0 35.8 0.72 2.53 2.40 A
90.3 45.4 36.0 0.76 2.91 2.43 C
120.0 52.3 40.3 0.81 2.54 3.40 C

Answer 1