help with distribution formula!

  • Thread starter Thread starter whiteballa14
  • Start date Start date
W

whiteballa14

i need to make a distribution table. i know that i use the -normdist-
function, i just can't figure out what to put in each argument.

my data is 10 questions, and each question has 5 answers to choose from
(multiple choice). Assuming that im making complete random guesses, i
need to find the probability of getting 1 question correct, 2
questions, 3, 4, and so on until i get the prob. of getting all 10
correct. what would i plug into each argument?

x -
mean -
standard Dev -
cumulative -

i'm not specifically asking for the answers, but more for help on
figuring out which goes into each. thanks!
 
Actually, NORMDIST would just be an approximation to BINOMDIST with
trials=10 and probability_s=0.2 in this case. Help for BINOMDIST should
get you the rest of the way.

Jerry
 
Back
Top