![how to make a frequency distributrion in excel for a mac how to make a frequency distributrion in excel for a mac](https://www.exceldemy.com/wp-content/uploads/2014/01/Frequency-Distribution-Table-Excel-Img34.png)
HOW TO MAKE A FREQUENCY DISTRIBUTRION IN EXCEL FOR A MAC SERIES
The “Data_array” needs to contain values-like the numerical grades for students-that Excel can compare to a series of thresholds defined in the “Bins_array”-like the letter grades in that same example.
![how to make a frequency distributrion in excel for a mac how to make a frequency distributrion in excel for a mac](https://s3.studylib.net/store/data/008348680_1-1546b17bda73e2dcc58d9d9bc8860064.png)
The FREQUENCY function requires two arrays as inputs: a “Data_array” and a “Bins_array.” Arrays are simply lists of values. 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. If you round scores to the nearest tenth of a percent, these ranges would apply:į <= 59.9 < D <= 69.9 < C <= 79.9 < B <= 89.9 < AĮxcel would assign a score of 79.9 to the C range while a score of 98.2 would fall into the A range. You would apply the FREQUENCY function to a list of student’s test scores, and the function would count how many students got which letter grade by comparing each test score to the range of values that define the different letter grades. The numerical test scores are the dataset and the letter grades form your bin thresholds. You could use the FREQUENCY function to figure out how many students got an A, B, C, D, or F. Say you’re a teacher with a spreadsheet that shows all your student’s numerical test scores. So, how might you use it? Well, here’s a quick example. You provide the numerical dataset (that’s the actual cells you use as your source), a list of bin thresholds (that’s the categories into which you’re sorting data), and then press Ctrl+Shift+Enter. Excel’s FREQUENCY array function lets you calculate a dataset’s frequency distribution.