{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Entropy",{"$f":" -9/14*LOG(9/14,2) - 5/14*LOG(5/14,2)","v":0.94028595867063092}]
[null,"Remainder","inf. Gain."]
["outlook",{"$f":"(5/14)*0.971   +(4/14)*0 + (5/14)*0.971","v":0.69357142857142862},{"$f":"$B$1-B3","v":0.2467145300992023},"best value, therefore this attribute is chosen."]
[]
["temp",{"$f":"(4/14)*(-2/4*LOG(2/4,2) - 2/4*LOG(2/4,2)) + (6/14)*(-4/6*LOG(4/6,2) -2/6*LOG(2/6,2)) + (4/14)*(-3/4*LOG(3/4,2)-1/4*LOG(1/4,2))","v":0.91106339301167627},{"$f":"$B$1-B5","v":2.9222565658954647E-2}]
[]
["humidity",{"$f":"(7/14)*(-4/7*LOG(4/7,2) - 3/7*LOG(3/7,2)) + (7/14)*(-6/7*LOG(6/7,2) -1/7*LOG(1/7,2))","v":0.78845045730828955},{"$f":"$B$1-B7","v":0.15183550136234136}]
[]
["wind",{"$f":"(8/14)*(-4/8*LOG(4/8,2) - 6/8*LOG(6/8,2)) + (6/14)*(-3/6*LOG(3/6,2) -3/6*LOG(3/6,2))","v":0.89215892826236165},{"$f":"$B$1-B9","v":4.8127030408269267E-2}]
[]
[]
["After setting \"outlook\" as root node in the decision tree,"]
["the entropy and information gains of the different values for outlook can be calculated"]
["Here the calculations in case of outlook=sunny"]
[]
["Entropy(outlook=sunny)",null,{"$f":"-(2/5)*LOG(2/5,2) - (3/5)*LOG(3/5,2)","v":0.97095059445466858}]
["Now the remainders and information gains for the remaining attributes are calculated"]
[]
[null,"Remainder","inf. Gain"]
["temp",{"$f":"(2/5)*(-(2/2)*LOG(2/2,2) - 0) + (2/5)*(-(1/2)*LOG(1/2,2) - (1/2)*LOG(1/2,2)) + (1/5)*(-1/1*LOG(1/1,2) -0)","v":0.4},{"$f":"$C$16-B20","v":0.57095059445466856}]
[]
["humidity",{"$f":"(3/5)*(0-0) + (2/5)*(0-0)","v":0},{"$f":"$C$16-B22","v":0.97095059445466858},"best value, therefore this attribute is chosen"]
[]
["wind",{"$f":"(2/5)*(-(1/2)*LOG(1/2,2) - (1/2)*LOG(1/2,2)) + (3/5)*(-(1/3)*LOG(1/3,2) - (2/3)*LOG(2/3,2))","v":0.95097750043269369},{"$f":"$C$16-B24","v":1.9973094021974891E-2}]
[]
["for outlook=overcast, there is no calculation necessary as all samples lead to the answer \"yes\""]
["for outlook=rain, the calculations are similar to the ones for outlook=sunny"]