Question: 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

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.

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

Please explain how you would do this in Excel.

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

Step by Step Solution

★★★★★

3.49 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

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

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Raw cotton having an initial total moisture content of 95% (dry basis) and a dry density 43.7 lb/ft 3 is to be dried batchwise to a final moisture content of 10% (dry basis) in a cross-circulation...

A pharmaceutical manufacturer has come up with a new drug intended to provide greater headache relief than the old formula. Of 250 patients treated with the previous medication, 130 reported fast...

A company has come up with a new selection test and decides to try it out on some of its current workers before giving it to job applicants. A group of its current workers volunteered to take the...

The Cambridge Opera Association has come up with a unique door prize for its December (2013) fund-raising ball: Twenty door prizes will be distributed, each one a ticket entitling the bearer to...

Are some unskilled office jobs viewed as having more status than others? Suppose a study is conducted in which eight unskilled, unemployed people are interviewed. The people are asked to rate each of...

Are some office jobs viewed as having more status than others? Suppose a study is conducted in which eight unemployed people are interviewed. The people are asked to rate each of five positions on a...

Write a memo to your partner discussing his or her sales calls and how they could be improved. When analyzing your partners efforts, use the eight steps of a sales call in the text as your guide.

The Wall Street Journal contains an article by Michael Rapoport entitled "Has Kraft Heinz Made $\$ 24$ Billion Since Merger or $\$ 6$ Billion? It Depends." Instructions Read the article and then...

In one group, find a local business, such as a copy shop, that rents time on desktop computers for an hourly rate. Determine the hourly rate. In the other group, determine the price of a mid-range...

Would Lyles claim of racial discrimination be for intentional (disparate-treatment) or unintentional (disparate-impact) discrimination? Explain. Amaani Lyle, an African American woman, was hired by...

Determine the magnitude and direction θ of F so that the particle is in equilibrium. Units Used: kN = 103 N Given: F1 = 7kN F2 = 3kN c = 4 d = 3 2

Supposed an incident x-rays are diffracted from a (10 0) plane of a cubic crystal, What is the interplanar (d) spacing of such a plane? 1. Cubic d-spacing: =(h? + k? +1?) %3D Select one: O b. 2a Act...

Prior to health care reform, young people would pay approximately of the premium it would cost an elderly person. 1 / 6 1 / 2 2 / 3 4 / 5

In Figure V =10 V C1 =10F, and C2= C3= 20F. Switch S is first thrown to the left side until capacitor 1 reaches equilibrium. Then the switch is thrown to the right. When equilibrium is again reached,...

In Figure a potential difference V = 100 V is applied across a capacitor arrangement with capacitances C1 = 10.0F, C2 = 5.00F, and C3 = 15.0F. What are? (a) Charge q3, (b) Potential difference V3,...

The charges and coordinates of two point charges 1ocated in an xy plane are q1 = +3.00 x 10-6C, x + 3.50 cm, y = + 0.500 cm and q2 = - 4.00 x 10-6 C, x = -2.00 cm, y = + 1.50 cm. How much work must...

Zero Coupon Bonds suppose your company needs to raise $20 million and you want to issue 30-year bonds for this purpose. Assume the required return on your bond issue will be 7 percent, and youre...

Is the vacation daemon part of the user agent or the message transfer agent? Of course, it is set up using the user agent, but does the user agent actually send the replies? Explain your answer.

you have been tasked with designing an extended detention dry bond. the bond is at the exit of a 3.6hectare watershed. assuming that rainfall is evenly distributed over the watershed, what would be...

WoolCo buys sheeps wool from farmers. The company began operations in January of this year, and is making decisions on product offerings, pricing, and vendors. The company is also examining its...

In this assignment, I need to determine 2 benchmarks in figuring out whether I should outsource three products. I need help in figuring out the net present value. To find this, I have to come up with...

1) Brainstorming and freewriting are an important part of the writing process because they A) give you well-supported evidence for your main point. B) help you develop ideas you have about a topic....

ction managers and HR employees at Ford Seasoning has compiled information about standards direct labor requirements during January 20x and passed it along to the accounting staff. The for the amount...

As we continue our discussions regarding revenue's associated with public sector, this will help reinforce some of the ideas regarding taxes on goods and services. Through the next week, save your...

Mastery Problem: Activity-Based Costing WooICOrp Woo|Corp buys sheep's wool from farmers. The company began operations in January of this year, and is making decisions on product offerings, pricing,...