Golf Scores. During the summer of 2018, Coldstream Country Club in Cincinnati, Ohio, collected data on 443 rounds of golf played from its white tees. The data for each golfer's score on the twelfth hole are contained in the DATAfile Coldstream12.

1. Construct an empirical discrete probability distribution for the player scores on the twelfth hole.
2. A par is the score that a good golfer is expected to get for the hole. For hole 12, par is four. What is the probability of a player scoring less than or equal to par on the hole number 12?
3. What is the expected score for hole number 12?
4. What is the variance for hole number 12?
5. What is the standard deviation for hole number 12?

*PLEASE show me the steps on the excel functions you used so i can put the same ones while constructing my answer. Do not show me the answer only, please show excel steps. *

Data File Coldtream12:

Hole 12 Score

6

7

5

7

5

5

5

4

5

5

5

5

5

4

5

5

5

7

5

7

7

5

6

5

5

5

6

5

6

5

6

5

5

5

6

5

5

6

5

6

5

5

6

5

6

6

6

4

3

4

6

8

6

6

6

4

6

5

6

5

6

6

6

6

4

5

5

5

5

7

5

6

5

6

5

4

6

5

5

5

5

5

7

5

5

4

5

5

6

6

5

5

6

5

5

4

6

5

5

5

5

5

6

5

5

4

6

5

5

5

6

5

5

4

6

7

5

5

5

6

4

6

4

5

7

6

6

4

5

4

5

6

6

5

5

5

6

5

5

5

6

4

4

5

5

4

5

8

5

4

5

6

5

4

6

6

5

4

5

6

5

5

4

6

6

6

4

5

6

6

6

6

5

5

6

6

6

6

6

6

7

5

6

7

5

6

6

5

6

6

5

6

5

6

7

6

6

5

5

5

5

6

5

4

8

6

5

5

5

5

6

7

6

7

6

6

4

5

6

4

5

5

7

5

5

5

5

5

7

5

6

6

5

4

5

5

5

5

4

6

5

5

5

5

6

5

5

6

5

7

5

5

5

5

5

5

5

4

5

5

6

5

4

5

5

5

6

5

5

6

6

6

6

6

7

6

6

5

6

5

4

6

5

5

5

5

6

6

5

7

6

5

6

5

5

8

5

3

6

6

6

6

5

3

6

7

5

5

4

6

5

6

5

5

4

5

5

7

5

5

7

5

5

6

6

6

6

6

5

5

4

5

6

5

6

5

6

5

6

5

5

5

5

5

5

4

5

5

4

5

6

6

6

5

6

4

6

5

6

4

4

3

5

4

5

6

5

5

6

4

6

4

4

5

5

6

7

5

4

7

5

6

5

6

5

4

5

6

5

5

4

5

5

6

5

6

7

6

4

5

6

5

4

4

4

5

5

4

4

6

4

5

5

7

5

5

6

4

5

6

5

5

6

6

5

5

6

7

5

6

5

5

5

4

4

6

5

4

6

6

6

6

5