To compute a frequency distribution in Excel, use the FREQUENCY function. Note that this function returns an array.
Arrays In Excel For some reason, you cannot just click “OK” to exit the Insert Function dialog box. You must do so by pressing CTRL+SHIFT+ENTER at the same time.
Last Modified: 06/03/2021