Statistics for Excel 2007: Calculate Mean, Median, and Mode


show more Calculating mean, median, and mode provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2007: Business Statistics show less
please wait ...

Calculating mean, median, and mode

When you analyze a data set, you can often gather a great deal of information about the data by finding its central values. In this movie, I'll show you how to calculate three different types of central values: the mean, the median, and the mode. The common word for the arithmetic mean of a data set is the average. It's the sum of the values divided by the number values. So, for example, in this table here, I have seven days and then the sales totals for those days. If I want find the average in cell B1, I can type "=average(" and then the name of the table, which is DailySales. So I will start typing it and then press Tab to accept the formula AutoComplete value.

Now I want the Sales column, so I'll type a left square bracket, start typing Sales, Sales is highlighted, Tab to accept it, right square bracket, and then a right parenthesis to close the formula. When I press Enter, the value appears: 3,825.9. Averages can be misleading if you have one or two disproportiona...

Calculating mean, median, and mode
Video duration: 7m 2s 4h 19m Intermediate

Viewers:

Calculating mean, median, and mode provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2007: Business Statistics

Subject:
Business
Software:
Excel
Author:
please wait ...