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

Get smart about your data.

Connect, sync, and query data from 37+ data sources, without code.
Get unlimited access free for 14 days.