# Derive a formula for multiple variables

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.

2. ## 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.

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

#### 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