I need to be able to compute this on an Excel spreadsheet.
Binomial Distribution and Poisson Tables
GUESSING-NO KNOWLEDGE
A.) A student takes a 20 question multiple choice exam and guesses on each question. Each question has four choices. What is the probability of getting exactly 8 correct out of the 20 questions?
B.) A student takes a 20 question multiple choice exam and guesses on each question. Each question has four choices. What is the probability of getting AT LEAST 8 correct out of the 20 questions?
SOME KNOWLEDGE (KNOWS 50% of the questions):
C.) A student takes a 20 question multiple choice exam and guesses on each question. Each question has four choices. What is the probability of getting exactly 18 correct out of the 20 questions?
D.) A student takes a 20 question multiple choice exam and guesses on each question. Each question has four choices. What is the probability of getting AT LEAST 18 correct out of the 20 questions?
