The NORMSDIST function in Google Sheets is a statistical function used to evaluate the cumulative distribution function (CDF) of the standard normal distribution. It is particularly helpful for researchers, statisticians, and data analysts when assessing probabilities and making informed decisions based on normal distribution data.

Syntax

NORMSDIST(z)

• z: The numeric value for which you want to retrieve the cumulative distribution function of the standard normal distribution.

Example #1

=NORMSDIST(0)

This function calculates the cumulative probability at a standard normal value of 0. The result is 0.5, meaning that 50% of the distribution lies below this point.

Example #2

=NORMSDIST(1.96)

This function computes the cumulative probability at a standard normal value of 1.96, which equals approximately 0.975. This indicates that 97.5% of the distribution is below this value.

Example #3

=NORMSDIST(-1)

This function assesses the cumulative probability at a value of -1. The result is about 0.1587, implying that approximately 15.87% of the distribution is below this negative value.

Error handling

• VALUE!: This error occurs if the input is not a numeric value.
• NUM!: This may appear if the value is outside the range of allowable inputs, although for most practical purposes, any real number should work.

Conclusion

In summary, the NORMSDIST function in Google Sheets serves as a powerful tool for understanding and analyzing probabilities associated with the standard normal distribution. With its straightforward syntax and flexibility, it can assist users in drawing meaningful insights from statistical data, making it an essential component for professionals in various analytical fields.