# NORM.DIST

## What is NORM.DIST?

NORM.DIST is a statistical function that is used to calculate the cumulative probability of a normal distribution for a specified mean and standard deviation. In other words, it helps you calculate the likelihood that a value falls within a certain range of values in a normal distribution.

## Syntax

The syntax for NORM.DIST is as follows:

NORM.DIST(x, mean, standard_dev, cumulative)

``` - x: The value you want to calculate the cumulative distribution for. - mean: The arithmetic mean of the distribution. - standard_dev: The standard deviation of the distribution. - cumulative: A logical value that determines the form of the function. If true, NORM.DIST returns the cumulative distribution function; if false, it returns the probability density function. Example 1: Calculating the Cumulative Distribution Function Let's say you have a normal distribution with a mean of 50 and a standard deviation of 10. You want to calculate the probability of a value falling between 40 and 60 in this distribution. Here's how you would use NORM.DIST: ```

=NORM.DIST(60, 50, 10, TRUE) – NORM.DIST(40, 50, 10, TRUE)

``` This formula calculates the cumulative distribution function for 60 and subtracts it from the cumulative distribution function for 40. The result is the probability of a value falling between 40 and 60 in the distribution, which in this case is approximately 0.6827. Example 2: Calculating the Probability Density Function Let's say you want to calculate the probability density function for a normal distribution with a mean of 60 and a standard deviation of 5 at the value x = 65. Here's how you would use NORM.DIST: ```

=NORM.DIST(65, 60, 5, FALSE)

``` This formula calculates the probability density function for x = 65 in the distribution. The result is approximately 0.1295. NORM.DIST is a powerful tool that can help you calculate probabilities and statistical measures in Power BI. By understanding its syntax and different uses, you can use it effectively in your data analysis projects. Whether you're calculating the cumulative distribution function or the probability density function, NORM.DIST is an essential function that every Power BI user should know. Power BI DAX Training Courses by G Com Solutions (0800 998 9248) Power BI DAX Intensive Training Course £1,050.00 – £26,550.00 Select optionsContinue Loading Done Power BI DAX Introduction £474.00 – £11,700.00 Select optionsContinue Loading Done Power BI DAX Intermediate £395.00 – £9,750.00 Select optionsContinue Loading Done Power BI DAX Advanced £474.00 – £11,700.00 Select optionsContinue Loading Done Upcoming Courses Contact Us Subject Your Name (required) Company/Organisation Email (required) Telephone Training Course(s) Power BI Intensive TrainingPower BI introduction Power BI IntermediatePower BI AdvancedDAXPower Query MPower BI CertificationPower BI AdministrationPower PlatformPower AutomatePower AppsOTHER Your Message Upload Example Document(s) (Zip multiple files) ```
``` ```
``` ```
``` ```
``` ```
``` ```