Question: Show how you would plug in this word problem in excel using the formula =binom.dist CALCULATED FORMULA CORRECT 1/1 You are conducting an experiment with
Show how you would plug in this word problem in excel using the formula =binom.dist
CALCULATED FORMULA CORRECT 1/1 You are conducting an experiment with 18 trials. For each trial, the result will either be a "success" or a "failure", and the probability of a success for each trial is 0.5. What is the probability the experiment will have less than 5 successes. (Round to at least 4 decimal places.) Round your answer to 4 decimal places. Your answer: 0.0154 Correct The answer is 0.0154 + 0.00005 Feedback Use the "binom.dist" function to create a discrete distribution table (from 0 to "n" successes), and then locate the probabilities for which the question is asking. Recall, for the "binom.dist" function, there are 4 inputs: 1) # of "successes", le., "x" 2) total number of trials, l.e., "n" 3) probability for success, l.e., "p" 4) false (b/c we don't want a cumulative distribution)Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
