Purchase Solution

Wal-Mart: mean, median, mode, frequency distribution

Not what you're looking for?

Ask Custom Question

Please see attachment for Wal-Mart's data.

1.) Calculate Mean Median and Mode.
2.) Generate a frequency distribution of the data using Microsoft Excel.
3.) Compare the mode median and mean of the data.
4.) Compare the range with the standard deviation of the data.

Once these first 4 items are complete, we can start to answer the following:

1.) How the frequency distribution might be used to better understand and improve the inventory system?
2.) How the normal distribution might be used to better understand and improve the inventory system?
3.) Which measure of central tendency most accurately depicts the inventory data?
4.) Which measure of dispersion most accurately depicts the inventory data?

Purchase this Solution

Solution Summary

Your tutorial arranges the data in a format that permits excel to compute mean, median and mode. The standard deviations, variance and z-scores are computed for each inventory data point. A frequency diagram is created.

Solution Preview

See excel attached for analysis of the data and the frequency diagram.

1.) How the frequency distribution might be used to better understand and improve the inventory system?

Walmart's inventory balances have a seasonal pattern with the traditional measures of central tendency (Mean, Mode, Median) do not reveal. The frequency distribution (bar chart) in excel shows a pattern of higher counts in the fourth quarter of each year (see red circles in Excel on the graph). This seasonality is visually apparent by inspecting the frequency diagram but is not detectable with the statistical measures of central tendency.

2.) How the normal distribution might be used to better understand and improve the inventory ...

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
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.

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.