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: Storing hashed or encrypted data.
I am not a database expert nor am I conversant with database design, but I have had a couple of run-ins with databases that are either badly designed or use a platform that doesn’t meet the needs of the end-user. I would like to think this is a "le…
