IrishHawk01
New Member
- Joined
- Mar 20, 2014
- Messages
- 4
I'm spinning wheels. Here is what I'm attempting
I'm trying to use the empirical discrete probability distributions to generate 1000 days of Widget sales and returns.
I need to use Nested IF statements to generate the 1000 days of sales. So for 1000 days, generate a number in a column that represents widget sales for that day based upon the given probabilities.
<tbody>
</tbody>
I'm trying to use the empirical discrete probability distributions to generate 1000 days of Widget sales and returns.
I need to use Nested IF statements to generate the 1000 days of sales. So for 1000 days, generate a number in a column that represents widget sales for that day based upon the given probabilities.
Number of Widgets Sold | Probability |
0 | 0.10 |
1 | 0.21 |
2 | 0.13 |
3 | 0.23 |
4 | 0.27 |
5 | 0.06 |
<tbody>
</tbody>