Youve 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. Thank you!!

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