Generate a frequency distribution of the data

Question

Discuss the folloiwng:

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?

		Raw Data
	Date
	January 31, 2007	33685	January 31, 2008	35159	January 31, 2009	34511
	April 30, 2007	35200	April 30, 2008	35521	April 30, 2009	34391
	July 31, 2007	34184	July 31, 2008	35365	July 31, 2009	33365
	October 31, 2007	39535	October 31, 2008	40416	October 31, 2009	38129
Yearly Totals		142604		146461		140396
	January 31, 2010	32713	January 31, 2011	36318
	April 30, 2010	35021	April 30, 2011	38335
	July 31, 2010	34793	July 31, 2011	38651
	October 31, 2010	41059	October 31, 2011	44135
Yearly Totals		143586		157439