You’ve compiled information on eight beach goers and whether they got sunburnt at their last trip to the beach (below). Use Classification and Regression Trees to come up with a set of rules that will let you predict whether an individual gets sunburned. Note: since there are only eight records don't partition the tree, but set the min # records in each terminal branch to 2.

Please explain how you would do this in Excel.

 

Transcribed Image Text:

Name Hair Height Weight Lotion Sunburned Sarah blonde light 0 1 Dana blonde avg 1 0 Alex brown avg 1 Annie blonde avg 0 Emily red heavy 0 Pete brown heavy 0 John brown avg heavy 0 Katie blonde short light 1 avg tall short short avg tall 0 1 1 0 0 0 Name Hair Height Weight Lotion Sunburned Sarah blonde light 0 1 Dana blonde avg 1 0 Alex brown avg 1 Annie blonde avg 0 Emily red heavy 0 Pete brown heavy 0 John brown avg heavy 0 Katie blonde short light 1 avg tall short short avg tall 0 1 1 0 0 0

Answer rating: 100% (QA)

To perform Classification and Regression Trees CART in Excel you can use the Data Mining addin Here ... View the full answer