PHI function in Excel

PHI function in Excel


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

1. Description

This is the function that returns the value of the density function for a standard normal distribution.

2. Syntax

PHI (x)

Function syntax PHI Has the following arguments.

x: The number you want to find the normal distribution density for this number (required argument).

3. Note

– 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:

african ham in excel 2

Step 1: In the cell to calculate -> you enter the formula: = PHI (B3)

african ham in excel 3

Step 2: Press Enter -> Using PHI results will have the results as shown below:

african ham in excel 4

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:

african ham in excel 5

If x is an invalid numeric value, function PHI returns an error value #NUM!

african ham in excel 6

If x is an invalid data type, function PHI returns an error value #VALUE!

african ham in excel 7

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.

https://thuthuat.taimienphi.vn/ham-phi-trong-excel-44322n.aspx
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!

.

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *