STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel

NORM.S.DIST function - The function returns the normalized distribution with a mean of 0 and a standard deviation of 1 in Excel
CONFIDENCE.NORM function - The function returns the confidence interval of the population by using a normalized distribution in Excel

The following article introduces you to the STANDARDIZE function - one of the functions in the statistical function group is very popular in Excel.

STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel Picture 1

Description: The function returns the normalized value from a distribution characterized by mean and standard_dev arguments.

Syntax: STANDARDIZE (x, mean, standard_dev)

Inside:

- x : The value you want to normalize, is a required parameter.

- mean: Arithmetic mean of distribution, is a required parameter.

- standard_dev: The standard deviation of the distribution, is a required parameter.

Attention:

- If standard_dev ≤ 0 -> the function returns the #NUM! Error value

- The equation for the normalized value is:

[Z = frac {{X - mu}} {sigma}]

For example:

Calculate the normalized value of the values in the following data table:

STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel Picture 2

- Calculate the standardized value of 29 . In a cell to calculate, enter the formula : = STANDARDIZE (D6, D8, D9)

STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel Picture 3

- Press Enter -> normalized value of 29 is :

STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel Picture 4

- Calculate the normalized value of -29. In the cell to calculate enter the formula: = STANDARDIZE (D7, D8, D9) -> press Enter -> The normalized value of -29 is:

STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel Picture 5

- Where the standard deviation of the distribution is less than or equal to 0 -> the function returns the #NUM! Error value

STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel Picture 6

Above are instructions and some specific examples when using the STANDARDIZE function in Excel.

Good luck!

Marvin Fry

Update 19 May 2020

You should read it

May be interested

How to use the NORMDIST function in Excel - Function that returns the distribution in Excel
the normdist function returns a distribution with a specified mean and standard deviation. the normdist function has applications in statistics, including hypothesis testing.
BETA.DIST function - The function returns the Beta distribution in Excel
beta.dist function: the function returns the beta distribution to study the variability of a number of things through a sample. support functions from excel 2010 onwards. syntax: beta.dist (x, alpha, beta, cumulative, [a], [b])
BETA.INV function - The function returns the inverse of the cumulative distribution function for a specified beta distribution in Excel
beta.inv function: the function returns the inverse of the cumulative distribution function for a specified beta distribution. support functions from excel 2010 version. syntax: beta.inv (probability, alpha, beta, [a], [b])
PHI function - The function returns the value of the density function for a normal distribution in Excel
phi function: the function returns the value of the density function for a standard normal distribution. support functions from excel 2013 onwards. syntax: phi (x)
LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excel
lognorm.inv: the function returns the inverse of the logarithmic distribution of x. where ln (x) is usually distributed with parameter mean and standard deviation. use functions to analyze logarithmic change data. support function from excel 2 version
T.INV function - The function returns the inverse value of the Student t distribution in Excel
t.inv: the function returns the inverse value of the student t-distribution. support functions from excel 2010 onwards. syntax: t.inv (probability, deg_freedom)
T.DIST.RT - The function returns the Student's t-distribution on the right in Excel
t.dist.rt: the function returns the student's t-distribution on the right. functions used in testing the hypothesis of small numbers of data sets. support functions from excel 2010 onwards. syntax: t.dist.rt (x, deg_freedom)
F.DIST - The function returns the probability distribution F in Excel
f.dist function: the function returns the probability distribution f. the function supports the version from excel 2010. syntax: f.dist (x, deg_freedom1, deg_freedom2, cumulative)
HYPGEOM.DIST - The function returns the hyperbolic distribution in Excel
hypgeom.dist: the function returns the hyperinfection distribution, using this function for problems with finite sets of vowismooix observations whether or not they are successful. syntax: hypgeom.dist (sample_s, number_sample, population_s, number_pop, cumulative)
F.INV function - The function returns the inverse of the probability distribution F in Excel
f.inv function: the function returns the inverse of the probability distribution f. support function from the excel 2010 version. syntax: f.inv (probability, deg_freedom1, deg_freedom2)

STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel

You should read it

May be interested

Office information