KNOWLEDGE BASE

How To Make Normalization of a Group of Data In a Certain Range


Published: 02 Mar 2021
Last Modified Date: 03 Mar 2021

Question

How to make normalization and set the range to -1 ~1 or 0 ~1 for a better comparison.

Sample Data:
{-30.5, -28, -4.5, -3.8, -0.78, 7, 1.5, 50.7}

Environment

  • Tableau Prep Builder
  • Tableau Desktop

Answer

1. Mean-Normalization: To normalize a group of data to [-1 ~1]:

(Data - AVG) / (MAX - MIN)

2. Rescaling (min-max normalization): To normalize a group of data to [0 ~1]:

(Data - MIN) / (MAX - MIN)
Did this article resolve the issue?