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:

Mandatory Reporting Guidelines

Set rules and protocols dictating the legal obligation of certain professionals to report cases of abuse, neglect, or exploitation to the appropriate authorities.

School Social Worker

A professional who works within educational environments to provide support, counseling, and resources to students and their families.

Community Collaboration

The process of different groups or individuals working together for a common goal within a community setting.

Family Outreach Specialist

A professional role focused on establishing and enhancing relationships between families and institutions, such as schools or community services, to support children's development.