Get value of the density function for standard normal distribution
=PHI(x)| Parameter | Description |
|---|---|
x |
The value (z-score) for which you want the density of the standard normal distribution. |
For example, the following formula returns the value of the standard normal density function at 1:
=PHI(1) // returns 0.241970725The PHI function takes a single argument, x, and returns the value of the standard normal density function at that point:
=PHI(-2) // returns 0.053990967
=PHI(-1) // returns 0.241970725
=PHI(0) // returns 0.398942280
=PHI(1) // returns 0.241970725
=PHI(2) // returns 0.053990967The PHI function can be used to calculate PDF values for normal distributions with different means and standard deviations. For example, suppose you h
=PHI(STANDARDIZE(93,83,5)) // returns 0.0539909665The z-score of a value, which measures how many standard deviations a value is from the mean, can be calculated using the STANDARDIZE function:
=STANDARDIZE(93,83,5) // returns 2or manually like this:
z = (value - mean) / stdevThe PHI function returns the #VALUE! error if x is not numeric.
=PHI("apple") // returns #VALUE!