Microsoft Office Tutorials and References
In Depth Information
Analyzing Data with Percentiles and Bins
2. Determine the high and low values of the data.
You can use the MAX and MIN functions for this.
3. Determine what your bins should be.
This is subjective. For example, if the data has values from 1 to 100, you
can use 10 bins that each cover a range of 10 values. Or you can use 20
bins that each cover a range of 5 values. Or you can use 5 bins that each
cover a range of 20 values.
4. Create a list of the bins by entering the high number of each bin’s
range, as shown in cells D3:D12 in Figure 9-17.
5. Click the first cell where you want the output of FREQUENCY to be
6. Drag down to select the rest of the cells.
There should now be a range of selected cells. The size of this range
should match the number of bins. Figure 9-18 shows what the worksheet
should look like at this step.
to enter the
7. Enter =FREQUENCY( to start the function.
8. Drag the cursor over the sample data, or enter the address of the range.
9. Enter a comma ( ,).
10. Drag the cursor over the list of bins, or enter the address of that range.
Figure 9-19 shows what the worksheet should look like at this point.