Excel functions / Statistics
PHI function
The height of the standard normal bell curve at x.
Syntax
=PHI(x)
Arguments
x: The z-score.
When to use it
PHI gives the height of the standard normal curve at a z-score. For the share of values below a z-score, use NORM.S.DIST with TRUE.
Examples
At z = 0.75
A B C 1 z 2 0.75 0.3011 In C2:
=PHI(A2)→ 0.3011
Common mistakes
- Not a probability. The height of the curve is not a chance. Probabilities come from the area under it.
PHI in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: PHI
- Danish: PHI
- Dutch: PHI
- Finnish: FII
- French: PHI
- German: PHI
- Hungarian: FI
- Italian: PHI
- Norwegian: PHI
- Polish: PHI
- Portuguese (Brazil): PHI
- Portuguese (Portugal): PHI
- Russian: ФИ
- Spanish: FI
- Swedish: PHI
- Turkish: PHI
Related functions
- NORM.S.DIST: The standard normal distribution (mean 0, standard deviation 1) at a z-score.
- GAUSS: The chance that a standard normal value falls between the mean and z standard deviations above it.