A2STD

Purpose:

Converts an alpha confidence level to a standard deviation range.

A2STD(alpha)

alpha

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

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

a2std(0.01)

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

W1: {0.01, 0.02, 0.03, 0.04, 0.05}

W2: a2std(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%.

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