Forecasting probability for deal/quote to win

Question

Hi all,

I currently have a large dataset of deals that are either 'open', 'lost', or 'won'. Most deals that are won will take approximately 2-3 months.

I want to essentially forecast the subtotal of won deals in the next few months, but I'm having trouble setting up my model. Namely, I'm having trouble incorporating the 2-3 month average time for deals to be won. Because the probability for a deal to win increases with time, before it hits around 3 months and then it starts decreasing with time.

Does anyone have any ideas? I managed to implement a super basic model within my BI tool that follows a normal distribution, but I'm looking for something more robust. Thanks in advance!

Posted Sep 30, 2021, 8:11 PM UTC

61
[deleted]•

[deleted]

1
sn0wdizzle•

Check out survival analysis.

1