ExcelFlux

STANDARDIZE function

a normalized value.

Statistical

Where can you use it?

Analytics, quality and research teams. Use this group to examine distributions, variability or relationships in measurements, sales or service durations.

Scenario in the workbook

Measure a score in standard deviations from its mean. A zero standard deviation is invalid.

A worked example from the workbook

RowABC
6InputSecond inputThird input
711510015
810010015
97010015
Record 1
=STANDARDIZE(A7,B7,C7)

Expected result1

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=STANDARDIZE(115,100,15)
Turkish Excel · tr-TR
=STANDARTLAŞTIRMA(115;100;15)

Expected result

1

Worked examples

Measure a score in standard deviations from its mean. A zero standard deviation is invalid.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 Input Second input Third input
7 115 100 15
8 100 100 15
9 70 100 15
Case Formula Expected result
Record 1 =STANDARDIZE(A7,B7,C7) 1
Record 2 =STANDARDIZE(A8,B8,C8) 0
Record 3 =STANDARDIZE(A9,B9,C9) -2
Microsoft Excel reference