Explore BrainMass
Share

Frequency Distribution and a Z-scores using Microsoft Excel

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

How to Generate a Frequency Distribution and a Z-scores using Microsoft Excel?

Using the following data:

Month Year 1 Year 2 Year 3 Year 4
1 18,000 45,100 59,800 35,500
2 19,800 46,530 30,740 51,250
3 15,700 22,100 47,800 34,400
4 53,600 41,350 73,890 68,000
5 83,200 46,000 60,200 68,100
6 72,900 41,800 55,200 61,100
7 55,200 39,800 32,180 62,300
8 57,350 64,100 38,600 66,500
9 15,400 47,600 25,020 31,400
10 27,700 43,050 51,300 36,500
11 21,400 39,300 31,790 16,800
12 17,100 10,300 31,100 18,900

© BrainMass Inc. brainmass.com October 25, 2018, 4:09 am ad1c9bdddf
https://brainmass.com/statistics/summary-tables/368240

Solution Preview

The solution includes:

First we have to convert this data into one column so that we can generate the frequency distribution and Z-scores from this data. The data is inserted into one column without keeping the record of months and ...

Solution Summary

This solution is comprised of a detailed explanation of standard normal distribution or z score using the Microsoft Excel. In this solution, step-by-step explanation of this complicated topic provides students with a clear perspective of standard normal distribution to Generate a Frequency Distribution and a Z-scores using Microsoft Excel.

$2.19
See Also This Related BrainMass Solution

Measures of central tendency for Walmart: How help with inventory?

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?

View Full Posting Details