Are All Excel Functions Work How To Calculate Frequency
Are All Excel Functions Work Series Of Thresholds

For example, if you had the ages of a group of people in your spreadsheet, you could figure out how many people fall into different age ranges.

Are All Excel Functions Work How To Calculate Frequency

Lets take a look at how to calculate frequency distributions and, with a slight modification, frequency percentages.

You provide the numerical dataset (thats the actual cells you use as your source), a list of bin thresholds (thats the categories into which youre sorting data), and then press CtrlShiftEnter.

Say youre a teacher with a spreadsheet that shows all your students numerical test scores.

You could use the FREQUENCY function to figure out how many students got an A, B, C, D, or F.

The numerical test scores are the dataset and the letter grades form your bin thresholds.

Excel would go through the list of test scores, categorize each score, count the total number of scores that fall into each range, and return an array with five cells showing the total number of scores in each range.

Are All Excel Functions Work Series Of Thresholds

The Dataarray needs to contain valueslike the numerical grades for studentsthat Excel can compare to a series of thresholds defined in the Binsarraylike the letter grades in that same example.

Its just a simple exercise where were going to determine how many of those numbers fall between one and two, between two and three, and so on.

Note that weve left a blank cell at the top of the Binsarray column to account for the number of values in the result array, which will always contain one more value than the Binsarray.

On the drop-down menu, point to the Statistical submenu, scroll down a bit, and then click the FREQUENCY function.

What percentage of our numbers fell between one and two, for example.

Highlight all of the cells in the Results column and then add the following to the end of the formula in the Function Bar.

So, for example, you can now see that 17 of the numbers in the Dataarray column fell in the 1-2 range.

The presence of curly brackets around the formula indicates that it has been entered as an array formula.

Since we launched in 2006, our articles have been read more than 1 billion times.

Are All Excel Functions Work For Mac