$1.($Han page $387$ problem $8\mathrm{.}7)$ The follwing table consists of training data from an employee database. For a given raw entry, count represents the number of data tuples having the values for department, status, age and salary given in that row.

$$ Predicted variable is status Age,Salary and Department are inputs

$\backslash$table$[[$Department$,$Status,Age,Salary,Count$],[$Sales$,$Senior,$31-35,46K-50K,30],[$Sales$,$Junior,$26-30,26K-30K,40],[$Sales$,$Junior,$31-35,31K-35K,40],[$Systems$,$Junior,$21-25,46K-50K,20],[$Systems$,$Senior,$31-35,66K-70K,5],[$Systems$,$Junior,$26-30,46K-50K,3],[$Systems$,$Senior,$41-45,66K-70K,3],[$Marketing$,$Senior,$36-40,46K-50K,10],[$Marketing$,$Junior,$31-35,41K-45K,4],[$Secretary$,$Senior,$46-50,36K-40K,4],[$Secretary$,$Junior,$26-30,26K-30K,6]]$

a$)$ Modify the ID$3$ to handle count of each data tuble and solve the prblem with the modified ID$3$

algorithm.Do not use any package program but you can perform calcualtions in Excel.

b$)$ Solve the same problem with the decisiton tree algorithms we covered in lab and compare the solutions with your hand calculated ID$3$