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.
=STANDARDIZE =STANDARDIZE
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
- AVERAGE The AVERAGE function in Sourcetable calculates the average numerical value of its arguments.
- MAX The MAX function returns the largest value from a group of values provided as numbers, names, arrays, or references.
- MIN The MIN function returns the smallest value in a set of numerical, name, array, or reference arguments. It is optional to include the first argument, number1, and additional subsequent arguments.
- PERCENTILE The PERCENTILE function is a Sourcetable function used to calculate the kth percentile of a set of values. It can be used to set a threshold of acceptance, and the accuracy may be improved in later versions, with interpolation to determine the value at the k-th percentile if k is not a multiple of 1/n.
- PERCENTRANK The PERCENTRANK function is used to measure the relative standing of a value in a data set as a percentage. It can be used to compare the rank of a value with other values in the data set and new functions can provide improved accuracy.
- ZTEST The ZTEST function is a statistical tool that calculates the probability that the sample mean is greater than the average of observations in the data set. It offers improved accuracy compared to other tests.
- STDEV The STDEV function is a statistical function used to calculate the standard deviation of a sample or population. It requires two or more numerical values and can take up to 255 arguments. The STDEVP or STDEV.P function should be used for population standard deviation.
- STDEVP The STDEVP function calculates the standard deviation for data in a population, providing a measure of how spread out the data is in relation to the mean.
- VAR The VAR function is used to calculate a sample variance and can include logical values, text, and error values in the arguments. It may be replaced with new functions that offer improved accuracy and better names.
- VARP The VARP function calculates the population variance, while the VAR function calculates the sample variance. VARPA also takes into account logical values and text when determining the variance.