Computing a Frequency Distribution in Excel

Fundamentals of Social Statistics by Adam J. McKee

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:  06/03/2021

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.

Doc's Things and Stuff uses Accessibility Checker to monitor our website's accessibility.