Formula for Calculating Pythagorean Theorem

Hi, I wanted to calculate the Pythagorean Theorem related to sports teams using an Excel Formula.

This is the formula: Win % = (Points For)^13.93 / [(Points For)^13.93 + (Points Against)^13.93]

I figure if I have their points for in one column and their points against in another, I'd like to be able to find out their Pythagorean Win % in a third column using this formula hopefully. Can Excel even deal with exponents? Thank you.

Originally Posted by Zach Boyer

... Can Excel even deal with exponents? ...

Yes, you can use the exponentiation operation ( ^ ) as you have shown, or you can use the POWER function. The rest is as you have shown it - just substitute the appropriate cell references for points for and against.

Hope this helps.

Pete

Hi, thanks, great news, any chance you could write out an example formula of what it would look like in Excel? Very new to this. Ty.

Assuming your data is in columns A and B, starting on row 2, put this formula in C2:

=A2^13.93 / (A2^13.93 + B2^13.93)

Format the cell as a percentage, then copy down.

Hope this helps.

Pete

Awesomeee

Thanks for the rep, Zach.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete