How to normalize this sample

Sid · Joined: 29 Mar 2013 Posts: 1

Hello Everone,
I am very new to concepts of data mining. Can some please show step by step with caluclations how to normalize this data

Age Loan
25 49,000
56 156,000
65 99,000
32 192,000
41 39,000
49 57,000

Appreciate your help Gurus!
Sid[/img]

phil123 · Posted: Sat Mar 30, 2013 5:40 pm Post subject:

Hi,

To transform your values so that they are in the [0, 1] interval, you can do as follows.

Let's consider age first.

What is the maximum age? It is 65. So you can divide all the ages by 65 and all the age will be in the [0, 1] interval.

Now lets consider loan. What is the maximum loan ? 192,000. So you just divide all the loans by 192,000 and the result will be values in the interval [0, 1]

Best,

Phil