Excel PHI Function
The Excel PHI function returns the value of density distribution for a standard normal distribution for a given number.
PHI function returns a numeric value.
1. If x is a number value that is not valid, an error value #NUM! is returned.
2. If x is a data type that is not valid, such as a non-numeric value, an error value #VALUE! is returned.
Excel 2013 and later versions
Usage and Examples
To get the related values of density distribution for the standard normal distributions for values between -2 and 2 which is listed in cell B3:B23 with 0.2 as an interval, please use the PHI function in the top result cell as below:
For making the reference auto-changing, you can use the cell reference in the formula as this:
Press Enter key, then drag the auto-fill handle down to the end of the list.
Excel F.INV Function
The Excel F.INV function returns the inverse of F probability distribution. If p (probability) = F.DIST(x,…), then F.INV(p,…)= x.
Excel FDIST Function
The Excel FDIST Function returns the (right-tailed) F probability distribution which is usually used to measure the degree of diversity between two data sets.
Excel EXPON.DIST Function
EXPON.DIST function used in Excel 2010, returns the exponential distribution based on the given x value and the parameter of the distribution.
Excel F.DIST Function
The Excel F.DIST function returns the F probability distribution which is usually used to measure the degree of diversity between two data sets.
The Best Office Productivity Tools