## South African Skeptics

November 21, 2018, 21:39:39 PM
 Skeptic Forum Board Index Help Forum Rules Search GoogleTagged Login Register Chat Blogroll
 Pages: [1]   Go Down
Author Topic:

# Formula

0 Members and 1 Guest are viewing this topic.
Tweefo
Hero Member

Skeptical ability: +9/-0
Offline

Posts: 1506

 « on: February 23, 2016, 06:04:25 AM »

All the Mathematical boffins here. I need the formula for a slide scale. The percentage of 1500 = 40%. The percentage must slide down and at 25000 and above it must be at 10%. <1500 = 40% >25000 = 10%.
 Logged
Rigil Kent
Clotting Factor
Hero Member

Skeptical ability: +19/-3
Offline

Posts: 2440

Three men make a tiger.

 « Reply #1 on: February 23, 2016, 07:18:59 AM »

It looks like you're describing a piecewise function. I doubt there is "one formula to rule them all". Assuming that the "slidy" part is linear, you could maybe try something like this:

y = 40                                             for x < 1500

y = 40 + ( 3 / 2350 )( 1500 - x )       for 1500 ≤ x ≤ 25000

y = 10                                             for x > 25000

Rigil

 Logged
Tweefo
Hero Member

Skeptical ability: +9/-0
Offline

Posts: 1506

 « Reply #2 on: February 23, 2016, 09:18:07 AM »

Thanks. MS Excel came to the rescue. I am a dof after 2+2.
 Logged
 Pages: [1]   Go Up