South African Skeptics

Formula

Tweefo · 3 · 1906
« previous next »
Pages: 1   Go Down

Offline Tweefo

  • Hero Member
  • *****
    • Posts: 1581
    • Skeptical ability: +10/-0
    • African Sky Planetaruim
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%.
If you don't agree with me you are obviously not from this planet.

Offline Rigil Kent

  • Third Party Cookie
  • Hero Member
  • *****
    • Posts: 2563
    • Skeptical ability: +20/-3
  • 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

You know it's cold outside when you go outside and it's cold.

Offline Tweefo

  • Hero Member
  • *****
    • Posts: 1581
    • Skeptical ability: +10/-0
    • African Sky Planetaruim
Reply #2 on: February 23, 2016, 09:18:07 am
Thanks. MS Excel came to the rescue. I am a dof after 2+2.
If you don't agree with me you are obviously not from this planet.

Pages: 1   Go Up