<

Building Probability Models in Excel Part 2: Simulating Sales Calls

Posted on
6,396 Points
396 Views
Last Modified:
Published
Experience Level: Beginner
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

0
Author:Toby Reaper
1 Comment
LVL 1

Comment

by:ankitha reddy
nice one.. thanks for the video
0
While repairing a troublesome IMAP connection with Office 365, a list of over 500 Outlook Contacts mysteriously disappeared. Learn how to prevent and safeguard yourself against that happening to you by following the steps in this article.
A while back I wrote an article about the Power Query Editor and PowerBI (https://www.experts-exchange.com/articles/37938/PowerBI-and-the-Query-Editor-Save-time.html).  I have realized that my coworkers primarily use Excel and So have changed the ar…