I need a formula!

We are the Borg.
User avatar
Posts: 23316
Joined: Tue Jun 29, 2004 12:40 am
Location: New Port Richey, FL

I need a formula!

Post by gnome »

Hoping maybe a mathematical thinker or two can devise something that works here.

I have a list of provider groups, each being given a certain compliance percentage on a metric. So the data is basically a list with three columns: ID, numerator (N), denominator (D). I can calculate the compliance rate for any provider with N/D. I can calculate the compliance rate of the whole set by SUM(N)/SUM(D). Let's say for October this compliance rate is 72%.

I also have a completion factor--this is a way to estimate the final overall numerator based on a prediction what % of all the numerators for the year have accumulated. Let's say for October it's 80%. That means that we expect that our current numerators are only 80% of the final total, so we expect to end the year with 90% compliance on the whole set. (0.72/0.80)

So far so good. However, we are in need of a prediction that applies to individual groups. This seems fine for groups with a low performance, say 50% -- their end of year forecast would be 0.50/0.80 = 62.5%.

The trouble comes in when an individual group is already performing better than the compliance factor. So say I've got a really good group that's at 85%. If I apply the factor that means I expect them at .85/.80 = 106.25%, which is ridiculous, as the numerator cannot exceed the denominator. There just aren't enough gaps (denominator minus numerator) to get that much of a boost. Even capping them at 100% doesn't make sense, as there's no reason to think they'll get full compliance just because their current results are that high.

Clearly the problem is that even if the overall set can be expected to get a certain percentage more by end of year, individual groups will not all get the same percentage, and some of them literally can't. I'm looking for a formula that gives larger boosts to lower percentages, and smaller boosts to higher percentages, so that no prediction exceeds 100%, but even high performers can expect to gain a little bit, and that still works out to 90% overall. So far the only one I found flattens the data too much, so that practically every group winds up at 90% or close to it. I'm thinking my problem is that I'm using a linear formula, and maybe something quadratic will be more balanced. But it's been a LOOOOOOOONG time for me for that sort of thing, and I'm coming up blank. Anyone got any ideas?
"If fighting is sure to result in victory, then you must fight! Sun Tzu said that, and I'd say he knows a little bit more about fighting than you do, pal, because he invented it, and then he perfected it so that no living man could best him in the ring of honor. Then, he used his fight money to buy two of every animal on earth, and then he herded them onto a boat, and then he beat the crap out of every single one. And from that day forward any time a bunch of animals are together in one place it's called a zoo! (Beat) Unless it's a farm!"
--Soldier, TF2

User avatar
Rob Lister
Posts: 21877
Joined: Sun Jul 18, 2004 7:15 pm
Title: Incipient toppler
Location: Swimming in Lake Ed

Re: I need a formula!

Post by Rob Lister »

User avatar
Posts: 26346
Joined: Thu Sep 19, 2013 5:50 pm

Re: I need a formula!

Post by Witness »

Extrapolate what remains to be done.

User avatar
Posts: 6273
Joined: Thu Jun 10, 2004 12:16 pm
Title: inbred shit-for-brains
Location: Planet X

Re: I need a formula!

Post by shemp »

"It is not I who is mad! It is I who is crazy!" -- Ren Hoek

"what dicking deep shit i produce" -- pillory

Freedom of choice
Is what you got
Freedom from choice
Is what you want

People are shitting themselves to death
Crap so much they fail to take a breath
But even when their kids are starvin'
They thought Trump would throw them Charmin.