View Single Post
  #5   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?

JoeU2004 makes a good point, although I might argue his interpretation.
Is this a homework question or what? I was intentionally vague (and
leading) in my previous response.

Six Sigma Blackbelt wrote:
smartin

Thanks for the lead, but I need assistance figuring out the formula to solve
the word problem..

Cheers & thanks

"smartin" wrote:

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.