What is the probability of getting AT LEAST 79 out of 90 correct on a True or False test if you are guessing on every question?

I think I need to do a cumulative binomial test for this. But I don't know how to do this in Excel.

Would it be =Binomdist(79, 90, .5, FALSE) or would it be =1-binomdist(78,90,.5, TRUE) or neither?

I know how to do this by hand but it would take awhile. Help would be appreciated. Thanks!

I think I need to do a cumulative binomial test for this. But I don't know how to do this in Excel.

Would it be =Binomdist(79, 90, .5, FALSE) or would it be =1-binomdist(78,90,.5, TRUE) or neither?

I know how to do this by hand but it would take awhile. Help would be appreciated. Thanks!

Last edited: