ProductSolutionsTemplatesResources

PHI

The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1. Learn more.

Video field
Statistical

In Google Sheets, PHI(x) refers to the cumulative standard normal distribution function.

The standard normal distribution is a probability distribution with a mean of 0 and a standard deviation of 1.

The function PHI(x) calculates the probability that a random variable from a standard normal distribution is less than or equal to a given value x.

To use the PHI(x) function in Google Sheets, you can use the formula "=PHI(x)" where "x" is the value for which you want to calculate the cumulative standard normal distribution

The result will be a value between 0 and 1 representing the cumulative probability.

For example, if you want to calculate the cumulative probability that a random variable from a standard normal distribution is less than or equal to 1.5, you can use the formula "=PHI(1.5)" in a cell, and Google Sheets will return the result.

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!