Exam 10: Data Mining

Exhibit 10.2 The following questions are based on the problem description and the output below. A college admissions officer wants to evaluate graduate school applicants based on their GMAT scores, verbal and quantitative. Students are classified as either successful (Group 1), marginally successful (Group 2) or not-successful (Group 3) in their graduate studies. The officer has data on 20 current students, 7 successful (Group 1), 6 marginally successful (Group 2) and 7 not successful (Group 3). ​ ​ ​ ​ -Refer to Exhibit 10.2. What is the quantitative test score value of the group centroid for group 2?

Exhibit 10.2 The following questions are based on the problem description and the output below. A college admissions officer wants to evaluate graduate school applicants based on their GMAT scores, verbal and quantitative. Students are classified as either successful (Group 1), marginally successful (Group 2) or not-successful (Group 3) in their graduate studies. The officer has data on 20 current students, 7 successful (Group 1), 6 marginally successful (Group 2) and 7 not successful (Group 3). ​ ​ ​ ​ -Refer to Exhibit 10.2. What number of observations is classified incorrectly?

Data mining tasks fall into three potential categories: Classification, Prediction and Association/Segmentation.

​The Get Data command is part of the XLMiner Platform in Excel add-on.

Exhibit 10.7 The information below is used for the following questions. An investor wants to classify companies as being a High Risk Investment, Group 1, a Medium Risk Investment, Group 2, or a Low Risk Investment, Group 3. He has gathered Liquidity, Profitability data on 18 companies he has invested in and produced the following spreadsheet. The following Discriminant Analysis output using Analytic Solver Platform has also been generated. -Refer to Exhibit 10.7. What formulas should go in cells C22:D24 of the spreadsheet?

A graphical representation of clustering outcomes showing which items should be classified to which clusters is called a(n)

Prediction step in data mining is an option available in

Useful data mining techniques can be found in Excel under ___________ drop menu

Affinity analysis is a data mining technique used in marketing research to determine

The concept behind neural networks is to

Exhibit 10.1 The following questions are based on the problem description and the output below. A college admissions officer wants to evaluate graduate school applicants based on their GMAT scores, verbal and quantitative. Students are classified as either successful or not-successful in their graduate studies. The officer has data on 20 current students, ten of whom are doing very well (Group 1) and ten who are not (Group 2). ​ ​ ​ ​ -Refer to Exhibit 10.1. The straight line distance between two points (X₁, Y₁) and (X₂, Y₂) is calculated as

Suppose that two variables are found to be significantly correlated. A researcher may

In the ________ step of data mining, a researcher attempts to estimate to which discrete group an observation belongs to

An Excel add-in tool used for data mining is called

Exhibit 10.2 The following questions are based on the problem description and the output below. A college admissions officer wants to evaluate graduate school applicants based on their GMAT scores, verbal and quantitative. Students are classified as either successful (Group 1), marginally successful (Group 2) or not-successful (Group 3) in their graduate studies. The officer has data on 20 current students, 7 successful (Group 1), 6 marginally successful (Group 2) and 7 not successful (Group 3). ​ ​ ​ ​ -Refer to Exhibit 10.2. What percentage of observations is classified correctly?

____________ is a classification technique that estimates the probability of an observation belonging to a particular group

Logistic regression is a classification technique that

Exhibit 10.1 The following questions are based on the problem description and the output below. A college admissions officer wants to evaluate graduate school applicants based on their GMAT scores, verbal and quantitative. Students are classified as either successful or not-successful in their graduate studies. The officer has data on 20 current students, ten of whom are doing very well (Group 1) and ten who are not (Group 2). ​ ​ ​ ​ -Refer to Exhibit 10.1. Suppose that for a given observation, the difference between Mahalanobis distances between group 1 and 2 (G1-G2) is small. This means that

In the ________ step of data mining, a researcher attempts to form logical groupings of data in the set

The goal of discriminant analysis is