EXCEL: Quick Method for Frequency

Leave a comment

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.



EXCEL: Entering Info Without Moving to Next Cell

Leave a comment

As Excel users, we were taught that you enter information in the cell and hit Enter.  This actions navigates to the next cell below. It is in the File Options that sets up it to automatically moves down to the next cell when you Enter.  Guess what, if you hit Control+Enter, the information is enter and it REMAINS in that cell. It does not navigate down to the next cell.