<

Building Probability Models in Excel Part 2: Simulating Sales Calls

Posted on
6,273 Points
273 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
Comment
Author:Toby Reaper
1 Comment
 
LVL 1

Expert Comment

by:ankitha reddy
nice one.. thanks for the video
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Join & Write a Comment

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
I came across an unsolved Outlook issue and here is my solution.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month