ProductSolutionsTemplatesResources

GAUSS

The GAUSS function returns the probability that a random variable, drawn from a normal distribution, will be between the mean and z standard deviations above (or below) the mean. Learn more.

Video field
Statistical

In Google Sheets, the GAUSS function is used to calculate the cumulative distribution function (CDF) of the standard normal distribution.

It returns the probability that a value in a standard normal distribution is less than or equal to a given z-score.

The syntax for the GAUSS function is as follows:

GAUSS(z)

Where:

z is the value for which you want to calculate the cumulative distribution.

For example, if you want to calculate the probability that a value in a standard normal distribution is less than or equal to 1.5, you would use the following formula:

=GAUSS(1.5)

The GAUSS function returns a value between 0 and 1, representing the cumulative probability.

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!