Table of Contents
This guide explains how to use PHI Function in Excel, including its syntax, required arguments, practical examples, and common errors.
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!
FAQ
What does the PHI function do in Excel?
The PHI function performs the calculation described in this guide. Use the correct arguments and compatible data types for reliable results.
How do I enter the PHI function correctly?
Start with an equals sign, enter PHI, add the required arguments inside parentheses, and confirm that cell references and separators are correct.
Why does the PHI function return an error?
Common causes include missing arguments, invalid data types, incorrect cell references, unsupported values, or regional separator settings.
Reader Comments 0
Sign in with email or Google to join the discussion.