Question 1

If using the regression tool for two-group discriminant analysis, in the regression dialog box, the Input Y-Range entry corresponds to

Accepted Answer

A) the Group values. 
B) the independent variable values. 
C) the predictor variable values. 
D) (b) and (c) are both correct 
A) the Group values. 
B) the independent variable values. 
C) the predictor variable values. 
D) (b) and (c) are both correct

Question 2

The following questions are based on the problem description, regression results, and the RiskSolver Platform (RSP) 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).
          
-Refer to Exhibit 10.1. What formula is entered in cell E4 and copied to cells E5:E25 of the spreadsheet?

Accepted Answer

A) = 7.452402 + 0.00694*C4 + 0.00232*D4 
B) = 7.452402 - 0.00694*C4 -0.00232*D4 
C) = 1.157926 + 0.001545*C4 + 0.01297*D4 
D) = 7.452402 - 0.00694*D4 - 0.00232*C4 
A) = 7.452402 + 0.00694*C4 + 0.00232*D4 
B) = 7.452402 - 0.00694*C4 -0.00232*D4 
C) = 1.157926 + 0.001545*C4 + 0.01297*D4 
D) = 7.452402 - 0.00694*D4 - 0.00232*C4

Question 3

The following questions are based on the problem description, regression results, and the RiskSolver Platform (RSP) 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).
          
-Refer to Exhibit 10.1. What percentage of the observations is classified incorrectly?

Accepted Answer

A) 90% 
B) 80% 
C) 85% 
D) 15% 
A) 90% 
B) 80% 
C) 85% 
D) 15%

Question 4

A manager wants to classify people as belonging to one of two groups based on two scores. The manager has collected data on four current employees and has performed a regression analysis on the data. The data for the problem and the relevant output are shown below.
              
-Refer to Exhibit 10.4. What formulas should go in cells C8:D9 and E4:G10 of the spreadsheet?

Accepted Answer

The answer of  
A manager wants to classify people...

Question 5

An investor wants to classify companies as being either a good investment, Group 1, or a poor investment, Group 2. He has gathered Liquidity, Profitability and Activity data on 18 companies he has invested in and run a regression analysis. Discriminant Analysis output using Risk Solver Platform (RSP) has also been generated. The data for the problem and the relevant output are shown below.
              
-Refer to Exhibit 10.6. Based on the 20 observations and the RSP output, what percentage of the observations are correctly classified?

Accepted Answer

A) 80.00% 
B) 88.89% 
C) 75.25% 
D) 95.14% 
A) 80.00% 
B) 88.89% 
C) 75.25% 
D) 95.14%

Question 6

A manager wants to classify people as belonging to one of two groups based on two scores. The manager has collected data on four current employees and has performed a regression analysis on the data. The data for the problem and the relevant output are shown below.
              
-Refer to Exhibit 10.4. Compute the discriminant score and predicted group for someone with Score 1 of 242 and Score 2 of 142.

Accepted Answer

DISCRIMINA

Question 7

The following questions are based on the problem description, regression results, and the RiskSolver Platform (RSP) 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).
          
-Refer to Exhibit 10.1. What is the straight line distance between (6,4) and (2,9)?

Accepted Answer

A) 3.20 
B) 6.40 
C) 9 
D) 41 
A) 3.20 
B) 6.40 
C) 9 
D) 41

Question 8

The following questions are based on the problem description, regression results, and the RiskSolver Platform (RSP) 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).
          
-Refer to Exhibit 10.1. Based on the regression output, what is the discriminant score for a student with a quantitative score of 635 and a verbal score of 570?

Accepted Answer

A) 1.72 $\le$ discriminant score $\le$ 1.73 
B) 2.02 $\le$ discriminant score $\le$ 2.03 
C) 3.04 $\le$discriminant score $\le$ 3.05 
D) 6.12 $\le$ discriminant score $\le$ 6.14 
A) 1.72 $\le$ discriminant score $\le$ 1.73 
B) 2.02 $\le$ discriminant score $\le$ 2.03 
C) 3.04 $\le$discriminant score $\le$ 3.05 
D) 6.12 $\le$ discriminant score $\le$ 6.14

Question 9

Which of the following goodness-of-fit measures is used for discriminant analysis problems?

Accepted Answer

A) R2 
B) multiple R2 
C) adjusted R2 
D) none of these 
A) R2 
B) multiple R2 
C) adjusted R2 
D) none of these

Question 10

The following questions are based on the problem description, regression results, and the RiskSolver Platform (RSP) 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).
          
-Refer to Exhibit 10.1. What is the verbal test score value of the group centroid for group 2?

Accepted Answer

A) 683.8 
B) 654.2 
C) 610.7 
D) 605.7 
A) 683.8 
B) 654.2 
C) 610.7 
D) 605.7

Question 11

The following questions are based on the problem description, regression results, and the RiskSolver Platform (RSP) 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).
          
-Refer to Exhibit 10.1. The university has received applications from several new students and would like to predict which group they would fall into. What is the discriminant score for a student with a Quantitative score of 686 and a Verbal score of 601. Use five (5) significant figures in your coefficients.

Accepted Answer

A) 1.29 $\le$ discriminant score $\le$1.30 
B) 1.69 $\le$ discriminant score $\le$ 1.70 
C) 2.69 $\le$ discriminant score $\le$2.70 
D) 6.05$\le$discriminant score $\le$ 6.06 
A) 1.29 $\le$ discriminant score $\le$1.30 
B) 1.69 $\le$ discriminant score $\le$ 1.70 
C) 2.69 $\le$ discriminant score $\le$2.70 
D) 6.05$\le$discriminant score $\le$ 6.06

Question 12

The following questions are based on the problem description, spreadsheet, and the Risk Solver Platform (RSP) 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).
          
-Refer to Exhibit 10.2. Based on the RSP output, what percentage of observations is classified incorrectly?

Accepted Answer

A) 5% 
B) 15% 
C) 95% 
D) 90% 
A) 5% 
B) 15% 
C) 95% 
D) 90%

Question 13

Which of the following best describes a group centroid?

Accepted Answer

A) A set of averages for the independent variables for the group. 
B) The average for all independent variables across all the groups. 
C) The center values for the independent variables for the group. 
D) The center value among all independent variables across all the groups. 
A) A set of averages for the independent variables for the group. 
B) The average for all independent variables across all the groups. 
C) The center values for the independent variables for the group. 
D) The center value among all independent variables across all the groups.

Question 14

The following questions are based on the problem description, regression results, and the RiskSolver Platform (RSP) 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).
          
-Refer to Exhibit 10.1. What formula is entered in cell F4 of the spreadsheet to compute the Predicted Group for the first student?

Accepted Answer

A) =IF(E4$\le$$E$26,2,1) 
B) =IF(E4$\le$$E$26,1,2) 
C) =IF(E4>$E$24,1,0) 
D) =IF(E4$\le$$E$24,1,2) 
A) =IF(E4$\le$$E$26,2,1) 
B) =IF(E4$\le$$E$26,1,2) 
C) =IF(E4>$E$24,1,0) 
D) =IF(E4$\le$$E$24,1,2)

Question 15

The following questions are based on the problem description, regression results, and the RiskSolver Platform (RSP) 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).
          
-Refer to Exhibit 10.1. What is the cut-off value (cell E26) for this data using the mid-point cut-off method?

Accepted Answer

A) 1.189 
B) 1.499 
C) 1.809 
D) 2.000 
A) 1.189 
B) 1.499 
C) 1.809 
D) 2.000

Question 16

The following questions are based on the problem description, regression results, and the RiskSolver Platform (RSP) 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).
          
-Refer to Exhibit 10.1. How many observations are classified correctly?

Accepted Answer

A) 11 
B) 9 
C) 17 
D) 20 
A) 11 
B) 9 
C) 17 
D) 20

Question 17

The regression approach can be used in the two-group discriminant analysis problem because

Accepted Answer

A) the data are not normally distributed. 
B) the R2 statistic is not very meaningful. 
C) the regression equation can generate a discriminant score. 
D) it scales to the k-group problem easily. 
A) the data are not normally distributed. 
B) the R2 statistic is not very meaningful. 
C) the regression equation can generate a discriminant score. 
D) it scales to the k-group problem easily.

Question 18

If using the regression tool for two-group discriminant analysis, in the regression dialog box, the Input X-Range entry corresponds to

Accepted Answer

A) the Group values. 
B) the independent variable values. 
C) the predicted variable values. 
D) the fitted variable values. 
A) the Group values. 
B) the independent variable values. 
C) the predicted variable values. 
D) the fitted variable values.

Question 19

Given the following confusion matrix   what is the correct classification rate?

Accepted Answer

A) 9/13 = 69% 
B) 10/14 = 86% 
C) 19/25 = 76% 
D) 6/19 = 32% 
A) 9/13 = 69% 
B) 10/14 = 86% 
C) 19/25 = 76% 
D) 6/19 = 32%

Question 20

The following questions are based on the problem description, spreadsheet, and the Risk Solver Platform (RSP) 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).
          
-Refer to Exhibit 10.2. What number of observations is classified incorrectly?

Accepted Answer

A) 19 
B) 20 
C) 7 
D) 1 
A) 19 
B) 20 
C) 7 
D) 1

If using the regression tool for two-group discriminant analysis, in the regression dialog box, the Input Y-Range entry corresponds to

Which of the following goodness-of-fit measures is used for discriminant analysis problems?

Which of the following best describes a group centroid?

The regression approach can be used in the two-group discriminant analysis problem because

If using the regression tool for two-group discriminant analysis, in the regression dialog box, the Input X-Range entry corresponds to

Given the following confusion matrix what is the correct classification rate?

Introduction to Modeling and Decision Analysis

Introduction to Optimization and Linear Programming

Modeling and Solving Lp Problems in a Spreadsheet

Sensitivity Analysis and the Simplex Method

Network Modeling

Integer Linear Programming

Goal Programming and Multiple Objective Optimization

Nonlinear Programming and Evolutionary Optimization

Regression Analysis

Time Series Forecasting

Introduction to Simulation Using Risk Solver Platform

Queuing Theory

Decision Analysis

Project Management Online

Filters

Exam 10: Discriminant Analysis

If using the regression tool for two-group discriminant analysis, in the regression dialog box, the Input Y-Range entry corresponds to

Which of the following goodness-of-fit measures is used for discriminant analysis problems?

Which of the following best describes a group centroid?

The regression approach can be used in the two-group discriminant analysis problem because

If using the regression tool for two-group discriminant analysis, in the regression dialog box, the Input X-Range entry corresponds to

Given the following confusion matrix what is the correct classification rate?

Introduction to Modeling and Decision Analysis

Introduction to Optimization and Linear Programming

Modeling and Solving Lp Problems in a Spreadsheet

Sensitivity Analysis and the Simplex Method

Network Modeling

Integer Linear Programming

Goal Programming and Multiple Objective Optimization

Nonlinear Programming and Evolutionary Optimization

Regression Analysis

Time Series Forecasting

Introduction to Simulation Using Risk Solver Platform

Queuing Theory

Decision Analysis

Project Management Online

Filters