<

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Building Probability Models in Excel Part 2: Simulating Sales Calls

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

Featured Post

Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Switching from G suite to Office 365? Here are the top 5 reasons you need know for G Suite to Office 365 migration, comparing all the possible factors of both Google Apps and Exchange Online.
Many applications need to compute the road distance between two addresses.  Numerous websites perform this function, but to build this feature into your application, you must use an API to call these features via the internet.  This article discusse…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month