We can use the Frequency formula when there are multiple columns to compile.  If you have just have one column, you can use the Data Analysis in the Analyze group under the Data tab to perform the frequency.

Step 1: If you do not see this on the menu

  1. In the Backstage view, Click Options
  2. Click Add-ins
  3. In the Manage list, click Excel Add-ins, then click Go.
  4. Check Analysis ToolPak, then click OK
  5. After loading the Toolpak add-in, there will be an Analysis group on the Data tab, with a Data Analysis.

Step 2: Using Histogram to perform the frequency

  1. The input should be a single set of data
  2. The bins should be the bands you want to use for the frequncy
  3. Click Data Analysis,  then select Histogram and click OK
  4. Specify the data range and the bins
  5. Select where you want to place the output

Frequency Shortcut 1

The output is as follows:

Frequency Shortcut 2.png

If you want to add a Histogram chart then select in the dialogue box–> Chart Output.  The result is as follows:

Frequency Shortcut 3

See January 31, 2013 blog for advanced Frequency command.

Enjoy!

Advertisements