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.
Bookmarks