loading...

How to Use Excel STANDARDIZE Function in Office 365?

excelgeek profile image Andrews Originally published at geekexcel.com on ・3 min read

STANDARDIZE Function:

STANDARDIZE Function
STANDARDIZE Function

This article describes the usage of Excel STANDARDIZE Function in Office 365 with its syntax, explanation, and examples. Let’s step into this article!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

STANDARDIZE Function – Description:

  • This function returns the normalized value based on the mean and standard deviation.
  • You can find the standard deviation of a set of input values using the STDEV function.
  • To find the mean of the given input values, use the AVERAGE function.
  • The equation to find the normalized value is as follows.

Formula
Formula

Syntax:

=STANDARDIZE(x, mean, standard_dev)

Arguments Explanation:

x – The input value that you need to normalize.

Mean – It is the arithmetic mean of the distribution.

Standard_dev – It is the standard deviation of the distribution.

Note:

  • If the standard_dev is less than or equal to 0 and then this function returns the #NUM! Error.
  • If any of the arguments are non-numeric values such as letters and symbols and then this function returns #VALUE! Error.

Examples:

Let’s see some examples to understand this concept easily.

Example 1:

  • In the below screenshot, you can be able to see the input range in Column C , and its mean value is given in Cell F2 , the standard_dev value is given in Cell F3.

Example 1
Example 1

Example 2:

  • If the standard_dev is less than or equal to 0 and then this function returns the #NUM! Error.

Example 2
Example 2

Example 3:

  • If any of the arguments are non-numeric values such as letters and symbols and then this function returns #VALUE! Error.

Example 3
Example 3

From the above examples, you can clearly understand how to use the STANDARDIZE function.

End of the Article:

In this article, you can understand the usage of Excel STANDARDIZE Function in Office 365 with its syntax, explanation, and examples. Drop your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!!

See Also:

Posted on by:

excelgeek profile

Andrews

@excelgeek

Founder of Geek Excel!! Blog for Excel Tutorials

Discussion

pic
Editor guide