![]() |
Golf Handicap Stroke Allocation and Regression Analysis
Is there a statistical whizz here who is also a golfer?
I am having a little difficulty with one element of a calculation outlined in the USGA's Handicap manual - ref here - http://www.usga.org/playing/handicap...ection_17.html My problem is I don't understand the underlying stats in Section 17.2b Regression method, and I am not sure if I am interpreting the order of claculations correctly in the formula - 5) Compute the difference factor (DF) DF = (N x S4) - (S1 x S2) divided by (N x S3) - (S12) Any assistance would be greatly appreciated dai -- Dai Evans Laguna Beach, CA |
Golf Handicap Stroke Allocation and Regression Analysis
I'm no statistician (or golfer) but that formula in Excel terms would look
something like this: =(N*S4-S1*S2)/(N*S3-(S1^2)) Excel does multiplication and division before addition and subtraction so you don't need a lot of parens, but you can add more if you want them. Note that the S1, etc. are not cell references but rather your variables. You'd replace them with the actual addresses of the cells holding each variable. -- Jim "David Morris Evans" wrote in message ... | Is there a statistical whizz here who is also a golfer? | I am having a little difficulty with one element of a calculation outlined | in the USGA's Handicap manual - ref here - | http://www.usga.org/playing/handicap...ection_17.html | My problem is I don't understand the underlying stats in Section 17.2b | Regression method, and I am not sure if I am interpreting the order of | claculations correctly in the formula - 5) Compute the difference factor (DF) | | DF = (N x S4) - (S1 x S2) divided by (N x S3) - (S12) | | Any assistance would be greatly appreciated | | dai | | -- | Dai Evans | Laguna Beach, CA |
All times are GMT +1. The time now is 04:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com