Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of 0 (zero) and a standard deviation of one.
Applying the Formula
|Formula Name:||Inverse Normal Distribution||Statistics.InverseNormalDistribution(.05)|
|Output Value:||A double that represents the inverse of the normal distribution function.||
The Normal distribution plays a central part in statistical theory. Suppose you make a graph of the probabilities of the numbers of heads you will expect to see if you repeatedly flip a coin 100 times or suppose you select 1000 people of the street and make frequency diagram of their heights. These graphs look similar. Their bell-shaped curve is the most important density function in probability and statistics (see figure below).
Figure1: Graph of Standard Normal Distribution.
A random variable whose density function looks like the following is is called a normal random variable:
The parameter defines where the center, or peak of the distribution will be. This parameter is equal to the mean of distribution. The parameter is the variance. By adjusting this value you can determine whether the distribution will be very spread out or whether most of the probability will be concentrated near the peak. A normal random variable with and is referred to as a standard normal random variable. Its density function is:
If X and Y are independent normal random variables, then X+Y will also be a normal random variable (with mean and variance ). If you add together many independent identically distributed random variables, the resulting sum will have a Normal distribution. Thats one of the reasons why the normal distribution pops up everywhere. It is called central limit theorem.
This example demonstrates how to calculate the inverse of the normal distribution.
|Visual Basic||Copy Code|