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

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 interesting to see if a clustering algorithm can discover these known categories. The file contains the results of two runs of a Microsoft Data Mining Detect Categories algorithm (not discussed here). Of course, neither uses the Type variable in column A. The first run didn't specify the number of categories, and the add-in found 7, with category membership in column O of the Data sheet. The second run specified the number of categories as 3, with category membership in column P of the Data sheet. Analyze the results closely. Do either (or both) of the runs seem to discover the known A, B, and C types?

Step by Step Solution

★★★★★

3.62 Rating (174 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 Category Category1 A 1423 171 243 156 127 28 306 02... 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_60bca5b4e1c2a_564919.pdf

180 KBs PDF File

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

300 KBs Excel File

1209_60bca5b4e1c2a_564919.docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

Continuing Problem 2 with the data in the file P10_04.xlsx, employ stepwise regression to evaluate your conclusions regarding the specification of a regression model to predict the sales of deep-dish...

Continuing Problem 6 with the data in the file P10_18.xlsx, refer to the original multiple regression model as the reduced equation. Suppose now that the antique collector believes that the rate of...

The file P02_16.xlsx contains the number of arrivals at a turnpike tollbooth for each of four 5-minute intervals for each of 256 days. For this problem, assume that each column, such as arrivals from...

Jupiter Notebook We have covered some of the limitations of single layer neural networks in class, but they are still powerful learning systems that provide a good way to begin learning about how to...

I need a 10 page paper for my MIS class. Please do not copy and paste as my school is getting stricter on plagiarism. I have attached the assignment and the sample \fData Analytic Thinking 1 Data...

QUIZ... Let D be a poset and let f : D D be a monotone function. (i) Give the definition of the least pre-fixed point, fix (f), of f. Show that fix (f) is a fixed point of f. [5 marks] (ii) Show that...

The new line character is utilized solely as the last person in each message. On association with the server, a client can possibly (I) question the situation with a client by sending the client's...

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

MATHEMATICS FOR MACHINE LEARNING Marc Peter Deisenroth A. Aldo Faisal Cheng Soon Ong Contents Foreword 1 Part I Mathematical Foundations 9 1 Introduction and Motivation 11 1.1 Finding Words for...

1411116 - Programming I Assignment #3 Due Date: November 30, 2016 Submission Instructions: Submit your assignment on the blackboard link, corresponding to your Section: Please follow the following...

What is the speed of a conduction electron whose energy is equal to the Fermi energy E F for, (a) Na, (b) Au, and (c) Sn?

Unlevered beta equals the company's a . beta if it had no debt. b . levered beta. c . beta that includes its financial risk. d . beta that is used in the capital asset pricing model.

1.13. Under the assumptions in Theorem 5.4.2, if Sn/n converges a.e. then / (IXII) 11 i a } 0; use Theorem 4.2.4 to get Ln :-1'{ IX 11 > n}

The P04_10.mdb file is an Access database file created by a classical music CD collector (when CDs were in). Keep in mind that a classical CD can have multiple works by multiple composers, played or...

Visit the website https://finance.yahoo.com/quote/ YHOO/history?p=YHOO (or search the Web for Yahoo historical stock prices if this link no longer works) to find historical stock prices for any...

The P04_07.txt file is a text file listing the number of mobile subscriptions in four years for several countries. (You can view the data in NotePad if you like.) Use Power Query to import the data...

Consider a firm with an EBITDA of $ 1 , 1 0 0 , 0 0 0 and an EBIT of $ 1 , 0 0 0 , 0 0 0 . The firm finances its assets with $ 4 , 7 2 0 , 0 0 0 debt ( costing 7 . 7 percent, all of which is tax...

Suppose you are holding a long position in a French franc futures contract that matures in 76 days. The agreed-upon price is $0.15 for FF 250, 000. At the close of trading today, the futures price...

A stock has had the following year-end prices and dividends Year Price Dividend 1$43.37 3 5 48.35 $.60 57.27 45.35 52.27 61.35 63 80 85 93 What are the arithmetic and geometric returns for the stock?...