The following is the hypothesis I'm trying to work with:
"Students who do not achieve at least 70% in high school English will not pass a college admissions test."
I was given a dataset with over 800+ high school English grades expressed in percentages. The dataset also includes whether each student "passed" or "failed" the college admissions test. For example, the data looks like this (times 800 cases):
"Students who do not achieve at least 70% in high school English will not pass a college admissions test."
I was given a dataset with over 800+ high school English grades expressed in percentages. The dataset also includes whether each student "passed" or "failed" the college admissions test. For example, the data looks like this (times 800 cases):
Student 1: 79% English grade; PASS
Student 2: 56% English grade; PASS
Student 3: 80% English grade; FAIL
Student 4: 93% English grade; PASS
Student 5: 60% English grade; FAIL
Student 2: 56% English grade; PASS
Student 3: 80% English grade; FAIL
Student 4: 93% English grade; PASS
Student 5: 60% English grade; FAIL
I just don't know where to even begin with analyzing this hypothesis because the high school English grades are ratio, but the admission test outcomes are nominal. What statistical tests can I run with the provided data to analyze the hypothesis?
Also note: The only software I have to analyze the data is Excel.
Also note: The only software I have to analyze the data is Excel.