The Following Questions Are Based on the Problem Description, Regression $\le$

question 54

Multiple Choice

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?

• 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)

---

Definitions:

Fisher's Exact Test

A statistical significance test used for small sample sizes, analyzing the association between two categorical variables.

2 × 2 Table

A contingency table with two rows and two columns used to display the frequency distribution of variables' combinations.

Significance Level

The threshold below which a p-value is considered strong enough to reject the null hypothesis in statistical testing.

Degrees of Freedom

The number of independent values or quantities that can vary in the calculation of a statistic, often impacting its distribution.