PHI function
From Apache OpenOffice Wiki
< Documentation | How Tos
Spreadsheet Lookup functions
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND
Ranking
PHI
Calculates values for a standard normal distribution.
Syntax:
PHI(x)
- The standard normal distribution is a normal distribution with mean μ = 0 and standard deviation σ = 1.
- PHI calculates the probability density function of the standard normal distribution; in other words, it returns NORMDIST(x; 0; 1; 0).
Example:
PHI(0.5)
- returns approximately 0.35206.
NORMDIST(0.5; 0; 1; 0)
- returns approximately 0.35206.
See Also
