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

decimal points.

8. Enter a closing parenthesis to end the function.

FREQUENCY

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.

Figure 9-17:

Setting up

bins to use

with the

FREQUENCY

function.

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.