Answered You can hire a professional tutor to get the answer.

QUESTION

Consider a multiple-choice examination with 50 questions. Each question has four possible answers.

Hi

I need to solve this question using excel please help!

Consider a multiple-choice examination with 50 questions. Each question has four possible answers. Assume that student who has done the homework and attended lectures has a 75% probability of answering any question correctly. Use Excel to find the following probabilities:

a) A student must answer 43 or more questions correctly to obtain a grade of A. What percentage of the students who have done their homework and attended lectures will obtain a grade of A on this multiple-choice examination?

b) A student who answers 35 to 39 questions correctly will receive a grade of C. What percentage of the students who have done their homework and attended lectures will obtain a grade of C on this multiple-choice examination?

c) A student must answer 30 or more questions correctly to pass the examination. What percentage of the students who have done their homework and attended lectures will to pass the examination?

d) Assume that a student has not attended class and has not done the homework for the course. Furthermore, assume that the student will simply guess at the answer to each question. What is the probability that this student will answer 30 or more questions correctly and pass the examination?

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question