SheetFX
≡
<< Go back to all functions

STANDARDIZE

The STANDARDIZE function in Google Sheets is a powerful tool to calculate the normalized equivalent of a random variable given the mean and standard deviation of the distribution. Whether you're analyzing data, conducting statistical experiments, or working with financial models, the STANDARDIZE function simplifies the task. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: STANDARDIZE(value, mean, standard_deviation)

Parameters:

  • value: The value you want to standardize.
  • mean: The mean or average of the distribution.
  • standard_deviation: The standard deviation of the distribution.

Step-by-Step Tutorial

  1. Standardizing a single value:
    • Example: =STANDARDIZE(75, 80, 5)
    • Result: -1

Use Cases and Scenarios

  1. Statistical Analysis: Normalize data for easier comparison and interpretation.
  2. Quality Control: Evaluate how measurements deviate from the mean.

Related Functions

  • ZTEST: Calculate the one-tailed probability-value of a z-test.
  • NORMDIST: Calculate the value of the normal distribution function for a given mean and standard deviation.
  • NORMINV: Calculate an inverse value for the normal distribution function given a probability value.

Related Articles