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
- 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
May be interested
- POISSON function - The function returns the Poisson distribution in Excelin predicting the number of events that occur within a specific time, one cannot help but use the poisson function. the following article details how to use the poisson function, the function returns the poisson distribution.
- BETA.INV function - The function returns the inverse of the cumulative distribution function for a specified beta distribution in Excelbeta.inv function: the function returns the inverse of the cumulative distribution function for a specified beta distribution. support functions from excel 2010 version. syntax: beta.inv (probability, alpha, beta, [a], [b])
- LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excellognorm.inv: the function returns the inverse of the logarithmic distribution of x. where ln (x) is usually distributed with parameter mean and standard deviation. use functions to analyze logarithmic change data. support function from excel 2 version
- T.INV function - The function returns the inverse value of the Student t distribution in Excelt.inv: the function returns the inverse value of the student t-distribution. support functions from excel 2010 onwards. syntax: t.inv (probability, deg_freedom)
- FISHER function - The function returns the Fissher transformation at x in Excelfisher function: the function returns the fissher transformation at x. this transformation creates a normal distribution function, using this function to test a hypothesis based on a correlation coefficient. syntax: fisher (x)
- T.DIST.RT - The function returns the Student's t-distribution on the right in Excelt.dist.rt: the function returns the student's t-distribution on the right. functions used in testing the hypothesis of small numbers of data sets. support functions from excel 2010 onwards. syntax: t.dist.rt (x, deg_freedom)
- F.DIST - The function returns the probability distribution F in Excelf.dist function: the function returns the probability distribution f. the function supports the version from excel 2010. syntax: f.dist (x, deg_freedom1, deg_freedom2, cumulative)
- HYPGEOM.DIST - The function returns the hyperbolic distribution in Excelhypgeom.dist: the function returns the hyperinfection distribution, using this function for problems with finite sets of vowismooix observations whether or not they are successful. syntax: hypgeom.dist (sample_s, number_sample, population_s, number_pop, cumulative)
- F.INV function - The function returns the inverse of the probability distribution F in Excelf.inv function: the function returns the inverse of the probability distribution f. support function from the excel 2010 version. syntax: f.inv (probability, deg_freedom1, deg_freedom2)
- F.INV.RT function - The function returns the right-inverse head value of the probability distribution F in Excelf.inv.rt function: the function returns the inverse of the right probability distribution f. support functions from the excel 2010 version. syntax: f.inv.rt (probability, deg_freedom1, deg_freedom2)