How to Calculate Frequency Distribution Using Microsoft Excel

Written by dan howard
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Calculate Frequency Distribution Using Microsoft Excel
COUNTIF scans your data array and returns a value's frequency. (Photos.com/Photos.com/Getty Images)

The frequency distribution is an important statistical tool because it can tell you more specific information about the patterns in a data set than you can learn from simple measures of central tendency and variability. Microsoft Excel includes the "COUNTIF" function to calculate a value's frequency in a data array. Once you've specified the values or character strings you want to count, you can use "COUNTIF" to calculate the frequency distribution in seconds.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Determine the cell addresses that comprise your data array. For instance, if your data is contained in the first 30 cells of column "A," your data array is located at addresses "A1":"A30."

  2. 2

    Insert two blank columns directly to the right of your data array.

  3. 3

    Type the values you want to count the frequency of into the cells in the first new column.

  4. 4

    Click the blank cell directly to the right of the first value you want to search for in your array.

  5. 5

    Type the following formula into the cell: "=COUNTIF(A$1:A$30,B1)".

    Substitute the addresses of your data array in place of "A$1:A$30" in the formula. You must include the "$" symbol to correctly copy the formula to other cells.

    Substitute the address of the cell that contains the first value you want to count the frequency of in place of "B1" in the formula.

  6. 6

    Right-click the cell that contains the formula and click "Copy" in the menu.

  7. 7

    Highlight all blank cells in the formula column adjacent to your list of values you want to count.

  8. 8

    Right-click the selection and click "Paste" in the menu. Excel copies the formula to all cells. The cells display the frequency distribution of the values within the data array.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.