Skudwincell
New Member
- Joined
- Mar 5, 2015
- Messages
- 2
Hey Guys,
I'm currently doing some uni analytics work and I'm trying to make a cell represent the chance of two other cells being mutually exclusive. Is there a way of including the probability of each cell occurring in the formula?
The example is
Year 1:
Low Price: x, 0.4
High Price: y, 0.6
Year 2:
Low Price: a, 0.4
High Price b, 0.6
and so on..
I want a cell to show the answer after assuming the cells are mutually exclusive.
I'm assuming the formula I need to use is P(x) + P somehow?
Any help would be greatly appreciated as this is due soon!
I'm currently doing some uni analytics work and I'm trying to make a cell represent the chance of two other cells being mutually exclusive. Is there a way of including the probability of each cell occurring in the formula?
The example is
Year 1:
Low Price: x, 0.4
High Price: y, 0.6
Year 2:
Low Price: a, 0.4
High Price b, 0.6
and so on..
I want a cell to show the answer after assuming the cells are mutually exclusive.
I'm assuming the formula I need to use is P(x) + P somehow?
Any help would be greatly appreciated as this is due soon!