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

**Formula of Central Limit Theorem (Table of Contents)**

## Central Limit Theorem Definition

The central limit theorem states that the random samples of a population random variable with any distribution will approach towards being a normal probability distribution as the size of the sample increases. The central limit theorem assumes that as the size of the sample in the population exceeds 30, the mean of the sample which the average of all the observations for the sample will b close to equal to the average for the population. Also, the standard deviation of the sample when the size of the sample exceeds 30 will be equal to the standard deviation of the population.

### Central Limit Theorem Formula

We have already discussed that when the sample size exceeds 30, the distribution takes the shape of a normal distribution. For determining the normal distribution of a variable it is important to know its mean and its variance. A normal distribution can be stated as

**X ~ N (µ, α)**

Where

- N= no of observations
- µ= mean of the observations
- α= standard deviation

In most of the cases, the observations do not reveal much in its raw form. So it is very important to standardize the observations in order to be able to compare that. It is done with the help of the z-score. It is required to calculate the Z-score for an observation. The formula to calculate the z-score is

**Z=(X- µ) / α /√n**

Where

- Z= Z-score of the observations
- µ= mean of the observations
- α= standard deviation
- n= sample size

### Explanation

The central limit theorem states that the random samples of a population random variable with any distribution will approach towards being a normal probability distribution as the size of the sample increases. The central limit theorem assumes that as the size of the sample in the population exceeds 30, the mean of the sample which the average of all the observations for the sample will be close to equal to the average for the population. Also, the standard deviation of the sample when the size of the sample exceeds 30 will be equal to the standard deviation of the population. As the sample is randomly chosen from the whole population and the size of the sample is more than 30, then it helps in hypothesis testing and constructing the confidence interval for the hypothesis testing.

### Examples of Central Limit Theorem Formula (with Excel Template)

Let’s take an example to understand the calculation of the central limit theorem equation in a better manner.

#### Example #1

**Let’s understand the concept of normal distribution with the help of an example. The average return from a mutual fund is 12%, and the standard deviation from the mean return for the mutual fund investment is 18%. If we assume that the distribution of the return is normally distributed than let us interpret the distribution for the return in the investment of the mutual fund.**

4.9 (1,067 ratings)

Given,

- The mean return for the investment will be 12%
- Standard deviation will be 18%

So, in order to find out the return for a 95% confidence interval, we can find it out by solving the equation as

**Upper Range = 12 + 1.96(18) = 47%****Lower Range = 12 – 1.96(18) = -23%**

The result signifies that 95% of the times the return from the mutual fund will be in the range of 47% to -23%. In this example, the sample size which is the return of a random sample of more than 30 observation of return will provide us the result for population return of the mutual fund as the sample distribution will be normally distributed.

#### Example #2

**Continuing with the same example let us determine what will be the result for a 90% confidence interval**

Given,

- The mean return for the investment will be 12%
- Standard deviation will be 18%

So, in order to find out the return for a 90% confidence interval, we can find it out by solving the equation as

**Upper Range = 12 + 1.65(18) = 42%****Lower Range = 12 – 1.65(18) = -18%**

The result signifies that 90% of the times the return from the mutual fund will be in the range of 42% to -18%.

#### Example #3

**Continuing with the same example let us determine what will be the result for a 99% confidence interval**

Given,

- The mean return for the investment will be 12%
- Standard deviation will be 18%

So, in order to find out the return for a 90% confidence interval, we can find it out by solving the equation as

**Upper Range = 12 + 2.58(18) = 58%****Lower Range = 12 – 2.58(18) = -34%**

The result signifies that 99% of the times the return from the mutual fund will be in the range of 58% to -34%.

### Relevance and Use of Central Limit Theorem Formula

The central limit theorem is extremely useful as it allows the researcher to predict the mean and the standard deviation of the whole population with the help of the sample. As the sample is randomly chosen from the whole population and the size of the sample is more than 30, then any random sample size taken from the population will approach towards being distributed normally which will help in hypothesis testing and constructing the confidence interval for the hypothesis testing. On the basis of the central limit theorem the researcher is able to choose any random sample from the whole population and when the size of the sample is more than 30 then it can predict the population with the help of the sample as the sample will follow normal distribution and also as the mean and the standard deviation of the sample will be same as the mean and the standard deviation of the population.

### Recommended Articles

This has been a guide to Central Limit Theorem Formula. Here we will do the calculation of central limit theorem along with the practical examples and downloadable excel sheet. You can learn more about financing from the following articles –

- Hypothesis Testing in Statistics
- Examples of Hypergeometric Distribution Formula (with Excel Template)
- What is the Gini Coefficient?
- Formula of Covariance
- Formula of Skewness
- Formula of Coefficient of Variation
- Create Lognormal Distribution in Excel

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