Results 1 to 3 of 3

Math Help - Formula involving a score for questions answered within a set time

  1. #1
    Newbie
    Joined
    Dec 2012
    From
    Ramsgate
    Posts
    7

    Formula involving a score for questions answered within a set time

    Hi All, I hope I am posting in the correct thread? I am using Microsoft Excel to construct a formula so it is possible to use "IF" statements but I need a little help on the Maths side.

    The student has to answer 25 questions while being timed.
    The goal is to answer the questions within 25 seconds.
    If he answers all questions correctly then this will earn him a rating of 3000 (the maximum rating)
    If he answers all questions correctly but takes 50 seconds then his rating would be 1500
    If he answers all questions correctly but takes only 15 seconds then his rating would still be 3000.

    Can any one help with the Maths relating to this?
    Many thanks
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Joined
    Sep 2012
    From
    Australia
    Posts
    3,807
    Thanks
    660

    Re: Formula involving a score for questions answered within a set time

    Hey tlawson.

    Are you familiar with the Heaviside function? You can convert IF statements into mathematical functions with this function.

    Heaviside step function - Wikipedia, the free encyclopedia
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Dec 2012
    From
    Ramsgate
    Posts
    7

    Re: Formula involving a score for questions answered within a set time

    Hi Chiro

    Sorry but I think my post may be a bit misleading.
    What I need is some formulas or the method to work out the test results Rating. I was unsure if this could be done using 1 formula so just happened to mention that I was using Excel to solve it. Maybe I should have left that bit out.
    I think the problem should be easy to solve but in this case I am being let down by my maths knowledge or lack of.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 3
    Last Post: April 22nd 2013, 12:30 PM
  2. Z-Score to Percentile Formula?
    Posted in the Advanced Statistics Forum
    Replies: 17
    Last Post: March 7th 2013, 08:40 PM
  3. probability involving z-score
    Posted in the Advanced Statistics Forum
    Replies: 5
    Last Post: July 27th 2010, 09:18 PM
  4. Replies: 8
    Last Post: March 3rd 2009, 11:14 AM
  5. Replies: 3
    Last Post: August 19th 2006, 11:49 PM

Search Tags


/mathhelpforum @mathhelpforum