Building Probability Models in Excel Part 2: Simulating Sales Calls
Posted on
6,396 Points
4:45
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels.
Video Steps
1. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill level”
2. Enter =IF(RAND()<$C$2,1,0) into cell A2 and copy to A31
3. Enter =SUM(A2:A31) into cell C4
4. Simulating Calls With Two Different Skill Levels: Enter =2/3 into cell E2 for high skill and =1/3 into cell F2 for low skill
5. Enter =IF(RAND()<0.5, E2, F2) into cell C2
Suggested Videos
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA.
In this part: Compatible with other environments.
Have you ever wanted to make your MS Excel spreadsheet more easy to follow? Here is one way to do just that.
