##### Page tree
Go to start of banner

# Estimating the mean of a Normal distribution when the distribution's standard deviation is unknown

For a given set of n data values randomly sampled from an assumed Normal distribution, with unknown mean m and unknown standard deviation s, the distribution of uncertainty of the true mean is calculated from a Student-t distribution:

(1)

where t(n-1) is a standard Student-t distribution with (n-1) degrees of freedom. [This page provides an explanation of the derivation of Equation 1].

${\widehat{\sigma}}$ is the unbiased single point estimate of the true standard deviation (calculated by STDEV( ) in Excel), given by:

The standard Student-t distribution is unimodal and symmetric about zero (in the standard student distribution, the mode = 0). The formula therefore centers the uncertainty distribution of the value of the true mean m around the sample mean x which is the "best guess". It also has a spread that increases with the standard deviation ${\widehat{\sigma}}$ and decreases with the square root of the sample size n. The Student-t distribution looks quite like a unit Normal distribution but flatter, with greater spread than the unit Normal distribution: a Standard Student(0,1,n) or Student(n) distribution has a standard deviation of ${\sqrt{\nu/(\nu-2)}}$ compared with a standard deviation of 1 for the unit Normal distribution: Figure 1 Examples of the Student-t distribution

In fact, the larger n gets, the closer the Student-t distribution approaches a unit Normal distribution (i.e. Normal(0, 1)). So, for large n (greater than 20 is usually fine), Equation 1 is very well approximated by:

This following model lets you generate values for the above uncertainty distribution for m for a data set.

The links to the Estimate Mean & StDev for Normal Distribution When Neither Known software specific models are provided here:

Crystal Ball Estimate_mean_and_stdev_for_Normal_distribution_when_neither_known

Note that in Crystal Ball we can write equation 1 as the following Student distribution:

@Risk Estimate_mean_and_stdev_for_Normal_distribution_when_neither_known

Comparison with the Bayesian approach

The Bayesian derivation of Equation 2 is given here.

• No labels