Answer to Question #306636 in Excel for Chetan mirje

Question

Design a worksheet in MS Excel to implement Decision Tree Classifier. The worksheet shall

include the following:

• It should allow users to create and store training data tuples. Let the attributes in the

tuples be nominal and output labels belong to one among ‘K’ classes.

• It should compute one of the following measures to decide an attribute to be used for

splitting the data tuples.

◦ Information gain

◦ Gain ratio

◦ Gini index

• It should split data tuples under consideration into multiple subsets based on the

selected attribute that maximizes the measure used and depending on number of

values the selected attribute would take.

• Repetition of the above steps of computing the measure to split further and continue

until a suitable stopping criteria is met.

Answer 1

It's been a while since this question is posted here. Still, the answer hasn't been got. Consider converting this question to a fully qualified assignment, and we will try to assist. Please click the link below to proceed: Submit order