Exam 10: Data Mining

Exhibit 10.1 The following questions are based on the problem description,regression results,and the Analytic Solver Platform Discriminant Analysis report 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). Unpooled Estimates of within-group Covariance matrices are used,assuming they are different. Group Centroids Group Quantitative Verbal 1 683.8 654.2 2 610.7 605.7 $\text { Classitication Matrix }$ Actual / Predicted Group1 Group2 Total \% correct Group1 9 1 1 90.00\% 0 Group2 2 8 1 80.00\% 0 Total 1 9 2 85.00\% 1 0 -Refer to Exhibit 10.1.What percentage of the observations is classified correctly?

Plots useful in data mining analysis can be accessed in Excel using the add-in

Affinity analysis is a data mining technique that attempts to discover

Exhibit 10.1 The following questions are based on the problem description,regression results,and the Analytic Solver Platform Discriminant Analysis report 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). Unpooled Estimates of within-group Covariance matrices are used,assuming they are different. Group Centroids Group Quantitative Verbal 1 683.8 654.2 2 610.7 605.7 $\text { Classitication Matrix }$ Actual / Predicted Group1 Group2 Total \% correct Group1 9 1 1 90.00\% 0 Group2 2 8 1 80.00\% 0 Total 1 9 2 85.00\% 1 0 -Refer to Exhibit 10.1.Suppose that for a given observation,the difference between Mahalanobis distances between group 1 and 2 G1-G2)is big and positive.This means that

Logistic regression in XLMiner add-in can be used for groups

In the k nearest neighbor technique,a large value of k produces classifications that

When purity is perfect,the Gini index is equal to

The Fisher linear discriminant function

Suppose that the correlation coefficient between X₁ and X₂ is equal to -1.This means that

A test sample is often used to perform of how well the model will work with new data

Suppose that an analyst classified a new record using the following sequential steps i)find identical records in the training sample,ii)determine a group,to which majority of these records belong,iii)assign the new record to the group in step ii).This technique is called

Mahalanobis distance is a measure of

In hierarchical clustering,the measure of similarity between clusters is/are

In the k nearest neighbor technique,a small value of k produces classifications that are

Neural networks technique attempts to learn

Exhibit 10.2 The following questions are based on the problem description,spreadsheet,and the Analytic Solver Platform Discriminant Analysis report 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). Discriminant Analysis Report October 1,2013 4:22:38 PM Unpooled Estimates of within-group Covariance matrices are used,assuming they are different. Group Centroids Group Quantitative Verbal 1 697.7142857 650.4285714 2 647.8571429 630.7142857 3 5876666667 6051666667 $\text {Group}$ $\text {Frenuencies}$ Group Relative Frequency 1 35.00\% 2 35.00\% 3 30.00\% Training Sample Classification Mahalanobis Distances $\text {Classification}$ $\text {Matrix}$ Actual / Predicted Group1 Group2 Group3 Total \% correct Group1 6 1 0 7 85.71\% Group2 0 7 0 7 100.00\% Group3 0 0 6 6 100.00\% Total 6 8 6 2 95.00\% -Refer to Exhibit 10.2.What is the quantitative test score value of the group centroid for group 2?

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

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

Cluster analysis is a data mining technique used for

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