View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
smartin smartin is offline
external usenet poster
 
Posts: 915
Default Probability, how can I write this into a formula in excel?

Six Sigma Blackbelt wrote:
Suppose that in a company, 29% of all vice presidents hold MBA degrees, 24%
hold undergraduate business degrees, and 8% hold both. A vice president is
to be selected randomly.

a) What is the probability that the vice president holds either an MBA or
an undergraduate business degree (or both)
b) What is the probability that the vice president holds neither?


To understand the probabilities try making a little table and fill in
the blanks...

MBA no MBA |
UB 8 ? | 24
no UB ? ? | ?
----------------------+-----
29 ? | 100

Then the formulas should become obvious.