In: Statistics and Probability
Use excel only, please!
problem #1 data contains data on automobile manufacturer who employs sales representatives who make calls on dealers. The manufacturer wishes to compare the effectiveness of four different call-frequency plans for the sales representatives. Thirty-two representatives are chosen at random from the sales force and randomly assigned to the four call plans for six months, and their sales for the 6-month study period are recorded. Do the sample data support the hypothesis that at least one of the calls plans helps produce a higher average level of sales? Perform an appropriate statistical test and report a P-value.
Plan A | Plan B | Plan C | Plan D |
36 | 39 | 44 | 31 |
40 | 45 | 43 | 43 |
32 | 54 | 38 | 46 |
44 | 53 | 40 | 43 |
35 | 46 | 41 | 36 |
41 | 42 | 35 | 49 |
44 | 35 | 37 | 46 |
42 | 39 | 37 | 48 |
Anova in excel
1. Arrange the data in excel as shown below.
2. Select one factor anova from the data analysis tab.
3. Input the value as shown.
4. The output will be generated as follows.
Hypothesis.
Ho: The average sales for all the 4 plans is equal
H1: The average sales for all the 4 plans is not equal
From the ANOVA output we look at the pvalue which is 0.1944(highlighted in yellow). Since the pvalue is greater than 0.05, we fail to reject the null hypothesis and conclude that the mean average sales for all the 4 plans is equal
Hence we conclude that the differnt calls plans are not helping
to produce higher average level of sales.