PHI function - The function returns the value of the density function for a normal distribution in Excel
The following article introduces you to the PHI function - one of the functions in the statistical function group is very popular in Excel.
Description: The function returns the value of the density function for a standard normal distribution. Support functions from Excel 2013 onwards.
Syntax: PHI (x)
Inside:
- x: The value you want to determine normalized distribution, is a required parameter .
Attention:
- If x is not numeric -> the function returns the #VALUE! Error value
- If x is an invalid numeric value -> the function returns the #NUM! Error value
For example:
Calculate the value of the density function for a standard normal distribution described in the following data table:
- In the cell to calculate enter the formula : = PHI (C6)
- Press Enter -> normalized density function value of 0.25 is:
- Similarly copying the formula for the remaining values results:
- Where x is not a number -> the function returns the #VALUE! Error value
Above are instructions and some specific examples when using the PHI function in Excel.
Good luck!
You should read it
- WEIBULL function - The function returns the Weibull distribution in Excel
- NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel
- POISSON.DIST function - The function returns the Poisson distribution in Excel
- POISSON function - The function returns the Poisson distribution in Excel
- GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel
- FISHER function - The function returns the Fissher transformation at x in Excel
- CHIDIST function - Function returns the right end probability of the distribution when squared in Excel
- GAMMA.DIST function - The function returns the gamma distribution in Excel
- NORMDIST function - The function returns the normal distribution with the standard deviation and the average value specified in Excel
- BETA.DIST function - The function returns the Beta distribution in Excel
- BETA.INV function - The function returns the inverse of the cumulative distribution function for a specified beta distribution in Excel
- NORMSDIST function - The function returns the normal cumulative distribution in Excel
Maybe you are interested
AMD has surpassed Intel in brand value
SQL way to count NULL and NOT NULL values in a column
Comparing Odroid-N2+ and Raspberry Pi 4: Which option offers better value?
How to receive free gifts from IObit with a total value of nearly 150,000 USD
Write a program to find duplicate values in Python
Write a program to check duplicate values in Python