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.
0 kommentar(er)
