Car color preferences change over the years and according to the particular model that the customer selects. In a recent year, 20% of all luxury cars sold were white. Assume that 25 cars of that year and types are randomly selected. In this binomial distribution application, which Excel statement will find the probability of more than 7 white luxury cars?

=1-BINOMDIST(7,25,20%,FALSE)

=1-BINOMDIST(7,25,20%,TRUE)

=BINOMDIST(7,25,20%,FALSE)

=BINOMDIST(7,25,20%,TRUE)

A medical association study shows that 20% of all Americans suffer from high blood pressure. Suppose that 10 Americans are randomly selected and each person is asked if he has high blood pressure. In this binomial distribution application, which Excel statement will find the probability of between 3 and 7 Americans, inclusively, with high blood pressure?

=1-BINOMDIST(4,10,20%,TRUE)

=1-BINOMDIST(3,7,20%,FALSE)

=BINOMDIST(7,10,20%,FALSE)-BINOMDIST(3,10,20%,FALSE)

=BINOMDIST(7,10,20%,TRUE)-BINOMDIST(2,10,20%,TRUE)