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

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)