<

Watch Building Probability Models in Excel Part 2: Simulating Sales Calls

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

Expert Comment

by:ankitha reddy
nice one.. thanks for the video
0
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in 2013 or 2016. Now that Office 2019 is here, the bad news is that it is still missing, but the good news is that the same no-cost method that works to install it…
This article addresses the need, sometimes extreme, for a legend that may not be easy to create, depending on the features of conditional formatting you have used.  Almost all spreadsheets need some sort of legend.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month