Skip to main content

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

 

JavaScript errors detected

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

If this problem persists, please contact our support.

Contact Support Close