Using the FREQUENCY function to create a frequency distribution can be a bit tricky. This function always returns an array, so you must use it in an array formula that’s entered into a multicell range.

Figure 17-5 shows some data in range A1:E25 (named Data). These values range from 1 to 500. The range G2:G11 contains the bins used for the frequency distribution. Each cell in this bin range contains the upper limit for the bin. In this case, the bins consist of <=50, 51–100, 101–150, and so on.

FIGURE 17-5
Creating a frequency distribution for the data in A1:E25.

To create the frequency distribution, select a range of cells that corresponds to the number of cells in the bin range (in this example, H2:H11). Then enter the following array formula (press Ctrl+Shift+Enter to enter it):

{=FREQUENCY(Data,G2:G11)}

The array formula returns the count of values in the Data range that fall into each bin. To create a frequency distribution that consists of percentages, use the following array formula:

{=FREQUENCY(Data,G2:G11)/COUNT(Data)}

Figure 17-6 shows two frequency distributions—one in terms of counts and one in terms of percentages. The figure also shows a chart (histogram) created from the frequency distribution.

FIGURE 17-6
Frequency distributions created by using the FREQUENCY function.

• Review: What Fish Don't Want You to Know - An Insider's Guide to Freshwater Fishing When it comes to freshwater fishing, one can never learn everything there is to know. What the book entitled “What...
• Import Prosper.com Listing, Loan, Group, Member Data into Microsoft Sql Server 2000 Prosper.com makes all publicly available data accessible via a data export.  They also provide tools for importing that data into...
• MetaStock Peak Functions Explained Watch this video for more MetaStock tips and tricks.The Peak function allows you to refer to a peak (i.e. distinct...
• GW in Italy since 1850, July GW in Italy since 1850, July 28/06/2010 In a few days we come in July, in the heart of Summer,...
• Golf Laser Range Finder Caddy 600 Meter w/Battery - Pro Level Quality User Reviews Send this to a friend Golf Laser Range Finder Caddy 600 Meter w/Battery - Pro Level Quality Manufacturer:...