Scores in the first and final rounds for a sample of 20 golferswho competed in tournaments are contained in the Excel Online filebelow. Construct a spreadsheet to answer the followingquestions.

	A	B	C	D
1	Player	First Round	Final Round	Differences
2	Michael Letzig	74	76	-2
3	Scott Verplank	76	66	10
4	D.A. Points	74	67	7
5	Jerry Kelly	71	72	-1
6	Soren Hansen	66	74	-8
7	D.J. Trahan	76	74	2
8	Bubba Watson	69	73	-4
9	Reteif Goosen	77	66	11
10	Jeff Klauk	69	65	4
11	Kenny Perry	68	73	-5
12	Aron Price	71	77	-6
13	Charles Howell	71	75	-4
14	Jason Dufner	65	75	-10
15	Mike Weir	68	65	3
16	Carl Pettersson	74	67	7
17	Bo Van Pelt	73	72	1
18	Ernie Els	69	77	-8
19	Cameron Beckman	76	68	8
20	Nick Watney	65	70	-5
21	Tommy Armour III	77	73	4

Suppose you would like to determine if the mean score for thefirst round of an event is significantly different than the meanscore for the final round. Does the pressure of playing in thefinal round cause scores to go up? Or does the increased playerconcentration cause scores to come down?

a. Use a = .10 totest for a statistically significantly difference between thepopulation means for first- and final-round scores. What is thep-value?

p-value is .8904 (to4 decimals)

What is your conclusion?

There is no significant difference between themean scores for the first and final rounds.

b. What is the point estimate of the differencebetween the two population means?

.20 (to 2 decimals)

For which round is the population mean score lower?

Final round

c. What is the margin of error for a 90%confidence interval estimate for the difference between thepopulation means?

?????? (to two decimals)

Could this confidence interval have been used to test thehypothesis in part (a)?

Yes

Explain.

Use the point of the difference between the two population meansand add and subtract this margin of error. If zerois in the interval the difference is notstatistically significant. If zero is not in theinterval the difference is statistically significant.