Hi David,
On Wednesday, 2008-06-25 20:55:12 +0100, David King wrote:
Say we have A1:C1 = {7|6|5}
In cell A2 we enter, as an array formula:
=PROB({5;6;7};{0.2;0.3;0.5};A1:C1)
and, correctly, A2:C2 = {0.5|0.3|0.2}.
Now in cell D4 we enter, as a normal (non-array) formula:
Hi Eike
Following up here on your response to this issue. Thanks for
looking at it.
Say we have A1:C1 = {7|6|5}
In cell A2 we enter, as an array formula:
=PROB({5;6;7};{0.2;0.3;0.5};A1:C1)
and, correctly, A2:C2 = {0.5|0.3|0.2}.
Now in cell D4 we enter, as a normal (non-array) formula: