NORMDIST function - Office Support [PDF]

Returns the normal distribution for the specified mean and standard deviation. This function has a ... If cumulative is

3 downloads 22 Views 290KB Size

Recommend Stories


Basic tasks in Visio - Visio - Office Support - Office 365 [PDF]
Each type drawing has templates, each with its own set of shapes that are ready to use. Just drag the shapes onto the drawing page and connect them to make professional-looking diagrams. When you finish, you can save your drawing in many different fo

Lighthouse Home Office Support
Seek knowledge from cradle to the grave. Prophet Muhammad (Peace be upon him)

Herbal Support for Adrenal Function
What we think, what we become. Buddha

Export notes as a PDF - OneNote - Office Support - Office 365 [PDF]
If you want to share some of your notes, but don't want to give someone full access to all of them, you can export notes as an Adobe PDF (portable document format). For example, you might want to share a handout with a colleague who doesn't have OneN

Child Support Office to relocate in February
Don't watch the clock, do what it does. Keep Going. Sam Levenson

united nations support office in somalia
There are only two mistakes one can make along the road to truth; not going all the way, and not starting.

United Nations Support Office in Somalia (UNSOS)
Be who you needed when you were younger. Anonymous

Medical support of gut function in rabbits
We may have all come on different ships, but we're in the same boat now. M.L.King

Office to PDF
If you feel beautiful, then you are. Even if you don't, you still are. Terri Guillemets

editorial office practices (pdf)
The best time to plant a tree was 20 years ago. The second best time is now. Chinese Proverb

Idea Transcript


This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use.

Learn more

Sign in

Apps Install Account Training Admin

NORMDIST function Applies To: Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, More...

Returns the normal distribution for the specified mean and standard deviation. This function has a very wide range of applications in statistics, including hypothesis testing. Important: This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel.

For more information about the new function, see NORM.DIST function.

Syntax NORMDIST(x,mean,standard_dev,cumulative) The NORMDIST function syntax has the following arguments: X Required. The value for which you want the distribution. Mean Required. The arithmetic mean of the distribution. Standard_dev Required. The standard deviation of the distribution. Cumulative Required. A logical value that determines the form of the function. If cumulative is TRUE, NORMDIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.

Remarks If mean or standard_dev is nonnumeric, NORMDIST returns the #VALUE! error value. If standard_dev ≤ 0, NORMDIST returns the #NUM! error value. If mean = 0, standard_dev = 1, and cumulative = TRUE, NORMDIST returns the standard normal distribution, NORMSDIST. The equation for the normal density function (cumulative = FALSE) is:

When cumulative = TRUE, the formula is the integral from negative infinity to x of the given formula.

Example Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.

Data

Description

42

Value for which you want the distribution

40

Arithmetic mean of the distribution

1.5

Standard deviation of the distribution

Formula

Description

Result

=NORMDIST(A2,A3,A4,TRUE)

Cumulative distribution function for the terms above

0.9087888

=NORMDIST(A2,A3,A4,FALSE)

Probability mass function for the terms above

0.10934





Expand your skills E X P LORE TRA I NI NG



Get new features first J OI N OFFI CE I NS I DE RS

Was this information helpful?



Yes



No

Smile Life

When life gives you a hundred reasons to cry, show life that you have a thousand reasons to smile

Get in touch

© Copyright 2015 - 2024 PDFFOX.COM - All rights reserved.