Statistics How To

Mode in Excel 2013, 2010, 2007: Video and Easy Steps

Excel for Statistics > Mode in Excel

Contents:

How to find the Mode in Excel 2013


Watch the mode in Excel 2013 video or read the steps below:

mode in excel 2013The mode is the number that appears the most in a set of data. For example, the mode for 3,4,4,5,6,7,7,7,8,9 is 7 (it appears three times). While it seems like a simple task, it gets much more complicated with large data sets — especially if the numbers are out of order so that you can’t spot potential patterns. Excel can find the mode for millions of numbers. Why is it useful? Because it’s the most popular count. For example, you might have a data set of a million people, assign numbers to purchases (i.e. TV=1, CD=2, Phone=3) and knowing that most people buy phones could be a valuable marketing tool. There are a couple of ways to find the mode in Excel 2013: the MODE function and Data Analysis Toolpak.

Find the Mode in Excel 2013: MODE Function

Step 1: Type your data into a single column for each set you want to find the mode for. For example, type your data set into F1 to F20.
Step 2: Type “=MODE(F1:F20)”
where “F1:F20” is the location of your data set.
Step 3: Press “Enter.”

Find the Mode in Excel 2013: Data Analysis

Step 1: Click the “Data” tab and then click “Data Analysis.”
Step 2: Click “Descriptive Statistics” and then click “OK.”
Step 3: Click the Input Range box and then type the location for your data. For example, if you typed your data into cells A1 to A10, type “A1:A10” into that box
Step 4: Click the radio button for Rows or Columns, depending on how your data is laid out.
Step 5: Click the “Labels in first row” box if your data has column headers.
Step 6: Click the “Descriptive Statistics” check box.
Step 7: Select a location for your output. For example, click the “New Worksheet” radio button.
Step 8: Click “OK.”

Mode in Microsoft Excel 2007-2010: Overview

Watch the video to see how to find a mode in Microsoft Excel 2007-2010, or read the steps below.

Mode in Microsoft Excel 2007/2010: Steps

mode in microsoft excel

Sorting numbers in Excel can make it easier to find the mode.

Use a function to calculate the mode in Microsoft Excel

Step 1:Type your data into one column. Enter only one number in each cell. For example, if you have twenty data points, type that data into cells A1 through A20. Press “Enter” after each number entry to move down the column.
Step 2:Click a blank cell anywhere on the worksheet and then type “=MODE.SNGL(A1:A2)” without the quotation marks.
Step 3:Change the range in Step 2 to reflect your actual data. For example, if your numbers are in cells A1 through A20, change A1:A2 to A1:A20.
Step 4:Press “Enter.” Excel will return the mode in the cell with the formula.

Use Data Analysis to calculate the mode in Excel

Step 1:Complete Step 1 above.
Step 2:Click the “Data” tab and then click “Data Analysis.” If Data Analysis does not show up on your ribbon, it means you don’t have it loaded. How to load the Data Analysis Toolpak.
Step 3:Click “Descriptive Statistics.

Tip: You could also type up to 254 numbers in the MODE.SNGL argument. Click on a cell and then type “MODE.SNGL(num1,num2,num3…)” where num1,num2,num3 are your actual numbers. For example “=MODE.SNGL({5.6,4,4,3,2,4})” would return 4 as the mode for the data set.
Tip: Earlier versions of Excel used “MODE” instead of “MODE.SNGL.” The mode function was replaced in Excel 2010 because the algorithm was inaccurate.

Note on the MODE.MULT function: The steps for using the MODE.MULT function are exactly the same. However, the MODE.MULT function will tell you if there are multiple modes.

Check out our YouTube channel for more Excel tips and help!

------------------------------------------------------------------------------

If you prefer an online interactive environment to learn R and statistics, this free R Tutorial by Datacamp is a great way to get started. If you're are somewhat comfortable with R and are interested in going deeper into Statistics, try this Statistics with R track.

Comments are now closed for this post. Need help or want to post a correction? Please post a comment on our Facebook page and I'll do my best to help!
Mode in Excel 2013, 2010, 2007: Video and Easy Steps was last modified: November 5th, 2017 by Stephanie Glen