Moin!
jericho wrote: ↑Fri May 19, 2023 10:25 am
Poker-TH2.xlsx This excel file is for evaluate if it is worth to play more games or you must improve your average in order to reach a desired position. The cells with red background are related to a total score greater than 150.
I'm not sure, what you want to accomplish with this calculation, but I thought about this:
As the partial derivation of the formula over "average" is a constant, you really just need the first row.
Example: n = 57, f(n, 1) = 23.72
That means: avg = 6.34, f(n, avg) = avg * f(n, 1) = 6.34 * 23.72 = 150.3848 (150.38).
Next step would be the partial derivation over "games", that's a bit more complicated.
It also depends on considering "average" or "points", because avg = pts / games.
If you use points, the term depends on games in a different way.
Other than if you hold the average constant. Want some more?
What's also missing in your sheet, are input fields for avg and n (games).
Or is this just an overview/table?
Have fun, SLC42