Statistics & probability
Min–max normalisation
Rescale a numeric dataset into a chosen output interval.
A clear answer. Here’s how.
Transforms x to lower+(x−minimum)/(maximum−minimum)×(upper−lower). Requires lower<upper and non-constant input data. Fits the minimum and maximum to this supplied dataset only; future values outside its range can lie outside the chosen interval. Retains original row positions.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- Values, separated by commas or new lines
- 2, 4, 4, 4, 5, 5, 7, 9
- Output lower bound
- 0
- Output upper bound
- 1
Example result
| Input position | Original value | Normalised value |
|---|---|---|
| 1 | 2 | 0 |
| 2 | 4 | 0.285714285714 |
| 3 | 4 | 0.285714285714 |
| 4 | 4 | 0.285714285714 |
| 5 | 5 | 0.428571428571 |