Question

A poll is given, showing 35% are in favor of a new building project. If 7 people are chosen at random, what is the probability that exactly 3 of them favor the new building project?

Can you please explain how to solve this problem in excel?

Answer 1

X ~ B ( n = 7 , P = 0.35 )

Excel formula

BINOM.DIST(3,7,0.35,FALSE) = 0.26787094140625

BINOM.DIST(number_s,trials,probability_s,cumulative)

number = 3

trials = 7

probability = 0.35

cumulative = False ( since we need exact probability for 3 )