Computing a Frequency Distribution in Excel

Fundamentals of Social Statistics

 

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.
Figure 8: Frequency Distributions in Excel.
Figure 8: Frequency Distributions in Excel.

[ Back | Contents | Next ]

Last Modified:  02/18/2019

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.