<

Building Probability Models in Excel Part 2: Simulating Sales Calls

Posted on
6,291 Points
291 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Join & Write a Comment

Do you know how to convert CSV to multiple VCF formats? Are you searching for a hassle-free solution to import .csv file contacts into .vcf files? Get an optimum solution here to export Excel or CSV files to vCard or VCF formats! Read more to know t…
Want to troubleshoot the issue of importing contacts from Excel to Outlook error No Named Ranges?? Resolve this problem and get the error-free solution to resolve the “No Named Ranges” error in a hassle-free way.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month