To plot a distribution, one option is to use the INT and FREQUENCY functions
in an array formula. If the title "Data" is in cell A1, assume that the data
in column A is the data that you want to count. The "Bins" column consists
of the groupings that you want.

Data Bins Freq
4 1
3 2
2 3
3 4
4 5
5
4
2
3

To get the frequency, select the cell range C1:C5. With the cells still
selected, enter this formula in the formula bar:

=INT(FREQUENCY(A2:A10,B2:B6))

Then, press the Control - Shift - Enter keys at the same time. The
combination of Control - Shift - Enter enter the formula enter the formula as
an "array" formula. An array formula appears with the "{" in the front and a
"}" at the end. The results should look like this:

Data Bins Freq
4 1 0
3 2 2
2 3 3
3 4 3
4 5 1
5
4
2
3

Now just create a column or bar chart using the data in the range C2:C6 as
the source to create your distribution.

----
Regards,
John Mansfield
http://www.pdbook.com



"travish19" wrote:

I have some data that is not a normal distribution. I would like to draw a
distribution chart of this data