Share
Explore BrainMass

Frequency Distribution and a Z-scores using Microsoft Excel

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

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