The Score of Students in a Subject Is Inserted in B2

question 7

Multiple Choice

The score of students in a subject is inserted in B2 cell and the passing score for the subject is 60.Which of these functions will you insert in C2 cell to check if the student has passed or failed?

• A) =IF(B2>=60,"Pass","Fail")
• B) =OR(B2>=60,"Pass","Fail")
• C) =AND(B2>=60,"Pass","Fail")
• D) =NOT(OR((B2>=60,"Pass","Fail"))

---

Definitions:

Null Hypothesis

A statistical hypothesis that assumes no significant difference or effect exists within a set of given observations or parameters.

Level of Significance

The probability of rejecting the null hypothesis when it is actually true, typically denoted as alpha (α).

Contingency Table

A tabular method for displaying the frequencies of different outcomes in a sample, allowing for analysis of the association between categorical variables.

Null Hypothesis

A statistical hypothesis that assumes no significant difference or effect exists between certain characteristics of a population or dataset.