How to use STANDARDIZE Function in Excel

The Excel STANDARDIZE function returns a normalized value (z-score) based on the mean and standard deviation.

Syntax:= STANDARDIZE (x, mean, standard_dev)

The STANDARDIZE function syntax has the following arguments:

  • X    Required. The value you want to normalize.
  • Mean    Required. The arithmetic mean of the distribution.
  • Standard_dev    Required. The standard deviation of the distribution.

Example: Let’s look at some Excel STANDARDIZE function examples and explore how to use the STANDARDIZE function as a worksheet function in Microsoft Excel:

Let’s understand this function using it in an example.

Here we have scores of the students and we need to find the Z score for the data.

STANDARDIZE Function in Excel - How to use STANDARDIZE Function in Excel

To calculate a z-score, you need to calculate the mean and standard deviation. For mean, we will use the AVERAGE function and For Standard deviation, STDEV.P function.

The formulas in B19 and B20 are, respectively:

Syntax:  =AVERAGE(B2:B17)

Result: 7.975

Syntax:  =STDEV.P(B2:B17)

Result: 0.954921463

STANDARDIZE Function - How to use STANDARDIZE Function in Excel

Syntax:  =STANDARDIZE(B2,$B$19,$B$20)

Result: 1.073386702

STANDARDIZE Function 2 - How to use STANDARDIZE Function in Excel

Based on the Excel spreadsheet above, the following STANDARDIZE examples would return:

Syntax: =STANDARDIZE(B3,$B$19,$B$20)
Result: 0.549783433

Syntax: =STANDARDIZE(B4,$B$19,$B$20)
Result: -1.544629645

Syntax: =STANDARDIZE(B5,$B$19,$B$20)
Result: -0.811585068

Syntax: =STANDARDIZE(B6,$B$19,$B$20)
Result: 0.235621471

Syntax: =STANDARDIZE(B7,$B$19,$B$20)
Result: 1.701710626

Syntax: =STANDARDIZE(B8,$B$19,$B$20)
Result: -1.021026376

Syntax: =STANDARDIZE(B9,$B$19,$B$20)
Result: -0.07854049

Syntax: =STANDARDIZE(B10,$B$19,$B$20)
Result: -1.230467683

Syntax: =STANDARDIZE(B11,$B$19,$B$20)
Result: 0.445062779

Syntax: =STANDARDIZE(B12,$B$19,$B$20)
Result: -1.544629645

Syntax: =STANDARDIZE(B13,$B$19,$B$20)
Result: -0.497423106

Syntax: =STANDARDIZE(B14,$B$19,$B$20)
Result: 0.549783433

Syntax: =STANDARDIZE(B15,$B$19,$B$20)
Result: 1.596989972

Syntax: =STANDARDIZE(B16,$B$19,$B$20)
Result: 0.549783433

Syntax: =STANDARDIZE(B17,$B$19,$B$20)
Result: 0.026180163

Note:

  1. #NUM! error – Occurs if the given standard_dev argument is less than 0.
  2. #VALUE! error – Occurs if any of the given arguments are non-numeric.

 

READ:  How to use Z.TEST Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *