Financial Modeling Tutorials

- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Present Value of an Annuity Formula
- Future Value of Annuity Due Formula
- Maturity Value
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- Advantages and Disadvantages of NPV
- Mutually Exclusive Projects
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Break Even Analysis
- Breakeven Analysis Examples
- Break Even Chart
- Benefit Cost Ratio
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Payback Period Advantages and Disadvantages
- Profitability Index
- Feasibility Study Examples
- Cash Burn Rate
- Interest Formula
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Growth Rate Formula
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Compounding
- Compounding Formula
- Compound Interest
- Compound Interest Examples
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Discounting Formula
- Rule of 72
- Geometric Mean Return
- Geometric Mean vs Arithmetic Mean
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- EWMA (Exponentially Weighted Moving Average)
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Relative Change
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- APR vs APY
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Correlation Examples
- Coefficient of Determination
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Standard Deviation Examples
- Effect Size
- Sample Size Formula
- Volatility Formula
- Binomial Distribution Formula
- Multicollinearity
- Hypergeometric Distribution
- Exponential Distribution
- Central Limit Theorem
- Poisson Distribution
- Central Tendency
- Hypothesis Testing
- Gini Coefficient
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- Z Score Formula
- Z Test vs T Test
- F-Test Formula
- Quantitative Research
- Histogram Examples

Related Courses

**Central Tendency – Table of Contents**

## What is Measures of Central Tendency?

Central Tendency is a single value that attempts to describe a set of data by identifying the middle or the central position within the given dataset. Sometimes these measures of the central tendency are called as the measures of middle or the central location. The mean (otherwise known as the average) is the most commonly used measure for central tendency, but there are other methodologies such as the median and the mode.

### Measures of Central Tendency Formula

The formula for Central Tendency is as per below

For Mean x,

Where,

- ∑x is the sum of all the observations in a given dataset
- n is the number of observations

The median will be the center score for a given dataset which when arranged in order of the magnitude.

The mode will be the most frequent score in the given set of data. A histogram chart can be used to identify the same.

### Explanation of the Central Tendency Formula

The mean or the average is the sum of all the observations in the given set of data and that is then divided by the number of observations in the given set of data. So, if there are n observations in a given set of data and they have observations such as x1, x2, …, Xn, the taking some of those is total and dividing the same by observations is mean which tries to bring central point. Median is nothing but the middle value of the observations and is mostly reliable when the data has outliers while the mode is used when the number of observations is recurring frequently and hence will be preferred over mean only when there are such samples where values repeat them the most.

### Examples of Central Tendency Formula (with Excel Template)

Let’s see some simple to advanced examples of the central tendency formula to understand it better.

#### Central Tendency Formula Example #1

**Consider following sample : 33, 55, 66, 56, 77, 63, 87, 45, 33, 82, 67, 56, 77, 62, 56. You are required to come up with a central tendency.**

Solution:

Below is given data for calculation of the measures of central tendency

Using the above information, the calculation of mean will be as follows,

- Mean = 915/15

**Mean will be –**

**Mean = 61**

Calculation of Median will be as follows-

**Median =62**

Since the number of observations is odd, the middle value which is the 8^{th} position will be the median which is 62.

4.9 (1,067 ratings)

Calculation of Mode will be as follows-

**Mode = 56**

For more, we can note from the above table that a number of observations that are recurring most times is 56. (3 times in the dataset)

#### Central Tendency Formula Example #2

**Ryan international school is considering selecting the best players to represent them in the ****inter-school Olympics competition to be organized soon. However, they have observed that their players are spread across the sections and standards. Hence before putting a name in any of the contest, they would like to study the central tendency of their students in terms of height and then weight.**

Height qualification is at-least 160cm and weight should not be more than 70 kgs. You are required to calculate what is the central tendency for their students in terms of height and weight.

Solution

Below is given data for calculation of measures of central tendency.

Using the above information, the calculation of mean of height will be as follows,

= 2367/15

**Mean will be – **

**Mean = 157.80**

A number of observations are 15, hence the mean of height would be 2367/15 = 157.80 respectively.

Therefore, the median of height can be calculated as,

**Median = 155**

The median would be the 8^{th} observation as the number of observations is odd, which is 155 for weight.

Therefore, the mode of height can be calculated as,

**Mode = 171**

Calculation of mean of weight will be as follows,

= 1047.07/15

**Mean of weight will be –**

**Mean = 69.80**

Therefore, the median of weight can be calculated as,

**Median =69.80**

The median would be the 8^{th} observation as the number of observations is odd, which is 69.80 for weight.

Therefore, the mode of weight can be calculated as,

**Mode = 77.00**

Now mode will be the one which occurs more than one time. As it can be observed from the above table, it would be 171 and 77 for height and weight respectively.

Analysis: It can be observed that average height is less than 160 cm, however, weight is less than 70 kgs which could mean Ryan’s school students might not qualify for the race.

The mode is not showing the proper central tendency and is biased upwards, the median is still showing good support.

#### Central Tendency Formula Example #3

**The universal library has got the following count of the most to read books from different clients, and they are interested to know the central tendency of books read in their library. Now you need to do the calculation of central tendency and use mode to decide the no 1 reader.**

Solution:

Below is given data for calculation of measures of central tendency

Using the above information, the calculation of mean will be as follows,

Mean =7326/10

**Mean will be – **

**Mean = 732.60**

Therefore, the median can be calculated as follows,

Since the number of observations is even, there would be 2 middle value which is the 5^{th} and 6^{th} position will be the median which is (800 + 890)/2 = 845.

**Median = 845.00**

Therefore, the mode can be calculated as follows,

**Mode = 1101.00**

We can use below the histogram, to find out mode which is 1100 and readers are Sam and Matthew.

### Relevance and Uses

Below is the high-level summary to know which measure of central tendency should be used in a given sample.

All the measures of central tendency are widely used and are very useful to extract the meaning of the data which gets organized or if someone is presenting that data in front of a large audience and wishes to summarize the data. Fields like in statistics, finance, science, education, etc. everywhere these measures are used. But commonly you would be hearing more of the use of mean or average on a daily basis.

### Recommended Articles

This has been a guide to what is Central Tendency and its definition. Here we discuss the top 3 measures of central tendency – mean, mode and median and its formula along with excel examples & templates. You can learn more about financial modeling from the following articles –

- 250+ Courses
- 40+ Projects
- 1000+ Hours
- Full Lifetime Access
- Certificate of Completion