Calculate the mean commissions for the past 3 years

Assignment Help Basic Statistics
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

Reviews

Write a Review

Basic Statistics Questions & Answers

  Find standard deviation minimizes the annual cost

What standard deviation (within 0.001 inch) minimizes the annual cost of producuign elevator rails. You do not need to try standard deviations in excess of 0.02 inches.

  Determine computed f value and hypotheses

Bruce Kuhlman, owner of Kuhlman Farms, wishes to use brand of fertilizer which will produce maximum yield per acre of wheat. Mr. Kuhlman can select from four different commercial brands. Write down the hypotheses?

  Generic brand of soft drink

Market researchers would like to know if customers prefer a well-known brand over a generic brand of soft drink. They give a large sample of people the two drinks to taste in a random order and ask them which one tastes better.

  As a sample size approaches infinity how does the students

question as a sample size approaches infinity how does the students t distribution compare to the normal z

  Scatterplot showing the amount of space

For each format, create a scatterplot showing the amount of space needed (in MB) for storage based on the length (in seconds) of the song. Comment on what you see in the scatterplots.

  Mean aptitude test score

Find the probability that the mean aptitude test score for a randomly selected group of 150 8th graders is between 98 and 102.

  You and your opponent both roll a fair die if you both

you and your opponent both roll a fair die. if you both roll the same number the game is repeated otherwise whoever

  Probability that tire lasts more than eighty thousand miles

Research shows that the life time of Everlast automobile tires is normally distributed with a mean value of 70,000 miles. What is the probability of having a tire that lasts more than 80,000 miles.

  What will be the approximate standard deviation of sample

A population of size 1,000,000 claims has mean cycle time of 15 days, and a standard deviation of 4. 100 random samples of each size 64 are selected. What will be the approximate standard deviation of 100 sample means.

  Expected values of the probability distributions

Computing the expected values for the given probability distribution and evaluate the expected values of the following probability distributions

  Constructing confidence interval estimation

The data was used to make inferences regarding the other students taking the course. Construct a 95% confidence interval estimate. Explain your findings so that your non-quantitative partner will understand them. Their data is below:

  Combined verbal and math sat scores problem

Suppose that combined verbal and math SAT scores follow a normal distribution with mean 896 and standard deviation 174. Suppose further that Peter finds out that he scored in the top 3% of SAT scores. Determine how high Peter's score must have bee..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd