Mean, median, and mode are different measures to determine average in a numerical data set. They each try to summarize a dataset with a single number to represent a “typical” data point from the dataset.

Mean

The “average” number is found by adding all data points and dividing by the number of data points.

Example: The mean of 9, 5, and 1 is (9+5+1)/3 = 15/3 =5

How to find Mean using Excel?

The mean of a dataset in Excel can be found it by applying the formula “Average” to the data set. Also if you want to calculate the mean quickly you can just select the range. In the bottom right corner, you can find average of the array.

For example:

Median

Median also; The middle number is found by ordering all data points in ascending order and picking out the one in the middle (or if there are two middle numbers, taking the mean of those two numbers).

Example: The median of 9, 5, and 1 is 5 because, when the numbers are put in order (1,5, 9) the number 5 is in middle.

How to find Median Using excel?

The median of a dataset in Excel can be found it by applying the formula “Median” to the data set.

For Example:

Mode

Mode is the number which occurs most frequently in data set    

Example: The mode of (4, 4, 2, 4, 3, 2 ,2 ,2) is 2 because it occurs four times, which is more than any other number.

How to find Mode using Excel?

The mode of a dataset in Excel can be found it by applying the formula “Mode” to the data set.

For example:

Standard Deviation

Standard deviation is a measure of the amount of variation or dispersion of a set of values. A low standard deviation indicates that the values tend to be close to the mean of the set, while a high standard deviation indicates that the values are spread out over a wider range.

How to find standard deviation using excel?

The median of a dataset in Excel can be found it by applying the formula “STDEV” to the data set.

For example:

We hope that you liked this article and found it informative.

Popular Course in this category
Microsoft Excel for Finance Registered Microsoft Partner | Specialized for Core Finance | 20+ hours Videos

Write A Comment