1. (12 Points) Refer to Table 2.2 below (The Credit Card Promotion Database). Transform the data for the attribute age so the new minimum value is 0 and the new maximum value is 1. This transformation is particularly useful with neural networks where the desired range is [0,1]. This is an example of a Min-Max normalization.

1. (4 Points) The current minimum value is _____ and the current maximum is _____. The formula to perform the transformation is

newValue = (originalValue - _____) / _____

2. (8 Points) Complete the following table:

originalValue for Age	newValue for Age
45	0.722
40
42	0.639
43
38	0.528
55
35	0.444
27
43	0.667
41
43	0.667
29
39	0.556
55
19

TABLE 2.2: The Credit Card Promotion Database ID Income Range ($) 40 - 50K 30 - 40K Life Magazine Watch Insurance Credit Card Promotion Promotion Promotion Insurance Yes No No No Age 1 45 Gender Male Female Male 2 Yes Yes Yes No 40 3 40 - 50K No No No No 42 4 30-40K Yes Yes Yes Yes Male 43 5 50 - 60K Yes No Yes No Female 38 6 20 - 30K No No No No Female 55 7 30 - 40K Yes No Yes Yes Male 35 8 20 - 30K No Yes No No Male 27 9 30 - 40K Yes No No No Male 43 10 30-40K Yes Yes Yes No Female 41 11 40 - 50K No Yes Yes No Female 43 12 20-30K No Yes Yes No Male 29 13 50 - 60K Yes Yes Yes No Female 39 14 40-50K No Yes No No Male 55 15 20-30K No No Yes Yes Female 19 TABLE 2.2: The Credit Card Promotion Database ID Income Range ($) 40 - 50K 30 - 40K Life Magazine Watch Insurance Credit Card Promotion Promotion Promotion Insurance Yes No No No Age 1 45 Gender Male Female Male 2 Yes Yes Yes No 40 3 40 - 50K No No No No 42 4 30-40K Yes Yes Yes Yes Male 43 5 50 - 60K Yes No Yes No Female 38 6 20 - 30K No No No No Female 55 7 30 - 40K Yes No Yes Yes Male 35 8 20 - 30K No Yes No No Male 27 9 30 - 40K Yes No No No Male 43 10 30-40K Yes Yes Yes No Female 41 11 40 - 50K No Yes Yes No Female 43 12 20-30K No Yes Yes No Male 29 13 50 - 60K Yes Yes Yes No Female 39 14 40-50K No Yes No No Male 55 15 20-30K No No Yes Yes Female 19