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.

Need more help?

Try these next steps:

Post to the help community Get answers from community members

Statistical

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.

Clear search

Close search

Main menu