PHI function - The function returns the value of the density function for a normal distribution in Excel

PHI function: The function returns the value of the density function for a standard normal distribution. Support functions from Excel 2013 onwards. Syntax: PHI (x)

The following article introduces you to the PHI function - one of the functions in the statistical function group is very popular in Excel.

PHI function - The function returns the value of the density function for a normal distribution in Excel Picture 1PHI function - The function returns the value of the density function for a normal distribution in Excel Picture 1

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:

PHI function - The function returns the value of the density function for a normal distribution in Excel Picture 2PHI function - The function returns the value of the density function for a normal distribution in Excel Picture 2

- In the cell to calculate enter the formula : = PHI (C6)

PHI function - The function returns the value of the density function for a normal distribution in Excel Picture 3PHI function - The function returns the value of the density function for a normal distribution in Excel Picture 3

- Press Enter -> normalized density function value of 0.25 is:

PHI function - The function returns the value of the density function for a normal distribution in Excel Picture 4PHI function - The function returns the value of the density function for a normal distribution in Excel Picture 4

- Similarly copying the formula for the remaining values ​​results:

PHI function - The function returns the value of the density function for a normal distribution in Excel Picture 5PHI function - The function returns the value of the density function for a normal distribution in Excel Picture 5

- Where x is not a number -> the function returns the #VALUE! Error value

PHI function - The function returns the value of the density function for a normal distribution in Excel Picture 6PHI function - The function returns the value of the density function for a normal distribution in Excel Picture 6

Above are instructions and some specific examples when using the PHI function in Excel.

Good luck!

4.5 ★ | 2 Vote