PHI function

The PHI function returns the value of the density function for a normal distribution with mean 0 and standard deviation 1, calculated with the formula .

Parts of a PHI function

PHI(x)

Parts Description
x The input to the standard normal distribution function.

Sample formula

PHI(0.25)

Notes

This is a special case of the NORMDIST function, where mean is 0, standard deviation is 1, and 'cumulative' is false.

Examples

  A B
1 Formula Result
2 =PHI(0.5) 0.3520653268
3 =PHI(1) 0.2419707245
4 =PHI(1.5) 0.1295175957

Related functions

  • STDEV: The STDEV function calculates the standard deviation based on a sample.
  • NORMDIST: The NORMDIST function returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
10831638542042535403
true
Search Help Center
true
true
true
true
true
35
false
false