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:

Communication

The process of sharing information, ideas, or feelings between people through speaking, writing, or other mediums to achieve mutual understanding.

Collaborative Problem Solving

A method where two or more individuals or groups work together through idea sharing and open communication to achieve a mutual solution to a problem.

Functional Structure

An organizational design where the company is divided into departments based on special functions such as marketing, finance, and production.

Technical Knowledge

Specific expertise or skills related to a particular field or technology, necessary for performing tasks and solving problems within that domain.