<

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
Often times what you may consider better indicators of various items, others do not.  It is always a good idea to have a way to turn off conditional formatting in whatever program is displaying it.  The most obvious I will use here - MS Excel.
Not too long ago I wrote this article on doing the same thing in MS Access (https://www.experts-exchange.com/articles/38421/Making-your-Database-More-User-Friendly.html).  I found that a similar "Welcome" screen makes Excel worksheets "friendlier" a…