*17*

To normalize the values in a dataset to be between 0 and 1, you can use the following formula:

**z _{i} = (x_{i} â€“ min(x)) / (max(x) â€“ min(x))**

where:

**z**The i_{i}:^{th}normalized value in the dataset**x**The i_{i}:Â^{th}value in the dataset**min(x)**: The minimum value in the dataset**max(x):**The maximum value in the dataset

For example, suppose we have the following dataset:

The minimum value in the dataset is 13 and the maximum value is 71.

To normalize the first value ofÂ **13**, we would apply the formula shared earlier:

**z**Â = (13 â€“ 13) / (71 â€“ 13) =_{i}Â = (x_{i}â€“ min(x)) / (max(x) â€“ min(x))**0**

To normalize the second value ofÂ **16**, we would use the same formula:

**z**= (16 â€“ 13) / (71 â€“ 13) =_{i}Â = (x_{i}â€“ min(x)) / (max(x) â€“ min(x))**.0517**

To normalize the third value ofÂ **19**, we would use the same formula:

**z**= (19 â€“ 13) / (71 â€“ 13) =_{i}Â = (x_{i}â€“ min(x)) / (max(x) â€“ min(x))**.1034**

We can use this exact same formula to normalize each value in the original dataset to be between 0 and 1:

Using this normalization method, the following statements will always be true:

- The normalized value for the minimum value in the dataset will always be 0.
- The normalized value for the maximum value in the dataset will always be 1.
- The normalized values for all other values in the dataset will be between 0 and 1.

**When to Normalize Data**

Often we normalize variables when performing some type of analysis in which we have multiple variables that are measured on different scales and we want each of the variables to have the same range.

This prevents one variable from being overly influential, especially if itâ€™s measured in different units (i.e. if one variable is measured in inches and another is measured in yards).

Itâ€™s also worth noting that we used a method known asÂ **min-max normalizationÂ **in this tutorial to normalize the data values.

The two most common normalization methods are as follows:

**1.Â Min-Max Normalization**

**Objective:**Converts each data value to a value between 0 and 100.**Formula:Â**New value = (value â€“ min) / (max â€“ min) * 100

**2. Mean Normalization**

**Objective:**Scales values such that the mean of all values is 0 and std. dev. is 1.Â**Formula:Â**New value = (value â€“ mean) / (standard deviation)

**Additional Resources**

The following tutorials explain how to normalize data using different statistical softwares:

How to Normalize Data in Excel

How to Normalize Data in R

How to Normalize Columns in Python