STANDARDIZE

Definition

Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution.

Sample Usage

STANDARDIZE(96,80,6.7)

STANDARDIZE(A2,A3,A4)

Syntax

STANDARDIZE(value, mean, standard_deviation)

value - The value of the random variable to normalize.
mean - The mean of the distribution.
standard_deviation - The standard deviation of the distribution.

Notes

For a given dataset, mean can be calculated using AVERAGE or its related functions and standard_deviation can be calculated using STDEV or its related functions.

See Also

STDEV: Calculates the standard deviation based on a sample.

AVERAGE: Returns the numerical average value in a dataset, ignoring text.

In order to use the STANDARDIZE formula, start with your edited Excellentable

Then type in the STANDARDIZE Formula in area you would like to display the outcome:

Type in the complete STANDARDIZE formula for a cell as shown below:

Excellentable will generate the outcome when hitting enter.

	A	B	C	D
1	State	Data	Arithmetic Mean	Standard Deviation
2	Alabama	42	40	1.5
3	Alaska	41	9	2.5
4	Arizona	56	11	1.1
5	Arkansas	54	7	2.4
6	California	32	5	1.4
7	Colorado	11	4	1.3
8	Connecticut	10	8	2
9
10		1.333333333

	E
1
2
3
4
5
6
7
8
9
10

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.