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.

Function Syntax and Parameters

Syntax: NORM.DIST(x, mean, standard_deviation, cumulative)

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