|
BGonline.org Forums
I may have it sorted out
Posted By: Chase In Response To: PR question for the mathematically inclined (eXtreme Gammon)
Date: Monday, 25 March 2013, at 5:06 p.m.
1) I got rid of the #Name? messages by manually entering the range of cells into the formula (BD2:BD91).
2) The error 509 message was due to OpenOffice wanting semicolons instead of commas between the arguments. Making that change gives me an actual number.
3) I think you meant to reference cell BF4 instead of BF5 in the formulas in BF7 and BF8. Making that change gives me some meaningful looking numbers.
So, here are my results:
BF2: 4.73 (This is my average PR)
BF3: 3.64 (This is my standard deviation)
BF4: 0.75 (This is my confidence interval)
BF7: 3.98 (Lower boundary of 95% confidence interval)
BF8: 5.48 (Upper boundary of 95% confidence interval)Does that look, and sound, correct?
If so, it sounds like I need a lot more games to get an accurate picture of my true PR. Yes?
|
BGonline.org Forums is maintained by Stick with WebBBS 5.12.