writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + − +
no edit summary
<div style="font-size:30px">'''STANDARDIZE(x,m,sd)'''</div><br/>
<div style="font-size:30px">'''STANDARDIZE (X,Mean,StandardDeviation)'''</div><br/>
*<math>x </math> is the value.
*<math>X </math> is the value.
*<math> m </math> is the mean.
*<math>Mean</math> is the mean.
*<math> sd </math> is the standard deviation.
*<math>StandardDeviation </math> is the standard deviation.
==Description==
==Description==
*This function gives the normalized value of any distribution.
*This function gives the normalized value of any distribution.
*Standardize is the normalized value for a distribution characterized by a given mean and standard deviation.
*Standardize is the normalized value for a distribution characterized by a given mean and standard deviation.
*In <math> STANDARDIZE(x,m,sd)</math>, <math>x </math> is the value to be normalized , <math> m </math> is the arithmetic mean of the distribution, and <math> sd </math> is the standard deviation of the distribution.
*In <math> STANDARDIZE (X,Mean,StandardDeviation)</math>, <math>X</math> is the value to be normalized , <math> Mean </math> is the arithmetic mean of the distribution, and <math> StandardDeviation </math> is the standard deviation of the distribution.
*The equation for the normalized value is:
*The equation for the normalized value is:
<math> Z= \frac{x-\mu}{\sigma}</math>, where <math> \mu </math> is the arithmetic mean and <math>\sigma </math> is the standard deviation.
<math> Z= \frac{x-\mu}{\sigma}</math>, where <math> \mu </math> is the arithmetic mean and <math>\sigma </math> is the standard deviation.