STANDARDIZE

Formulas / STANDARDIZE
Calculate a z-score using the mean and standard deviation.
==STANDARDIZE(x,mean,standard_dev)
  • x - the value to normalize
  • mean - the arithmetic mean of the distribution
  • standard_dev - the standard deviation of the data set

Examples

  • =STANDARDIZE(C5,$G$4,$G$5)

    The STANDARDIZE function can be used to calculate a z-score for a given set of data. This is useful for comparing the data to a specific mean and standard deviation. For example, this calculates the z-score for the data in cell C5 using the mean from the AVERAGE function (

  • $G$4) and the standard deviation from the STDEV.P function (
  • $G$5).

  • =STANDARDIZE(A2:C10,AVERAGE(A2:C10),STDEV.P(A2:C10))

    The STANDARDIZE function is also useful for standardizing data when you are working with a large data set. For example, this will calculate the z-score for each cell in the range A2:C10 using the mean and standard deviation for the entire range.

  • =STANDARDIZE(C7,AVERAGE(A2:C10),STDEV.P(A2:C10))

    The STANDARDIZE function can also be used to compare data from different sets. For example, this calculates the z-score for the data in cell C7 using the mean and standard deviation from the range A2:C10.

  • =STANDARDIZE(C8,AVERAGE(A2:C10),STDEV.P(A2:D10))

    The STANDARDIZE function is also useful for comparing data from different distributions. For example, this calculates the z-score for the data in cell C8 using the mean and standard deviation from the range A2:D10.


Summary

The STANDARDIZE function normalizes a value from a distribution by taking into account the arguments of X, mean, and standard_dev.

  • The STANDARDIZE function returns a normalized value, also known as a z-score. This z-score measures how many standard deviations a data point is from the mean, and is on the same scale as the original data.
  • The z-score is calculated using the mean and standard deviation of the data set.

Frequently Asked Questions

What is the STANDARDIZE function?
The STANDARDIZE function is a statistical function used to normalize a value from a distribution. This means it adjusts a value in relation to its mean and standard deviation.
What are the arguments for the STANDARDIZE function?
The arguments for the STANDARDIZE function are X, mean, and standard_dev.
What does the STANDARDIZE function do?
The STANDARDIZE function adjusts a value in relation to its mean and standard deviation. It normalizes a value from a distribution.
How do I use the STANDARDIZE function?
To use the STANDARDIZE function, you need to provide the following arguments: X, mean, and standard_dev. X is the value you want to normalize, mean is the mean of the data set, and standard_dev is the standard deviation of the data set.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV