Identifying Multiple Modes in Excel

Very early in my intro-level statistics courses, I always cover the topics of mean, median, and mode. For any dataset, there can only be a single mean and/or median value, but there can be multiple modes. For some strange reason, the =mode() command in Excel will only provide the first mode that appears in a dataset, even when multiple modes exist! For this reason, I made a guide on how to use the =mode.mult() command. Never again should you incorrectly identify the number of modes in a dataset!

Here is the link: https://mattchoward.com/multiple-modes-in-excel/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s