+ Reply to Thread
Results 1 to 2 of 2

Derive a formula for multiple variables

  1. #1
    Registered User
    Join Date
    08-07-2012
    Location
    Aus
    MS-Off Ver
    Excel 2007
    Posts
    1

    Derive a formula for multiple variables

    Hi. I want to know if its possible to find the formula of a result that is based on three other values. Here's my example:
    I give three cases, but I am sure all three use the same formula. I made the team names up but the values are 'real'.

    MATCHES TEAM NAME TEAM RATING OPP. RATING POINTS DIFF. NEW RATING
    Match1 Blumps -2.62 5.05 8 -1.28
    Match2 Champs 2.8 4.08 -18 2.37
    Match3 Sharps 8.26 -3.53 -16 3.68

    I want to know what formula was used to calculate the New Rating in the last column. I am not 100% sure if the formula to calculate the New Ratings as shown above includes a value for home ground advantage of which I might be unaware. For what its worth, the Blumps and Sharps were home teams and the Champs was a visiting team for the three matches shown.

    I know my way around excel but I am not a statistics fundi. If it is possible to solve this, could you please tell me how to go about finding the the solution in Excel because I have other similar problems that I would like to solve.

    Thank you in advance.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Derive a formula for multiple variables

    I know my way around excel but I am not a statistics fundi. If it is possible to solve this, could you please tell me how to go about finding the the solution in Excel because I have other similar problems that I would like to solve.
    It is probably some kind of competition rating system like the ELO rating system used in chess tournaments (http://en.wikipedia.org/wiki/Elo_rating_system). I expect that the first part of a problem like this will be to identify the specific rating system being used, and the equations used by that rating system. I realize that, in many ways, this is really restating your original question, but I don't think anyone will be able to "back out" the equations used unless you just happened to be lucky enough to come across someone who recognizes the specific rating system being used.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] IF Statement to derive a TRUE or FALES formula
    By rpc06 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-06-2014, 04:02 AM
  2. Derive formula from chart
    By hamidun in forum Excel Charting & Pivots
    Replies: 26
    Last Post: 04-29-2014, 09:12 AM
  3. Derive optimal mixture formula
    By SandPounder1 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-12-2014, 05:24 PM
  4. [SOLVED] Formula to Derive Date from Alphanumeric Code
    By gmarie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-16-2013, 09:50 AM
  5. derive formula from series of points
    By andyismilesaway in forum Excel General
    Replies: 1
    Last Post: 02-28-2007, 06:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1