Maggie is analyzing data for best buy based on customers income and wall size and TV purchase (defined as ownership and nonownership) This is similar to question done in class but not exactly the same

TV data has following fields

HH# Income, wall size, TV ownership)

TV Ownership 2021

There are

11 ownership and

19 nonownership

Develop a two level split decision tree using

First level split at wall size = 18

Second level split follow following rule

If wall size > 18 AND income 25 THEN owner.

If wall size

1. Based on first and second level draw the decision tree

(2 points)

2. Calculate Gini index
3. Before the split

(2 points)

2. After the first split (wall size = 18)

(6 points)

3. After the second level splits (+2 bonus) on income 65.8

Excel data: https://www.dropbox.com/scl/fi/v572ye28y9py5v18qu3bp/TV-ownership_2021.xlsx?dl=0&rlkey=g2scvx478pc2ae3hv764tu4wk

P 00 E F G 1 HH# 2 1 3 4 3 5 st 09 6 7 00 8 8 9 10 o 11 12 13 14 15 D Income wallsize ownership of TV 1 75 18.5 ownership 2 60 16.8 ownership 3 85.5 21.6 ownership 4 64.5 22 ownership 5 87 23 ownership 6 59 19.4 ownership 7 87 17.6 ownership 90 22.4 ownership 9 95 20 ownership 10 110.1 15 ownership 11 45 16 ownership 12 102 18 nonownership 13 49.2 19.5 nonownership 14 59 11 nonownership 15 87 20.4 nonownership 16 66 15.2 nonownership 17 66 16.9 nonownership 18 47.4 18.4 nonownership 19 33 16.4 nonownership 20 51 15 nonownership 21 63 12 nonownership 22 65 22 nonownership 23 53 20 nonownership 24 45 16 nonownership 25 55 18.1 nonownership 26 110 15 nonownership 27 59 22 nonownership 28 69 14.8 nonownership 29 55 13.2 nonownership 30 50 12.8 nonownership 16 17 18 19 20 21 22 23 F9 S9 24 25 $ 26 27 28 29 30 31 32 33 P 00 E F G 1 HH# 2 1 3 4 3 5 st 09 6 7 00 8 8 9 10 o 11 12 13 14 15 D Income wallsize ownership of TV 1 75 18.5 ownership 2 60 16.8 ownership 3 85.5 21.6 ownership 4 64.5 22 ownership 5 87 23 ownership 6 59 19.4 ownership 7 87 17.6 ownership 90 22.4 ownership 9 95 20 ownership 10 110.1 15 ownership 11 45 16 ownership 12 102 18 nonownership 13 49.2 19.5 nonownership 14 59 11 nonownership 15 87 20.4 nonownership 16 66 15.2 nonownership 17 66 16.9 nonownership 18 47.4 18.4 nonownership 19 33 16.4 nonownership 20 51 15 nonownership 21 63 12 nonownership 22 65 22 nonownership 23 53 20 nonownership 24 45 16 nonownership 25 55 18.1 nonownership 26 110 15 nonownership 27 59 22 nonownership 28 69 14.8 nonownership 29 55 13.2 nonownership 30 50 12.8 nonownership 16 17 18 19 20 21 22 23 F9 S9 24 25 $ 26 27 28 29 30 31 32 33