Manuals/calci/NORMDIST

From ZCubes Wiki
Revision as of 20:41, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"><font color="#000000"><font face="Arial, sans-serif"><font size="2">'''NORMDIST'''</font></font><font face="Arial, sans-s...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
NORMDIST(n, m, sd, c)

Where n   is the value for which the distribution is calculate ,m is the arithmetic mean of the distribution and sd   is the standard deviation of the distribution.

c   is a logical value that determines the form of the function.


 

It calculates the normal distribution for the specified mean and standard deviation.


·       NORMDIST displays error for nonnumeric sd.

  1. When sd <=0, NORMDIST displays error.
  2. The equation for the normal density function (cumulative = FALSE) is:




NORMDIST


 

Let’s see an example in (Column1 Row 1, Column1Row2, Column1Row3)

NORMDIST (C1R1, C1R2, C1R3)

i.e. =NORMDIST (52, 50, 2.5, true) is 0.7885

=NORMDIST (52, 50, 2.5, false) is 0.1159.


Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 52 0.7885 0.1159
Row2 50
Row3 2.5
Row4
Row5
Row6
'