Normal Distribution
Parameters
- continuous scale parameter
()
- continuous location parameter
Domain
Probability Density Function
Cumulative Distribution Function
where is the
Laplace Integral.
Worksheet and VBA Functions
The following worksheet
and VBA functions are available for
this distribution:
Description |
VBA Functions |
Worksheet Functions |
Distribution Fitting |
- |
=DistFit("Normal";Data)
|
Probability Density Function |
NormalPdf(x,sigma,mu) |
=NormalPdf(sigma;mu)
=DistPdf("Normal(sigma;mu)";x)
|
Cumulative Distribution Function |
NormalCdf(x,sigma,mu) |
=NormalCdf(sigma;mu)
=DistCdf("Normal(sigma;mu)";x)
|
Survival Function |
NormalSurv(x,sigma,mu) |
=DistSurv("Normal(sigma;mu)";x)
|
Hazard Function |
NormalHaz(x,sigma,mu) |
=NormalHaz(sigma;mu)
=DistHaz("Normal(sigma;mu)";x)
|
Cumulative Hazard Function |
NormalCumHaz(x,sigma,mu) |
=DistCumHaz("Normal(sigma;mu)";x)
|
Inverse CDF (Quantile Function) |
NormalInv(P,sigma,mu) |
=NormalInv(sigma;mu)
=DistInv("Normal(sigma;mu)";P)
|
Random Numbers |
NormalRand(sigma,mu) |
=NormalRand(sigma;mu)
=DistRand("Normal(sigma;mu)")
|
Mode |
NormalMode(sigma,mu) |
=DistMode("Normal(sigma;mu)")
|
Mean |
NormalMean(sigma,mu) |
=NormalMean(sigma;mu)
=DistMean("Normal(sigma;mu)")
|
Variance |
NormalVar(sigma,mu) |
=NormalVar(sigma;mu)
=DistVar("Normal(sigma;mu)")
|
Standard Deviation |
NormalStdev(sigma,mu) |
=NormalStdev(sigma;mu)
=DistStdev("Normal(sigma;mu)")
|
Skewness |
NormalSkew(sigma,mu) |
=DistSkew("Normal(sigma;mu)")
|
(Excess) Kurtosis |
NormalKurt(sigma,mu) |
=DistKurt("Normal(sigma;mu)")
|
|