Question: Continuing the previous problem, the file P17_16. xlsx contains the same wine data. Using a Microsoft Data Mining add-in (not discussed here), a decision tree

Continuing the previous problem, the file P17_16. xlsx contains the same wine data. Using a Microsoft Data Mining add-in (not discussed here), a decision tree classification was performed (with 0% of the cases held out for testing). You can see the resulting tree in the Tree sheet. Write out the corresponding decision rules implied by this tree. Then use a nested IF formula to make the classifications in column O of the Data sheet, and find the percentage of incorrect classifications. Would you say the decision tree is very accurate?

Step by Step Solution

★★★★★

3.45 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Type Alcohol MalicAcid Ash AshAlcalinity Magnesium TotalPhenols Flavanoids NonflavanoidPhenols Proanthocyanins ColorIntensity Hue OD280OD315 Proline Classification Correct Percent bad 140 A 1423 171 2... 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

Document Format (3 attachments)

1209_60bca5b3c26ef_564915.pdf

180 KBs PDF File

1209-M-S-D-A(8944).xlsx

300 KBs Excel File

1209_60bca5b3c26ef_564915.docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

Continuing the previous problem, how do your responses to the questions change if you employ Winters method to handle seasonality in this time series? Explain. Which forecasting method do you prefer,...

Continuing the previous problem, make the problem even more general by allowing upper bounds (arc capacities) and lower bounds for the flows on the allowable arcs. Some of the upper bounds can be...

Continuing the previous problem, assume, as in Problem 11, that the damage amount is normally distributed with mean $3000 and standard deviation $750. Run @RISK with 5000 iterations to simulate the...

The file P14_12.xlsx contains data on 178 wines. They are categorized into three types, labeled A, B, and C. The rest of the variables are numeric properties of the wines. Using a Microsoft Data...

The file P1712xlsx contains data on 178 wines They are categorized into three types, labeled A, B, and C The rest of the variables are numeric properties of the wines Using a Microsoft Data Mining...

Sentiment Analysis for Customer Review: Case Study of GO-JEK Expansion Abstract Background: Market prediction is an important thing that needs to be analyzed deeply. Business intelligence becomes an...

Continuing problem 15, the file P17_20.xlsx contains the same wine data. Instead of trying to use a classification algorithm to classify wines into the three known types (A, B, and C), it is...

Follow the steps given in Machine Learning With R , Chapter 5, section "Example Identifying Risky Bank Loans Using C5.0 Decision Trees." download the credit. csv file from Packt Publishing's website...

Jones & Bartlett Learning, LLC. NOT FOR RESALE OR DISTRIBUTION CHAPTER Hot Spot Analysis 10 LEARNING OBJECTIVES C A R R Provide a working definition of a \"hot spot.\" , Be able to explain different...

1. In 2013, several data server companies took a dramatic decision to begin using energy surcharges to recapture rising energy costs. However, customers are critical of how the energy surcharges are...

F3-11. The material for the 50-mm-long specimen has the stress-strain diagram shown. If P = 150 kN is applied and then released, determine the permanent elongation of the specimen. (MPa) 500 450...

Consider an atomic nucleus to be equivalent to a one-dimensional infinite potential well with L = 1.4 x 1014, a typical nuclear diameter. What would be the ground-state energy of an electron if it...

The risk - free rate is 4 % . The expected market rate of return is 1 1 % . If you expect CAT with a beta of 1 . 0 to offer a rate of return of 1 0 % , you should:

1.*4. Let Sn and N(t) be as m Theorem 5.5.2. Show that 00 e?{N(t)} = Lq>{Sn ~ t}. n=l 'IliiS remams true If X 1 takes both pOSItIve and negatIve values.

The P04_19.xlsx file contains a Data Model with four related tables about a companys sales and a single blank worksheet. This problem illustrates a potential problem with pivot tables when there is a...

Before Power Pivot, you could create calculated fields for pivot tables. This problem explores calculated fields versus Power Pivots measures for ratios. The P04_21.xlsx file contains a list of...

The P04_18.xlsx file contains a single-table Data Model on a companys sales and a single blank worksheet. The goal is to create a pivot table that shows the ratio of average revenue per transaction...

The U.S. dollar suddenly changes in value against the euro moving from an exchange rate of $0.8909/euro to $0.08709/. Thus, the dollar has by appreciated; 2.30% depreciated; 2.30% appreciated; 2.24%...

Option B has a lower future value at Year 5. Both options are of equal value. Question 14 5 pts Assume two annuities will each provide $500 annual cash flows for five years. One is an ordinary...

The price of Cilantro, Incorporated, stock will be either $65 or $87 at the end of the year. Call options are available with one year to expiration. T-bills currently yield 3 percent. a. Suppose the...