Solution-Calculate the mean commissions for the past 3 years

Calculate the mean commissions for the past 3 years

Reference no: EM13947654

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

Reference no: EM13947654

Questions Cloud

Explain how each center will contribute to children learning : Describe each center, including the materials and equipment that would be needed. Explain how each center will contribute to children's learning. Discuss why you chose these four centers

Prepare an income statement that more accurately reflects : Prepare an income statement that more accurately reflects the division's profit performance. Should the president shut down the division? What would be the effect on the company's profits if the division was closed?

Provided you with the following option : A lottery has provided you with the following options: $350,000 today or $40,000 per year for 10 years. If you can earn 4% on your money indefinitely, which deal would you take?

Should your recommendations be the same for both companies : Prepare a recommendation for each company. Should your recommendations be the same for both companies? If not, what are the differences?

Calculate the mean commissions for the past 3 years : 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?

How can technology support the early childhood experience : What is your philosophy of early childhood education? How can technology support the early childhood experience

Major part of the public activity in the u.s. economy : To a great extent, transportation project planning is described as a public activity where purely financial return is not the overriding benefit to be attained.

Contributions of convection and radiation to heat transfer : Assess the effect of surface temperature on the power requirement, as well as on the relative contributions of convection and radiation to heat transfer from the surface.

Describe a plan for ongoing communication with lucy family : Explain the reasons for choosing these strategies for Lucy and her family. Describe a plan for ongoing communication with Lucy's family including how the success of these strategies will be measured

User Account

All Pages

Calculate the mean commissions for the past 3 years

Reference no: EM13947654

Reference no: EM13947654

Questions Cloud

Reviews

Write a Review

Basic Statistics Questions & Answers

Statistics-probability assignment

What is the least number

Determine the value of k

What is the probability

Binomial distributions

Caselet on mcdonald’s vs. burger king - waiting time

Generate descriptive statistics

Sampling variability and standard error

Estimate the population mean

Conduct a marketing experiment

Find out the probability

Linear programming models

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT