GAUSS
Formulas / GAUSSCalculate the probability of a standard normal population member falling between the mean and standard deviations.
GAUSS(z)
- z - a number
Examples
=GAUSS(2)The GAUSS function in Sourcetable returns the probability that a member of a standard normal population will fall between the mean and the provided standard deviation from the mean. For example, this would return the probability that a member of a standard normal population would fall between the mean and 2 standard deviations from the mean.
=GAUSS(-1)The GAUSS Function is useful when performing statistical analysis and calculating probabilities. For example, if a sample population has a mean of 0 and a standard deviation of 1, and would return the probability that a member of the population would be less than -1.
=GAUSS(3)The GAUSS Function is also useful when calculating z-scores. A z-score is a measure of how many standard deviations a value is from the mean. For example, if a sample population has a mean of 5 and a standard deviation of 2, and would return the probability that a member of the population would have a z-score of 3.
=GAUSS(2)The GAUSS Function is also useful when calculating confidence intervals. For example, if a sample population has a mean of 10 and a standard deviation of 4, and would return the probability that a member of the population would have a confidence interval of 10 ± 2.
Summary
The GAUSS function is used to calculate the probability of a standard normal population member falling between a mean and its standard deviation. It requires a numerical argument to work.
- The GAUSS function calculates the probability that a standard normal population will fall between the mean and a specified z-value from the mean, and returns a number as its argument.
- The number returned by the GAUSS function is the probability.
Need help with Formulas?
Frequently Asked Questions
What is the GAUSS function?
What is the argument required for the GAUSS function?
What are the steps to use the GAUSS function?
- Determine the z-value which is the number of standard deviations from the mean.
- Input the z-value into the GAUSS function.
- Calculate the probability that a member of a standard normal population will fall between the mean and the z-standard deviation from the mean.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.