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.
|