The following tutorial article, Taimienphi.vn introduces you to the description of formula syntax and usage of PHI function in Excel. Please follow along.
What is PHI? The Phi symbol (uppercase Φ, lowercase φ) is a mathematical symbol and PHI is the 21st letter of the Greek alphabet. In design and construction techniques, PHI is often used to denote the diameter of a circle as a cross-section of an object that is spherical or cylindrical (such as the diameter of a water pipe). In physics, it is often used to indicate the initial phase of a harmonic oscillator, or magnetic field, per unit area.
How to use the PHI function in MS Excel
PHI function in Excel
This is the function that returns the value of the density function for a standard normal distribution.
Function syntax PHI Has the following arguments.
– x: The number you want to find the normal distribution density for this number (required argument).
– If x is an invalid numeric value, function PHI returns an error value #NUM!
– If x is an invalid data type, such as a value that is not a number, a function PHI returns an error value #VALUE!
4. Illustrative example
Suppose you need to calculate PHI With specific information like spreadsheet image below:
Step 1: In the cell to calculate -> you enter the formula: = PHI (B3)
Step 2: Press Enter -> Using PHI results will have the results as shown below:
Step 3: You drag the mouse to copy the calculation down to the bottom lines of the table, the result will be as the image below:
If x is an invalid numeric value, function PHI returns an error value #NUM!
If x is an invalid data type, function PHI returns an error value #VALUE!
So Taimienphi.vn has just taught you how to use PHI function in Excel. This is the function that returns the value of the density function for a standard normal distribution.
In addition, you should learn and refer to the basic functions in Excel that we have introduced, shared to view and review formulas and how to use functions in Excel. Good luck!