Purchase Solution

Comparing Two Groups

Not what you're looking for?

Ask Custom Question

See the attached Commissions.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?

Attachments
Purchase this Solution

Solution Summary

This solution provides step by step calculations and explanations in an Excel file on performing data analysis, by finding the mean and building a pivot chart. Finally, an ANOVA test is performed where the sum, average and variance are calculated to produce the F statistic, which is then compared to the p-value.

Purchase this Solution


Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.