ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Golf Handicap Stroke Allocation and Regression Analysis (https://www.excelbanter.com/excel-discussion-misc-queries/213084-golf-handicap-stroke-allocation-regression-analysis.html)

David Morris Evans

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

Jim Rech

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