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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock