To obtain a golfers handicap, you average the 10 lowest scores of the golfers last 20 rounds.

Question:

To obtain a golfer’s handicap, you average the 10 lowest scores of the golfer’s last 20 rounds. Then you subtract 80 and round to the nearest integer. Thus, if the 10 lowest scores of the last 20 rounds add up to 864, the handicap would be 6. The file named Golfdata.xlsx contains a golfer’s scores. Beginning in row 24, compute the golfer’s handicap after each round. Assume that if the tenth-best score in the last 20 rounds occurs more than once, then all rounds including that score will be included in the handicap calculation. Note that the Excel function =ROUND(x,0) will round x to the nearest integer.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: