How to use NORMDIST function in Excel

NORMDIST is a function that returns a distribution with a standard deviation and a confirmed average. The NORMDIST function applies in statistics, including hypothesis testing.

When working with data tables, Excel statistics, knowing and using Excel functions will help you complete your work. And in today's article, Network Administrator will introduce you to NORMDIST function in excel and how to use the function.

The NORMDIST function returns a normal distribution in Excel with a standard deviation and a defined mean. The function will be applied in the statistics table, examining the hypothesis. The following article uses NORMDIST function for Excel 2003 version to Excel 2013.

Use NORMDIST function in Excel

We have a syntax to use NORMDIST function (x, mean, standard_dev, cumalative).

In it :

  1. x: is the value to be distributed. Required parameters
  2. mean: The arithmetic average value of distribution. Required parameters.
  3. standard_dev: Standard deviation of distribution. Required parameters.
  4. cumalative: The logical value determines the function form. Required parameters.
  5. cumalative = true: Returns the result of the cumulative distribution function
  6. cumalative = false: Returns the result of the probability density function.

Note:

  1. If the average or standard deviation is not in the numerical form => the function returns the #VALUE! Error.
  2. If average = 0 and standard deviation = 1, cumulative = True => the function returns NORMSDIST normal distribution.
  3. If the standard deviation is less than 0 => the function returns the value #NUM !.
  4. When the cumulative value = TRUE => the distribution applies from negative negative to x value.

We have an example. The distribution of value 92 according to the table below.

How to use NORMDIST function in Excel Picture 1How to use NORMDIST function in Excel Picture 1

Case 1: Cumulative value TRUE (Cumalative = true)

Step 1:

In the cell to calculate, we enter the formula: = NORMDIST (C3, C4, C5, TRUE) .

How to use NORMDIST function in Excel Picture 2How to use NORMDIST function in Excel Picture 2

Step 2:

After entering the formula, press Enter and get the result as shown below.

How to use NORMDIST function in Excel Picture 3How to use NORMDIST function in Excel Picture 3

Case 2: Cumulative value = FALSE (Cumalative = false)

Step 1:

We enter the formula as follows: = NORMDIST (C3, C4, C5, FALSE) .

How to use NORMDIST function in Excel Picture 4How to use NORMDIST function in Excel Picture 4

Step 2:

You also press Enter and get the result as shown below:

How to use NORMDIST function in Excel Picture 5How to use NORMDIST function in Excel Picture 5

Case 3: If replacing the standard deviation = 1 and the mean = 0, accumulate = True> NORMDIST (92) = NORMSDIST (92)

NORMDIST function value (92

You read the formula: = NORMDIST (C3, C4, C5, TRUE) . And the result will look like below.

How to use NORMDIST function in Excel Picture 6How to use NORMDIST function in Excel Picture 6

NORMSDIST function value (92):

We enter the formula: = NORMSDIST (C3) and the result is as below.

How to use NORMDIST function in Excel Picture 7How to use NORMDIST function in Excel Picture 7

Thus, if the standard deviation = 1 average value = 0 and cumulative = true => NORMSDIST function is equal to NORMDIST function value.

The above is a tutorial on using NORMDIST function in Excel to calculate normal distribution with standard deviation and special case between NORMSDIST function and NORMDIST function.

Refer to the following articles:

  1. Summary of expensive shortcuts in Microsoft Excel
  1. 10 ways to recover corrupted Excel files
  1. How to reopen Word, Excel or PowerPoint files when closed but not saved yet?

I wish you all success!

5 ★ | 1 Vote