The PHI function returns the value of the density function for a standard normal distribution.
The PHI function syntax has the following arguments:
- X Required. X is the number for which you want the density of the standard normal distribution.
Example: Let’s look at some Excel PHI function examples and explore how to use the PHI function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following PHI examples would return:
- #VALUE! error – Occurs when x uses a data type that is not valid, such as a non-numeric value.
- #NUM! error – Occurs when x is a numeric value that is not valid.