Sidan du har begärt finns tyvärr inte på ditt språk för närvarande. Du kan välja ett annat språk längst ned på sidan eller översätta vilken webbsida du vill till valfritt språk direkt med hjälp av den inbyggda översättningsfunktionen i Google Chrome.

GAUSS function

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. A normal distribution is also commonly known as a Gaussian distribution, from which this function gets its name.

Parts of a GAUSS formula

GAUSS(z)

Part Description Notes
z The number of standard deviations from the mean.
  • The parameter represents how far away from the mean a random variable might fall.
  • A normal distribution is characterized by a mean (μ) and a standard deviation (z * σ).

Sample formulas

GAUSS(1)

GAUSS(B2)

Notes

  • A negative z value causes GAUSS(z) to return a negative number.
  • When z uses the value in another cell (e.g. "GAUSS(B2)"), the GAUSS function returns 0 if there's no data in the cell.
  • Calling GAUSS(z) asks the question, "what's the probability that a random number will be between μ and the standard deviation z * σ?"

Examples

  A B C
1 Function Result Comment
2 =GAUSS(1) 0.3413447461 Probability that a variable falls between the mean and 1 standard deviation above the mean.
3 =GAUSS(-1) -0.3413447461 Probability that a variable falls between the mean and 1 standard deviation below the mean. Note that the result is negative.
4 =2*GAUSS(1) 0.6826894921 Probability that a variable falls within 1 standard deviation of the mean.

Related function

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.

Behöver du mer hjälp?

Testa detta härnäst:

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
Main menu
17579673712211172674
true
Sök i hjälpcentret
true
true
true
true
true
35
false
false