Player Scoring Average DrDist DrAccu GIR Sand Saves PPR Bader, Beth 74 160 247 280 72 9 61 35 7 30 76 Beck, Karlin 75 333 252 121 68 1 65 23 5 31 88 Blumenherst, Amanda 74 108 250 737 58 9 65 45 1 31 47 Boeljon, Christel 73 466 247 000 70 7 62 42 9 30 04 Bowie Young, Heather 73 174 251 565 73 6 67 34 30 96 Bunch, Ashli 75 895 247 368 62 6 56 38 1 31 26 Carter, Dori 73 282 254 282 70 1 65 46 30 74 Castrale, Nicole 72 415 247 585 71 8 68 46 3 30 37 Changkija, Sandra 73 743 263 286 67 7 65 32 5 31 00 Cho, Irene 73 622 249 676 60 2 62 36 6 29 92 Choi, Chella 71 634 246 317 74 7 71 37 9 30 13 Choi, Na Yeon 70 488 254 070 74 9 73 45 6 29 50 Clanton, Cydney 75 000 263 649 60 1 65 37 5 32 14 Concolino, Jacqui 73 176 248 971 67 7 65 53 5 30 68 Coutu, Taylor 72 233 239 571 73 3 64 49 29 07 Creamer, Paula 70 952 245 257 79 73 56 9 30 01 Davies, Laura 74 071 257 697 54 7 58 41 7 30 03 Dergal, Tanya 76 278 232 857 65 1 53 32 1 30 56 Diaz, Laura 73 436 239 256 57 1 61 39 6 30 21 Doolan, Wendy 74 519 262 556 69 66 44 8 31 52 Duncan, Meredith 74 379 224 517 79 6 56 34 1 29 66 Dunn, Moira 72 514 252 800 73 2 67 48 1 30 26 Ekey, Kathleen 74 629 246 118 69 3 61 21 7 31 17 Ewart, Jodi 72 725 258 304 71 2 68 40 3 30 60 Felibert, Veronica 74 351 257 919 69 3 67 44 8 32 18 Feng, Shanshan 70 841 256 344 76 8 73 39 1 30 16 Ferrero, Lisa 74 667 258 139 62 6 66 29 3 31 94 Francella, Meaghan 74 368 237 395 77 2 63 37 30 71 Futcher, Katie 72 868 246 364 69 1 65 36 5 30 25 Gal, Sandra 71 802 259 783 66 3 67 42 29 86 Granada, Julieta 71 965 240 711 76 8 66 50 8 29 46 Grzebien, Anna 74 556 254 037 71 8 66 36 32 19 Gulbis, Natalie 72 271 251 311 73 9 71 42 4 30 20 Gulyanamitta, Numa 73 723 244 047 71 1 61 47 6 30 12 Gustafson, Sophie 73 279 263 050 67 1 66 44 9 30 65 Han, Hee Won 72 571 247 595 71 1 69 47 1 30 09 Harigae, Mina 72 333 249 408 72 7 68 46 4 30 26 Hart, Marcy 73 030 234 879 82 7 66 37 8 30 73 Hedwall, Caroline 72 268 252 333 69 3 70 32 1 30 49 Hernandez, Maria 73 706 243 758 75 8 68 48 31 74 Hjorth, Maria 73 559 266 961 61 2 67 39 30 87 Hull Kirk, Katherine 72 437 253 382 70 67 39 4 29 79 Hung, Amy 74 679 242 233 65 4 59 52 6 30 44 Hur, Mi Jung 72 286 262 159 58 2 65 59 7 29 16 Hurst, Pat 74 400 248 862 59 7 59 35 6 30 00 Hurst, Vicky 72 952 262 622 65 67 34 8 30 42 Icher, Karine 71 104 246 676 73 4 72 46 7 30 11 Jang, Jeong 72 813 240 719 74 8 59 37 5 28 58 Ji, Eun Hee 72 684 241 507 76 6 69 46 3 30 42 Joh, Tiffany 74 093 240 239 63 64 42 2 30 83 Johnson, Jennifer 72 064 247 865 76 8 68 38 3 30 15 Kane, Lorie 73 296 250 741 69 1 64 40 6 30 44 Kaneko, Ayaka 74 211 243 459 69 2 62 38 5 30 95 Kang, Danielle 72 393 246 934 73 6 66 40 5 29 96 Kang, Haeji 71 537 254 638 68 4 67 41 5 29 11 Kang, Jimin 73 754 243 979 72 66 48 1 31 07 Kemp, Sarah 74 679 240 679 62 4 58 40 5 30 32 Kerr, Cristie 71 272 258 563 74 6 71 37 8 29 93 Kim, Christina 74 019 237 341 78 63 36 4 30 68 Kim, I K 71 306 241 984 75 6 70 51 8 29 65 Kim, Mindy 73 035 249 854 72 8 69 37 5 30 80 Kim, Song Hee 76 864 251 235 46 2 48 24 1 29 35 Kono, Stephanie 76 964 232 464 59 7 49 35 8 30 46 Korda, Jessica 72 938 262 785 65 69 34 9 30 96 Kung, Candie 72 134 242 417 76 2 70 50 8 30 07 LaCrosse, Cindy 72 900 246 338 75 6 66 39 3 30 23 Lang, Brittany 71 589 261 939 68 3 72 51 4 30 32 Lee, Ilhee 72 384 243 219 74 65 52 2 30 03 Lee, Jee Young 72 350 260 475 63 1 66 52 1 30 08 Lee, Jennie 74 019 243 887 68 62 42 6 30 08 Lee, Meena 72 239 233 900 77 9 66 44 6 29 51 Lee Bentham, Rebecca 74 250 245 139 71 7 59 34 6 30 33 Lewis, Amelia 73 783 252 696 72 3 62 22 2 30 61 Lewis, Stacy 70 333 260 036 74 8 75 41 5 29 78 Lincicome, Brittany 71 525 276 083 64 71 53 5 30 28 Lindberg, Pernilla 72 600 252 018 66 8 65 40 4 29 47 Lindley, Leta 73 056 219 944 82 4 58 66 7 29 19 Louden, Stephanie 73 861 231 361 77 9 60 39 3 29 97 Mackenzie, Paige 73 525 254 078 72 65 46 30 68 Martin, Mo 72 943 230 765 83 9 65 34 30 35 Matthew, Catriona 71 088 255 603 69 2 70 44 9 29 66 McPherson, Kristy 73 551 243 115 73 2 66 19 7 31 21 Michaels, Sydnee 72 484 259 983 64 8 67 48 29 84 Min, Na On 74 636 243 091 61 9 63 46 3 31 33 Miyazato, Ai 70 564 242 881 79 3 68 50 28 68 Miyazato, Mika 70 939 240 679 84 8 72 26 5 29 69 Moodie, Janice 74 000 248 389 67 7 68 34 2 31 78 Morgan, Becky 73 266 239 613 72 4 65 43 5 30 38 Mozo, Belen 72 643 251 894 71 4 65 42 3 30 23 Munoz, Azahara 70 898 255 663 70 5 74 47 2 29 76 Nordqvist, Anna 71 189 248 448 72 9 72 43 5 29 95 Oh, Angela 74 375 241 450 71 9 59 33 3 30 05 Oh, Ji Young 73 250 239 295 77 65 41 3 31 09 O'Toole, Ryann 74 302 254 814 64 3 64 27 6 30 93 Pak, Jin Young 73 395 249 256 62 2 59 38 3 29 40 Pak, Se Ri 71 184 259 500 62 5 70 53 3 29 44 Park, Hee Young 71 706 256 189 69 4 70 45 1 30 13 Park, Inbee 70 212 254 840 73 4 69 45 9 28 34 Park, Jane 73 349 242 366 74 66 34 4 31 00 Pettersen, Suzann 70 744 265 385 71 73 52 9 30 30 Phatlum, Pornanong 72 429 247 197 74 2 66 44 3 30 24 Piller, Gerina 72 560 268 932 64 1 66 37 3 30 36 Prammanasudh, Stacy 73 680 244 840 65 9 62 48 6 30 16 Pressel, Morgan 73 647 242 119 69 7 60 58 28 43 Rah, Jane 74 171 238 900 80 5 61 52 5 30 51 Rankin, Reilley 73 067 243 111 75 7 65 36 4 30 51 Recari, Beatriz 71 687 244 191 80 1 73 38 6 30 51 Richdale, Samantha 73 583 246 917 74 4 65 18 2 30 83 Rosales, Jennifer 72 171 248 756 74 2 69 30 8 30 49 Ryu, So Yeon 70 302 258 200 73 3 72 39 7 29 25 Salas, Lizette 71 719 249 953 74 9 70 35 7 29 77 Schreefel, Dewi Claire 72 972 251 646 67 65 46 3 29 71 Seo, Hee Kyung 71 571 251 135 72 8 66 54 8 29 25 Sergas, Giulia 72 632 257 567 64 4 67 35 7 30 24 Serramia, Elisa 75 429 247 286 60 8 58 37 8 30 79 Sharp, Alena 72 900 262 900 67 5 65 35 4 30 45 Shepley, Jessica 73 885 249 538 69 2 64 32 30 65 Sherlock, Stephanie 75 217 236 545 73 5 52 40 5 29 48 Shin, Jenny 72 060 243 096 75 4 68 50 9 30 03 Shin, Jiyai 70 308 242 145 83 5 74 59 4 29 51 Sjodin, Karin 72 093 264 573 71 3 76 26 3 31 41 Smith, Sarah Jane 72 772 253 491 66 8 66 28 8 30 47 Song, Christine 74 605 231 919 75 6 60 37 30 79 Song, Jennifer 73 188 243 750 71 8 64 45 5 29 91 Stanford, Angela 71 506 255 141 72 9 70 31 6 29 78 Stupples, Karen 73 017 257 898 64 3 67 29 8 30 57 Tamulis, Kris 73 043 250 413 69 4 67 31 9 30 53 Tanco, Victoria 73 897 245 026 49 9 59 45 9 30 00 Thompson, Lexi 71 568 271 973 69 2 73 45 3 30 98 Tseng, Yani 71 122 266 986 58 5 69 41 7 29 53 Ueda, Momoko 71 850 246 392 72 8 67 43 6 30 00 Uribe, Mariajo 72 034 258 814 69 7 68 46 3 30 06 Walshe, Alison 72 592 258 282 63 8 67 44 3 30 15 Ward, Wendy 73 271 248 500 67 7 67 43 2 31 05 Webb, Karrie 71 192 259 000 73 8 72 38 9 30 18 Wie, Michelle 73 485 268 589 53 66 39 7 31 16 Wright, Lindsey 72 211 241 909 76 5 66 57 9 29 75 Yang, Amy 71 040 258 046 69 71 42 9 29 71 Yoo, Sun Young 71 659 256 667 74 2 75 53 6 30 98 Yun, Hannah 73 829 252 324 67 5 61 41 1 30 26 The Ladies Professional Golf Association (LPGA) maintains data on performance for members of the LPGA Tour Scoring average is generally considered the most important statistic in term of a player's success To investigate the relationship between scoring average and variables such as driving distance, driving accuracy, greens in regulation, sand saves, and average putts per round, year end performance data for 140 players on the LPGA Tour for 2012 are contained in the DATAfile named TourLPGA2012 (LPGA website) Each row of the data set corresponds to a LPGA Tour player Descriptions for the variables in the data set follow Scoring Average The average number of strokes per completed round DrDist (Driving Distance) The average number of yards per measured drive On the LPGA Tour driving distance is measured on two holes per round Care is taken to select two holes which face in opposite directions to counteract the effect of wind Drives are measured to the point at which they come to rest regardless of whether they are in the fairway or not DrAccu (Driving Accuracy) The percentage of time a tee shot comes to rest in the fairway (regardless of club) Driving accuracy is measured on every hole, excluding par 3s GIR (Greens in Regulation) The percentage of time a player was able to hit the green in regulation A green is considered hit in regulation if any portion of the ball is touching the putting surface after the GIR stroke has been taken The GIR stroke is determined by subtracting 2 from par (1st stroke on a par 3, 2nd on a par 4, 3rd on a par 5) In other words, a green is considered hit in regulation if the player has reached the putting surface in par minus two strokes Sand Saves The percentage of time a player was able to get up and down once in a greenside sand bunker (regardless of score) Up and down indicates it took the player 2 shots or less to put the ball in the hole from a greenside sand bunker PPR (Putts per Round) The average number of putts per round Suppose that you have been hired by the commissioner of the LPGA to analyze the data for a presentation to be made at the annual LPGA Tour meeting The commissioner has asked whether it would be possible to use these data to determine the performance measures that are the best predictors of a player's average score Write the key statistical results, conclusions, and recommendations Please include the excel file and the procedures

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on May 13, 2024

Player Scoring Average DrDist DrAccu GIR Sand Saves PPR Bader, Beth 74.160 247.280 72.9 61 35.7 30.76 Beck, Karlin 75.333 252.121 68.1 65 23.5 31.88


Player	Scoring Average	DrDist	DrAccu	GIR	Sand Saves	PPR
Bader, Beth	74.160	247.280	72.9	61	35.7	30.76
Beck, Karlin	75.333	252.121	68.1	65	23.5	31.88
Blumenherst, Amanda	74.108	250.737	58.9	65	45.1	31.47
Boeljon, Christel	73.466	247.000	70.7	62	42.9	30.04
Bowie Young, Heather	73.174	251.565	73.6	67	34	30.96
Bunch, Ashli	75.895	247.368	62.6	56	38.1	31.26
Carter, Dori	73.282	254.282	70.1	65	46	30.74
Castrale, Nicole	72.415	247.585	71.8	68	46.3	30.37
Changkija, Sandra	73.743	263.286	67.7	65	32.5	31.00
Cho, Irene	73.622	249.676	60.2	62	36.6	29.92
Choi, Chella	71.634	246.317	74.7	71	37.9	30.13
Choi, Na Yeon	70.488	254.070	74.9	73	45.6	29.50
Clanton, Cydney	75.000	263.649	60.1	65	37.5	32.14
Concolino, Jacqui	73.176	248.971	67.7	65	53.5	30.68
Coutu, Taylor	72.233	239.571	73.3	64	49	29.07
Creamer, Paula	70.952	245.257	79	73	56.9	30.01
Davies, Laura	74.071	257.697	54.7	58	41.7	30.03
Dergal, Tanya	76.278	232.857	65.1	53	32.1	30.56
Diaz, Laura	73.436	239.256	57.1	61	39.6	30.21
Doolan, Wendy	74.519	262.556	69	66	44.8	31.52
Duncan, Meredith	74.379	224.517	79.6	56	34.1	29.66
Dunn, Moira	72.514	252.800	73.2	67	48.1	30.26
Ekey, Kathleen	74.629	246.118	69.3	61	21.7	31.17
Ewart, Jodi	72.725	258.304	71.2	68	40.3	30.60
Felibert, Veronica	74.351	257.919	69.3	67	44.8	32.18
Feng, Shanshan	70.841	256.344	76.8	73	39.1	30.16
Ferrero, Lisa	74.667	258.139	62.6	66	29.3	31.94
Francella, Meaghan	74.368	237.395	77.2	63	37	30.71
Futcher, Katie	72.868	246.364	69.1	65	36.5	30.25
Gal, Sandra	71.802	259.783	66.3	67	42	29.86
Granada, Julieta	71.965	240.711	76.8	66	50.8	29.46
Grzebien, Anna	74.556	254.037	71.8	66	36	32.19
Gulbis, Natalie	72.271	251.311	73.9	71	42.4	30.20
Gulyanamitta, Numa	73.723	244.047	71.1	61	47.6	30.12
Gustafson, Sophie	73.279	263.050	67.1	66	44.9	30.65
Han, Hee-Won	72.571	247.595	71.1	69	47.1	30.09
Harigae, Mina	72.333	249.408	72.7	68	46.4	30.26
Hart, Marcy	73.030	234.879	82.7	66	37.8	30.73
Hedwall, Caroline	72.268	252.333	69.3	70	32.1	30.49
Hernandez, Maria	73.706	243.758	75.8	68	48	31.74
Hjorth, Maria	73.559	266.961	61.2	67	39	30.87
Hull-Kirk, Katherine	72.437	253.382	70	67	39.4	29.79
Hung, Amy	74.679	242.233	65.4	59	52.6	30.44
Hur, Mi Jung	72.286	262.159	58.2	65	59.7	29.16
Hurst, Pat	74.400	248.862	59.7	59	35.6	30.00
Hurst, Vicky	72.952	262.622	65	67	34.8	30.42
Icher, Karine	71.104	246.676	73.4	72	46.7	30.11
Jang, Jeong	72.813	240.719	74.8	59	37.5	28.58
Ji, Eun-Hee	72.684	241.507	76.6	69	46.3	30.42
Joh, Tiffany	74.093	240.239	63	64	42.2	30.83
Johnson, Jennifer	72.064	247.865	76.8	68	38.3	30.15
Kane, Lorie	73.296	250.741	69.1	64	40.6	30.44
Kaneko, Ayaka	74.211	243.459	69.2	62	38.5	30.95
Kang, Danielle	72.393	246.934	73.6	66	40.5	29.96
Kang, Haeji	71.537	254.638	68.4	67	41.5	29.11
Kang, Jimin	73.754	243.979	72	66	48.1	31.07
Kemp, Sarah	74.679	240.679	62.4	58	40.5	30.32
Kerr, Cristie	71.272	258.563	74.6	71	37.8	29.93
Kim, Christina	74.019	237.341	78	63	36.4	30.68
Kim, I.K.	71.306	241.984	75.6	70	51.8	29.65
Kim, Mindy	73.035	249.854	72.8	69	37.5	30.80
Kim, Song-Hee	76.864	251.235	46.2	48	24.1	29.35
Kono, Stephanie	76.964	232.464	59.7	49	35.8	30.46
Korda, Jessica	72.938	262.785	65	69	34.9	30.96
Kung, Candie	72.134	242.417	76.2	70	50.8	30.07
LaCrosse, Cindy	72.900	246.338	75.6	66	39.3	30.23
Lang, Brittany	71.589	261.939	68.3	72	51.4	30.32
Lee, Ilhee	72.384	243.219	74	65	52.2	30.03
Lee, Jee Young	72.350	260.475	63.1	66	52.1	30.08
Lee, Jennie	74.019	243.887	68	62	42.6	30.08
Lee, Meena	72.239	233.900	77.9	66	44.6	29.51
Lee-Bentham, Rebecca	74.250	245.139	71.7	59	34.6	30.33
Lewis, Amelia	73.783	252.696	72.3	62	22.2	30.61
Lewis, Stacy	70.333	260.036	74.8	75	41.5	29.78
Lincicome, Brittany	71.525	276.083	64	71	53.5	30.28
Lindberg, Pernilla	72.600	252.018	66.8	65	40.4	29.47
Lindley, Leta	73.056	219.944	82.4	58	66.7	29.19
Louden, Stephanie	73.861	231.361	77.9	60	39.3	29.97
Mackenzie, Paige	73.525	254.078	72	65	46	30.68
Martin, Mo	72.943	230.765	83.9	65	34	30.35
Matthew, Catriona	71.088	255.603	69.2	70	44.9	29.66
McPherson, Kristy	73.551	243.115	73.2	66	19.7	31.21
Michaels, Sydnee	72.484	259.983	64.8	67	48	29.84
Min, Na On	74.636	243.091	61.9	63	46.3	31.33
Miyazato, Ai	70.564	242.881	79.3	68	50	28.68
Miyazato, Mika	70.939	240.679	84.8	72	26.5	29.69
Moodie, Janice	74.000	248.389	67.7	68	34.2	31.78
Morgan, Becky	73.266	239.613	72.4	65	43.5	30.38
Mozo, Belen	72.643	251.894	71.4	65	42.3	30.23
Munoz, Azahara	70.898	255.663	70.5	74	47.2	29.76
Nordqvist, Anna	71.189	248.448	72.9	72	43.5	29.95
Oh, Angela	74.375	241.450	71.9	59	33.3	30.05
Oh, Ji Young	73.250	239.295	77	65	41.3	31.09
O'Toole, Ryann	74.302	254.814	64.3	64	27.6	30.93
Pak, Jin Young	73.395	249.256	62.2	59	38.3	29.40
Pak, Se Ri	71.184	259.500	62.5	70	53.3	29.44
Park, Hee Young	71.706	256.189	69.4	70	45.1	30.13
Park, Inbee	70.212	254.840	73.4	69	45.9	28.34
Park, Jane	73.349	242.366	74	66	34.4	31.00
Pettersen, Suzann	70.744	265.385	71	73	52.9	30.30
Phatlum, Pornanong	72.429	247.197	74.2	66	44.3	30.24
Piller, Gerina	72.560	268.932	64.1	66	37.3	30.36
Prammanasudh, Stacy	73.680	244.840	65.9	62	48.6	30.16
Pressel, Morgan	73.647	242.119	69.7	60	58	28.43
Rah, Jane	74.171	238.900	80.5	61	52.5	30.51
Rankin, Reilley	73.067	243.111	75.7	65	36.4	30.51
Recari, Beatriz	71.687	244.191	80.1	73	38.6	30.51
Richdale, Samantha	73.583	246.917	74.4	65	18.2	30.83
Rosales, Jennifer	72.171	248.756	74.2	69	30.8	30.49
Ryu, So Yeon	70.302	258.200	73.3	72	39.7	29.25
Salas, Lizette	71.719	249.953	74.9	70	35.7	29.77
Schreefel, Dewi Claire	72.972	251.646	67	65	46.3	29.71
Seo, Hee Kyung	71.571	251.135	72.8	66	54.8	29.25
Sergas, Giulia	72.632	257.567	64.4	67	35.7	30.24
Serramia, Elisa	75.429	247.286	60.8	58	37.8	30.79
Sharp, Alena	72.900	262.900	67.5	65	35.4	30.45
Shepley, Jessica	73.885	249.538	69.2	64	32	30.65
Sherlock, Stephanie	75.217	236.545	73.5	52	40.5	29.48
Shin, Jenny	72.060	243.096	75.4	68	50.9	30.03
Shin, Jiyai	70.308	242.145	83.5	74	59.4	29.51
Sjodin, Karin	72.093	264.573	71.3	76	26.3	31.41
Smith, Sarah Jane	72.772	253.491	66.8	66	28.8	30.47
Song, Christine	74.605	231.919	75.6	60	37	30.79
Song, Jennifer	73.188	243.750	71.8	64	45.5	29.91
Stanford, Angela	71.506	255.141	72.9	70	31.6	29.78
Stupples, Karen	73.017	257.898	64.3	67	29.8	30.57
Tamulis, Kris	73.043	250.413	69.4	67	31.9	30.53
Tanco, Victoria	73.897	245.026	49.9	59	45.9	30.00
Thompson, Lexi	71.568	271.973	69.2	73	45.3	30.98
Tseng, Yani	71.122	266.986	58.5	69	41.7	29.53
Ueda, Momoko	71.850	246.392	72.8	67	43.6	30.00
Uribe, Mariajo	72.034	258.814	69.7	68	46.3	30.06
Walshe, Alison	72.592	258.282	63.8	67	44.3	30.15
Ward, Wendy	73.271	248.500	67.7	67	43.2	31.05
Webb, Karrie	71.192	259.000	73.8	72	38.9	30.18
Wie, Michelle	73.485	268.589	53	66	39.7	31.16
Wright, Lindsey	72.211	241.909	76.5	66	57.9	29.75
Yang, Amy	71.040	258.046	69	71	42.9	29.71
Yoo, Sun Young	71.659	256.667	74.2	75	53.6	30.98
Yun, Hannah	73.829	252.324	67.5	61	41.1	30.26

The Ladies Professional Golf Association (LPGA) maintains data on performance for members of the LPGA Tour. Scoring average is generally considered the most important statistic in term of a player's success. To investigate the relationship between scoring average and variables such as driving distance, driving accuracy, greens in regulation, sand saves, and average putts per round, year-end performance data for 140 players on the LPGA Tour for 2012 are contained in the DATAfile named TourLPGA2012 (LPGA website). Each row of the data set corresponds to a LPGA Tour player. Descriptions for the variables in the data set follow.

Scoring Average The average number of strokes per completed round.

DrDist (Driving Distance) The average number of yards per measured drive. On the LPGA Tour driving distance is measured on two holes per round. Care is taken to select two holes which face in opposite directions to counteract the effect of wind. Drives are measured to the point at which they come to rest regardless of whether they are in the fairway or not.

DrAccu (Driving Accuracy) The percentage of time a tee shot comes to rest in the fairway (regardless of club). Driving accuracy is measured on every hole, excluding par 3s.

GIR (Greens in Regulation) The percentage of time a player was able to hit the green in regulation. A green is considered hit in regulation if any portion of the ball is touching the putting surface after the GIR stroke has been taken. The GIR stroke is determined by subtracting 2 from par (1st stroke on a par 3, 2nd on a par 4, 3rd on a par 5). In other words, a green is considered hit in regulation if the player has reached the putting surface in par minus two strokes.

Sand Saves The percentage of time a player was able to get "up and down" once in a greenside sand bunker (regardless of score). "Up and down" indicates it took the player 2 shots or less to put the ball in the hole from a greenside sand bunker.

PPR (Putts per Round) The average number of putts per round.

Suppose that you have been hired by the commissioner of the LPGA to analyze the data for a presentation to be made at the annual LPGA Tour meeting. The commissioner has asked whether it would be possible to use these data to determine the performance measures that are the best predictors of a player's average score. Write the key statistical results, conclusions, and recommendations.

Please include the excel file and the procedures