View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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