Loading

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

Publish Date: Apr 21, 2025
Task

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}

Steps
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)
Knowledge Article Number

001456937

Attachments

Normalization_v2019.4.twbx

22 KB

 
Loading
Salesforce Help | Article