STANDARDIZE function in Excel


The following article Taimienphi.vn introduces you to STANDARDIZE function in Excel, this is one of the functions in the statistical function group that many people use when working with Excel.


STANDARDIZE Excel is a calculation function that helps you produce normalized results from a distribution characterized by the Mean and Standard_Dev arguments.

STANDARDIZE function in Excel

How to use STANDARDIZE function in Excel

1. Description and syntax used

This is the function that returns the normalized value from a distribution characterized by the 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: Standard deviation of the distribution, is a required parameter.

Attention:

– If Standard_Dev ≤ 0 -> the function returns an error value #NUM!

– The equation for the normalized value is:

ham standardize in excel 2

2. Examples of specific situations

Suppose you need to calculate the normalized values ​​of values ​​in the following data table:

ham standardize in excel 3

Step 1: Calculate the normalized value of 49. In the cell to calculate, enter the formula: = STANDARDIZE (C3, C5, C6)

ham standardize in excel 4

Step 2: Press Enter -> normalized value of 49 was:

ham standardize in excel 5

Step 3: Calculate the normalized value of -49. In the cell to calculate, enter the formula: = STANDARDIZE (C4, C5, C6)

ham standardize in excel 6

You press Enter -> Normalized value of -49 was:

ham standardize in excel 7

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

ham standardize in excel 8

Above are instructions and some specific examples when you use STANDARDIZE function in Excel. With this function, you remember the syntax is STANDARDIZE (X, Mean, Standard_Dev), Inside X is the value to be standardized, Mean is the arithmetic mean of the distribution, also Standard_Dev is the standard deviation of the distribution. Good luck!

https://thuthuat.taimienphi.vn/ham-standardize-rong-excel-43728n.aspx
The IF function is a commonly used conditional function with its versatility, and the way the IF function is used makes it easy to use the Excel function. See more about How to use the IF function through tips on Taimienphi.vn friends.

.

Add a Comment

Your email address will not be published. Required fields are marked *