The dataset Golfers2008.xlsx saved in Datasets inBlackboard contains data on the top 40 golfers in 2008.This was the year when Tiger Woods won the U.S. Open in June andthen had year-ending surgery.

Using all the explanatory variables, run a regression predictingEarnings per Round.

Determine the best fit model by removing any insignificantx-variables.   Rerun the analysis with your best fitmodel. Make a clear notation of which model is yourbest-fit model by labeling the worksheet of that model “BEST FITMODEL”.

Age	Events	Rounds	Cuts Made	Top 10s	Wins	Earnings per Round
45	23	82	18	8	3	$80,501
32	6	23	6	6	4	$251,087
37	21	79	20	8	2	$65,682
28	19	70	18	6	1	$69,403
47	26	97	24	7	3	$48,080
22	22	81	19	8	2	$57,485
26	22	78	19	7	2	$56,701
36	15	51	12	6	2	$84,579
35	23	85	19	7	1	$46,815
35	25	96	24	8	1	$41,079
36	28	108	27	9	0	$33,395
38	26	94	23	9	0	$36,763
31	25	81	16	5	1	$37,400
38	26	88	20	8	0	$34,320
31	20	64	14	6	1	$45,002
38	21	72	16	5	1	$37,270
31	22	80	18	5	0	$32,697
43	26	98	22	6	0	$26,340
28	22	70	14	3	1	$36,660
38	16	50	11	5	1	$50,746
30	29	110	25	5	1	$22,841
37	23	84	21	7	0	$29,579
41	22	74	16	6	0	$32,950
34	28	95	19	7	0	$25,313
34	24	83	19	5	1	$28,901
27	27	94	21	4	1	$24,515
44	24	83	19	7	0	$27,539
39	33	116	24	5	0	$19,301
39	22	74	15	6	0	$29,984
26	27	87	18	5	0	$25,389
36	31	103	20	6	1	$21,413
26	26	86	19	3	1	$25,188
44	30	107	24	6	0	$20,060
28	32	119	27	6	0	$17,599
25	25	82	16	3	1	$25,486
27	20	67	15	3	1	$30,815
36	30	114	26	3	0	$17,893
29	28	89	16	3	0	$22,465
27	15	50	12	3	1	$39,583
34	27	91	18	5	0	$21,648