How to Figure Frequency Percentages in Microsoft Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
You can use Excel functions to find the frequency percentage of a data set.

Microsoft Excel is the spreadsheet application included with the Microsoft Office software suite. You can use a wide range of functions in Excel files, including the Frequency function, which will calculate how many data values exist in specific ranges. Once you have found the frequency of values in your data set, you can compare that to the total number of records to figure the frequency percentage.

Advertisement

Step 1

Go to the first column of the spreadsheet and enter each value of your data set in a separate cell.

Video of the Day

Step 2

Use the second column of the spreadsheet to define the ranges for which you want to find the frequency. For example, if you wanted to find the frequency of values between 10 and 15, you would enter those two numbers in separate cells in the second column.

Advertisement

Step 3

Highlight the empty cells in the third column to the right of the range values you just entered in the second column.

Step 4

Type "=FREQUENCY()" into the empty cells. Then fill in the parentheses in the function with two parameters: the cell locations of your data set and the cell locations of your range intervals. For example, if you have 10 values in your data set and three ranges defined in the second column, you would type "=FREQUENCY(A1:A10,B1:B3)."

Advertisement

Advertisement

Step 5

Hold down the "Ctrl" and "Shift" keys and then press "Enter" to save the function. Excel will now display the frequency count of values in the third column.

Step 6

Define a fourth column in your spreadsheet and divide the values in the third column by the total number of records in your data set. For example, if you had 10 total values, you would type "=C1/10" to figure the frequency percentage.

Video of the Day

Advertisement

Advertisement

references