NORM.DIST

The NORM.DIST function in Google Sheets is a statistical function used to calculate the value of the normal distribution for a given value of x. It is often used in probability calculations and statistical analysis. Explore our comprehensive guide to learn how to use this function effectively.

Parameters

• x: The value for which you want to calculate the normal distribution.
• mean: The arithmetic mean of the distribution.
• standard_deviation: The standard deviation of the distribution.
• cumulative: [Optional] A boolean value indicating whether to calculate the cumulative distribution function (TRUE) or the probability density function (FALSE). The default value is FALSE.

Step-by-Step Tutorial

1. Calculating the probability density function (PDF):

   • Example: =NORM.DIST(1.5, 0, 1, FALSE)
   • Result: 0.129517596

2. Calculating the cumulative distribution function (CDF):

   • Example: =NORM.DIST(1.5, 0, 1, TRUE)
   • Result: 0.933192799

Use Cases and Scenarios

1. Statistical Analysis: Calculate the probability of a given value occurring in a normal distribution.
2. Finance: Determine the probability of a stock price falling within a certain range.
3. Quality Control: Analyze the normal distribution of product measurements.

Related Functions

• NORM.INV: Find the inverse of the normal distribution.
• NORM.S.DIST: Calculate the standard normal cumulative distribution function.

Related Articles

• Understanding Normal Distribution in Statistics
• How to Use Statistical Functions in Google Sheets for Data Analysis