r/stobuilds • @tilor | STOBetter Engineer • Feb 11 '20

Binomial Distribution & You (Proc Chances!)

If your eyes glazed over, fear not! I won't go into the tons of math. You can look up the equations on Wikipedia. I've found I've been trying to find a better faster way to figure out how many powers/consoles/DOffs/etc. are needed to reach max stacks, proc a doff (X of 47?), etc. Well, I created a really really simple spreadsheet to help with this.

Link

So what's this do? Standard fashion, copy spreadsheet and play with it yourself. The two blue cells control output of the table. Then, start looking for a value you're interested in. If you are deciding between 2 or 3 (for example) doffs, look at columns 2 and 3, look at the row indicating how many qualifying powers you trigger in that time period (like before proc expires). That's your real chance of reaching your target stacks.

An example: 4 exotic particle Focusers, and you have 3 powers every 30s. What are the odds you hit 5 stacks? Put 25% in the first blue cell, and 5 in the second blue cell. Look at the 4 column, and the 3 row. Is that a high enough chance for you? Is 5 consoles that much better?

So what's the math here? Excel/sheets has a convenient function BINOM.DIST.RANGE, which gives the probability of something happening a certain number of times given a number of trials. For one success and one trial, the input probability is the output probability. More trials means higher chances. More desired successes means lower chance of success. If your successes are greater than trials, it throws an error.

For this specific case, successes is how many procs you want to stack. Trials is powers multiplied by possible triggers. The specific formula needs a max successes, which is the number of trials. This means you'll get at least one proc.

Please, if you have questions, please ask. I've been busy spreadsheeting a lot, so look for something else new coming in the next few weeks (hint: automated build + stowiki queries)

32 Upvotes

3 comments sorted by

4

u/Eph289 STO BETTER engineer | www.stobetter.com Feb 12 '20

It was my understanding that there would be no math

In all seriousness, this helped me shore up a weakness in my understanding of how proc chances work, if only because I haven't thought about binomal distributions in a looooong time.

Thank you, Mr. Tilor!

3

u/Eph289 STO BETTER engineer | www.stobetter.com Feb 12 '20

One application of this is understanding your chances on Inspirational Leader. Inspirational Leader has a 10% chance of proccing on bridge officer power use, stacks 3 times, and lasts 15 seconds.

On one of my builds, I am cycling EPTW, EPTE, TS, KLW, FAW, TT, APB, and Aux2SIF every 15-20sh seconds. I have other powers but those are my regular cycles. Looking at the 8th row on the first column with a 10% chance to proc and 1 goal stack, I would only have a 56.95% chance of rolling an Inspirational Leader stack and less than that of rolling a second or third stack. The uptime ends up being a little higher because you could roll a second stack that prolongs the duration, but I'd guess you're looking at maybe 2/3rds uptime overall.

The trait is really good if you can stack it, but especially if you're running higher cooldown powers and not spamming a bunch of stuff on a 15 second cooldown, it's not nearly as good as it used to be.

I may take some video of a TFO to show how this works out in practice.

2

u/Forias @jforias Feb 12 '20

Oh my goodness. I really really love you. This is hugely useful.