See the attached data.xlsx data file. In the file is a global sample of 200ish Shoe Sales Associates whose 3 most recent annual sales commissions are recorded.
1) Calculate the mean commissions for the past 3 years. Which year was the highest and lowest?
2) Graph those annual means with a pivot chart.
3) Figure out which year(s) sales persons' made more money by comparing the difference between 2012 to 2013, 2013-2014, and 2012-2014. Since each row belongs to a specific sales person, you need to do a specific analysis - what is it?
What does the statistical significance value tell about those annual differences?
Thinking creatively, what do you think can account for those annual differences?
Attachment:- data.xlsx