If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

What If Analysis Question

Thread starter Andresleo47
Start date Nov 8, 2022

Andresleo47

Board Regular

Nov 8, 2022

Hi Guys, this is kind of a Statistics question, but I need to verify it with Excel using the What If Analysis:

There are 4 different yellow fruits and 12 different green fruits in a fruit basket, where each yellow fruit has a 10% probability of being drawn and each green fruit has a 5% probability of being drawn, find the expected number of times to draw all 16 different fruits and explain the calculation process (each draw is relatively independent)

Here's my answer:

Count	Fruit	Probability	Value*Probabilty
1	Yellow	0.1	0.1
2	Yellow	0.1	0.2
3	Yellow	0.1	0.3
4	Yellow	0.1	0.4
5	Green	0.05	0.25
6	Green	0.05	0.3
7	Green	0.05	0.35
8	Green	0.05	0.4
9	Green	0.05	0.45
10	Green	0.05	0.5
11	Green	0.05	0.55
12	Green	0.05	0.6
13	Green	0.05	0.65
14	Green	0.05	0.7
15	Green	0.05	0.75
16	Green	0.05	0.8
		Expected	7.3