USING EXCEL FUNCTIONS

I have a binomially distributed process. I take a SRS of 10 items. If the probability of a success on any given trial is .3

P(x=3) = ____________ cumulative = 0

P( X<=3 ) = ______________ cumulative =1

P( X < 4 ) = ________________

P ( X > 2 ) = ________________

P( 1<= X < 5 ) = _______________

1. If we are supposed to have a max of 5% defects arriving from supplier. I sample 50 and find 7 defects do we have a case the whole lot is bad?
2. We have a 200 seat airplane. Historically 95% of ticket holders show up for the flight. If I sell 209 tickets what is the probability of having to bump one or more ticket holders off the flight?