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

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