Sales person A 3 190 6333333 5833333 Sales person B 3 Sales person C

# Sales person a 3 190 6333333 5833333 sales person b 3

• 17

This preview shows page 10 - 16 out of 17 pages.

Sales person A 3 190 63.33333 58.33333 Sales person B 3 195 65 25 Sales person C 3 140 46.66667 158.3333 Region A 3 160 53.33333 58.33333 Region B 3 195 65 25 Region C 3 170 56.66667 358.3333 ANOVA Source of Variation SS df MS F P-value F crit Rows 616.6667 2 308.3333 4.625 0.091136 6.944272 Columns 216.6667 2 108.3333 1.625 0.3044 6.944272 Error 266.6667 4 66.66667 Total 1100 8 4.625 1.625
Result at 5% level of significance we cannot reject and hence the column mean is also identical
For any combination of teritory we have olny 1 Question H0= Sales person has no impact on sales, neithe Region A Region B Region C Row mean AvRow mean -grand mean Square of row Sales person A 55.00 70.00 65.00 63.33 5.00 25.00 Sales person B 60.00 65.00 70.00 65.00 6.67 44.44 Sales person C 45.00 60.00 35.00 46.67 -11.67 136.11 Column mean 53.33 65.00 56.67 58.33 -5.00 6.67 -1.67 25.00 44.44 2.78 Sum of all the sqaure* 3 216.6667 -3.33 11.67 6.67 1.67 6.67 11.67 -13.33 1.67 -23.33 column mean -grand mean Square column mean
data points or more than 1 decise its 2 fact with or without replication er the region has no impact on the sales Sum of all the sqaure* 3 616.67
Anova: Two-Factor With Replication SUMMARY Region 1 Region 2 Region 3 Total salesperson 1 Count 5 5 5 15 Sum 280 339 279 898 Average 56 67.8 55.8 59.86667 Variance 18 21.2 84.7 69.12381 Saleasperson 2 Count 5 5 5 15 Sum 322 291 304 917 Average 64.4 58.2 60.8 61.13333 Variance 71.3 69.2 76.7 68.98095 Salesperson3 Count 5 5 5 15 Sum 277 321 303 901 Average 55.4 64.2 60.6 60.06667 Variance 23.3 160.7 53.3 81.78095 Total Count 15 15 15 Sum 879 951 886 Average 58.6 63.4 59.06667 Variance 50.25714 88.54286 67.06667 ANOVA Source of Variation SS df MS F P-value F crit 3.259446 Sample 13.91111 2 6.955556 0.10823 0.897712 3.259446 Result Columns 210.1778 2 105.0889 1.635201 0.209059 3.259446 Interaction 554.6222 4 138.6556 2.157503 0.093648 2.633532 Within 2313.6 36 64.26667 Total 3092.311 44
We can see that the f- critical value is grater than the f stat We also look at the p value is > that the chosen value of 0.05 Rows column and interaction dont have any effect so Saleasperson and region and the change don’t have effect on sales NOT REJECT THE H0

#### You've reached the end of your free preview.

Want to read all 17 pages?

• Spring '17

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern