# 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

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.