Microsoft Office Tutorials and References
In Depth Information
Analyzing Data with Percentiles and Bins
7. If you want to have more or less than three decimal points returned
in the result, enter a comma ( ,) and then enter the number of desired
8. Enter a closing parenthesis to end the function.
The FREQUENCY function places the count of values in a sample into bins.
A bin represents a range of values, such as 0–1 or 20–29. Typically, the bins
used in an analysis are the same size and cover the entire range of values. For
example, if the data values range from 1–100, you might create ten bins each,
ten units wide. The first bin would be for values of 1 to 10, the second bin
would be for values of 11 to 20, and so forth.
Figure 9-17 illustrates this. There are 300 values in the range B3:B302. The
values are random, between 1 and 100. Cells D3 through D12 have been set as
bins that each cover a range of ten values. Note that, for each bin, its number
is the top of the range it’s used for. For example, the 30 bin is used for
holding the count of how many values fall between 21 and 30.
A bin holds the count of values within a numeric range — the number of
values that fall into the range. The bin’s number is the top of its range.
bins to use
FREQUENCY is an array function and requires specific steps to be used
correctly. Here is how it’s done:
1. Enter a list of values.
This can be a lengthy list and likely represents some observed data,
such as the age of people using the library or the number of miles driven
on the job. Obviously, you can use many types of observable data.