DADiSP Worksheet Functions > Function Categories > Statistics and Calculus > CNF2STD

 

CNF2STD

Purpose:

Converts a confidence level (%) to a standard deviation range.

Syntax:

CNF2STD(alpha)

alpha

-

A real or series. The confidence level(s) in %. Defaults to, 99, a 99% confidence level.

Returns:

A real or series. The standard deviation range for the given confidence level.

Example:

cnf2std(99)

 

returns 2.5758, the standard deviation range for a confidence level of 99%.

Example:

W1: {99, 98, 97, 96, 95}

W2: cnf2std(w1)

 

W2 == {2.5758, 2.3263, 2.1701, 2.0537, 1.9600}

 

the standard deviation ranges for confidence levels 99%, 98%, 97%, 96%, and 95%.

Remarks:

CNF2STD uses the built-in INVPROBN function to lookup a z value for a given probability.

See Also:

A2STD

INVPROBN

PDFNORM

PROBN