"AVEFEE","CART","COURSE","DISTANCE","FEE","FEESUB","MGS","MONTH","RAIN","RANGE","RATING","ROUNDS","SLOPE","TEMP","WINTER","YARD" XXXXXXXXXX,1,1,66.1,14.08,...

1 answer below »
attached is the prompt and data


"AVEFEE","CART","COURSE","DISTANCE","FEE","FEESUB","MGS","MONTH","RAIN","RANGE","RATING","ROUNDS","SLOPE","TEMP","WINTER","YARD" 17.9813636363636,1,1,66.1,14.08,18.1671428571429,0,1,7.15,1,73.1,582,132,46.9,1,3428 17.9977272727273,1,1,66.1,13.3,18.2214285714286,0,2,3.31,1,73.1,1150,132,51.2,1,3428 18.7263636363636,1,1,66.1,17.23,18.797619047619,0,3,3.96,1,73.1,2229,132,53.2,0,3428 19.8340909090909,1,1,66.1,20.04,19.8242857142857,0,4,0.99,1,73.1,3844,132,58.5,0,3428 21.525,1,1,66.1,22.22,21.4919047619048,0,5,1.98,1,73.1,5863,132,61.3,0,3428 21.4554545454545,1,1,66.1,23.51,21.357619047619,0,6,1.11,1,73.1,6630,132,68,0,3428 21.17,1,1,66.1,23.98,21.0361904761905,0,7,0.41,1,73.1,7520,132,77.4,0,3428 21.5659090909091,1,1,66.1,25.6,21.3738095238095,0,8,0.35,1,73.1,7752,132,77.3,0,3428 21.4872727272727,1,1,66.1,25.67,21.2880952380952,0,9,0.72,1,73.1,6153,132,73.1,0,3428 19.3309090909091,1,1,66.1,18.95,19.3490476190476,0,10,3.48,1,73.1,2000,132,59.4,0,3428 18.6868181818182,1,1,66.1,13.52,18.9328571428571,0,11,11.62,1,73.1,851,132,50.9,1,3428 17.9322727272727,1,1,66.1,12.42,18.1947619047619,0,12,8.98,1,73.1,602,132,44.2,1,3428 17.9813636363636,1,2,6.6,19.42,17.9128571428571,0,1,7.15,1,66.5,2006,110,46.9,1,5535 17.9977272727273,1,2,6.6,19.75,17.9142857142857,0,2,3.31,1,66.5,3455,110,51.2,1,5535 18.7263636363636,1,2,6.6,20.04,18.6638095238095,0,3,3.96,1,66.5,4333,110,53.2,0,5535 19.8340909090909,1,2,6.6,19.44,19.8528571428571,0,4,0.99,1,66.5,7645,110,58.5,0,5535 21.525,1,2,6.6,20.28,21.5842857142857,0,5,1.98,1,66.5,8365,110,61.3,0,5535 21.4554545454545,1,2,6.6,19.78,21.5352380952381,0,6,1.11,1,66.5,8600,110,68,0,5535 21.17,1,2,6.6,19.55,21.2471428571429,0,7,0.41,1,66.5,8990,110,77.4,0,5535 21.5659090909091,1,2,6.6,19.31,21.6733333333333,0,8,0.35,1,66.5,9851,110,77.3,0,5535 21.4872727272727,1,2,6.6,19.6,21.5771428571429,0,9,0.72,1,66.5,7754,110,73.1,0,5535 19.3309090909091,1,2,6.6,19.62,19.3171428571429,0,10,3.48,1,66.5,5044,110,59.4,0,5535 18.6868181818182,1,2,6.6,20.38,18.6061904761905,0,11,11.62,1,66.5,2450,110,50.9,1,5535 17.9322727272727,1,2,6.6,19.16,17.8738095238095,0,12,8.98,1,66.5,1431,110,44.2,1,5535 17.9813636363636,0,3,19.1,11.07,18.3104761904762,0,1,7.15,1,67.7,247,111,46.9,1,6019 17.9977272727273,0,3,19.1,11.65,18.3,0,2,3.31,1,67.7,472,111,51.2,1,6019 18.7263636363636,0,3,19.1,13.07,18.9957142857143,0,3,3.96,1,67.7,1201,111,53.2,0,6019 19.8340909090909,0,3,19.1,14.96,20.0661904761905,0,4,0.99,1,67.7,3055,111,58.5,0,6019 21.525,0,3,19.1,16.26,21.7757142857143,0,5,1.98,1,67.7,3937,111,61.3,0,6019 21.4554545454545,0,3,19.1,15.8,21.7247619047619,0,6,1.11,1,67.7,5698,111,68,0,6019 21.17,0,3,19.1,14.39,21.4928571428571,0,7,0.41,1,67.7,7438,111,77.4,0,6019 21.5659090909091,0,3,19.1,15.5,21.8547619047619,0,8,0.35,1,67.7,7418,111,77.3,0,6019 21.4872727272727,0,3,19.1,17.14,21.6942857142857,0,9,0.72,1,67.7,4375,111,73.1,0,6019 19.3309090909091,0,3,19.1,11.66,19.6961904761905,0,10,3.48,1,67.7,2230,111,59.4,0,6019 18.6868181818182,0,3,19.1,10.5,19.0766666666667,0,11,11.62,1,67.7,524,111,50.9,1,6019 17.9322727272727,0,3,19.1,11.07,18.2590476190476,0,12,8.98,1,67.7,159,111,44.2,1,6019 17.9813636363636,1,4,63,19.27,17.92,0,1,7.15,1,71.9,2022,120,46.9,1,6708 17.9977272727273,1,4,63,18.63,17.967619047619,0,2,3.31,1,71.9,2366,120,51.2,1,6708 18.7263636363636,1,4,63,17.53,18.7833333333333,0,3,3.96,1,71.9,4135,120,53.2,0,6708 19.8340909090909,1,4,63,17.72,19.9347619047619,0,4,0.99,1,71.9,6309,120,58.5,0,6708 21.525,1,4,63,18.81,21.6542857142857,0,5,1.98,1,71.9,6943,120,61.3,0,6708 21.4554545454545,1,4,63,18.43,21.5995238095238,0,6,1.11,1,71.9,7379,120,68,0,6708 21.17,1,4,63,17.93,21.3242857142857,0,7,0.41,1,71.9,8363,120,77.4,0,6708 21.5659090909091,1,4,63,18.63,21.7057142857143,0,8,0.35,1,71.9,8441,120,77.3,0,6708 21.4872727272727,1,4,63,18.89,21.6109523809524,0,9,0.72,1,71.9,6255,120,73.1,0,6708 19.3309090909091,1,4,63,17.33,19.4261904761905,0,10,3.48,1,71.9,4187,120,59.4,0,6708 18.6868181818182,1,4,63,17.76,18.7309523809524,0,11,11.62,1,71.9,1903,120,50.9,1,6708 17.9322727272727,1,4,63,15.48,18.0490476190476,0,12,8.98,1,71.9,1162,120,44.2,1,6708 17.9813636363636,1,5,18.9,21.82,17.7985714285714,0,1,7.15,1,69.4,896,132,46.9,1,6123 17.9977272727273,1,5,18.9,19.52,17.9252380952381,0,2,3.31,1,69.4,1897,132,51.2,1,6123 18.7263636363636,1,5,18.9,21.01,18.617619047619,0,3,3.96,1,69.4,2727,132,53.2,0,6123 19.8340909090909,1,5,18.9,22.98,19.6842857142857,0,4,0.99,1,69.4,3929,132,58.5,0,6123 21.525,1,5,18.9,29.41,21.1495238095238,0,5,1.98,1,69.4,4612,132,61.3,0,6123 21.4554545454545,1,5,18.9,27.07,21.1880952380952,0,6,1.11,1,69.4,5854,132,68,0,6123 21.17,1,5,18.9,28.91,20.8014285714286,0,7,0.41,1,69.4,6929,132,77.4,0,6123 21.5659090909091,1,5,18.9,32.08,21.0652380952381,0,8,0.35,1,69.4,6699,132,77.3,0,6123 21.4872727272727,1,5,18.9,31.76,20.9980952380952,0,9,0.72,1,69.4,5240,132,73.1,0,6123 19.3309090909091,1,5,18.9,28.43,18.897619047619,0,10,3.48,1,69.4,2966,132,59.4,0,6123 18.6868181818182,1,5,18.9,20.34,18.6080952380952,0,11,11.62,1,69.4,1371,132,50.9,1,6123 17.9322727272727,1,5,18.9,24.93,17.5990476190476,0,12,8.98,1,69.4,669,132,44.2,1,6123 17.9813636363636,1,6,11.7,16.58,18.0480952380952,0,1,7.15,0,62.3,1128,94,46.9,1,4930 17.9977272727273,1,6,11.7,16.71,18.0590476190476,0,2,3.31,0,62.3,1802,94,51.2,1,4930 18.7263636363636,1,6,11.7,16.63,18.8261904761905,0,3,3.96,0,62.3,3234,94,53.2,0,4930 19.8340909090909,1,6,11.7,15.96,20.0185714285714,0,4,0.99,0,62.3,7646,94,58.5,0,4930 21.525,1,6,11.7,16.4,21.7690476190476,0,5,1.98,0,62.3,8141,94,61.3,0,4930 21.4554545454545,1,6,11.7,16.09,21.7109523809524,0,6,1.11,0,62.3,9300,94,68,0,4930 21.17,1,6,11.7,16.12,21.4104761904762,0,7,0.41,0,62.3,10128,94,77.4,0,4930 21.5659090909091,1,6,11.7,16.23,21.82,0,8,0.35,0,62.3,10189,94,77.3,0,4930 21.4872727272727,1,6,11.7,16.31,21.7338095238095,0,9,0.72,0,62.3,7927,94,73.1,0,4930 19.3309090909091,1,6,11.7,16.51,19.4652380952381,0,10,3.48,0,62.3,4281,94,59.4,0,4930 18.6868181818182,1,6,11.7,16.6,18.7861904761905,0,11,11.62,0,62.3,1749,94,50.9,1,4930 17.9322727272727,1,6,11.7,16.03,18.0228571428571,0,12,8.98,0,62.3,655,94,44.2,1,4930 17.9813636363636,1,7,51.7,11.74,18.2785714285714,0,1,7.15,1,69.8,939,129,46.9,1,6010 17.9977272727273,1,7,51.7,11.39,18.312380952381,0,2,3.31,1,69.8,2103,129,51.2,1,6010 18.7263636363636,1,7,51.7,9.08,19.1857142857143,0,3,3.96,1,69.8,2784,129,53.2,0,6010 19.8340909090909,1,7,51.7,12.32,20.1919047619048,0,4,0.99,1,69.8,3946,129,58.5,0,6010 21.525,1,7,51.7,14.46,21.8614285714286,0,5,1.98,1,69.8,4085,129,61.3,0,6010 21.4554545454545,1,7,51.7,15.72,21.7285714285714,0,6,1.11,1,69.8,4502,129,68,0,6010 21.17,1,7,51.7,15.06,21.4609523809524,0,7,0.41,1,69.8,5689,129,77.4,0,6010 21.5659090909091,1,7,51.7,15.22,21.8680952380952,0,8,0.35,1,69.8,6134,129,77.3,0,6010 21.4872727272727,1,7,51.7,15.48,21.7733333333333,0,9,0.72,1,69.8,4448,129,73.1,0,6010 19.3309090909091,1,7,51.7,7.92,19.8742857142857,0,10,3.48,1,69.8,2777,129,59.4,0,6010 18.6868181818182,1,7,51.7,11.11,19.047619047619,0,11,11.62,1,69.8,1277,129,50.9,1,6010 17.9322727272727,1,7,51.7,12.09,18.2104761904762,0,12,8.98,1,69.8,605,129,44.2,1,6010 17.9813636363636,1,8,23.3,24.84,17.6547619047619,0,1,7.15,1,72.9,1111,137,46.9,1,6862 17.9977272727273,1,8,23.3,25.87,17.6228571428571,0,2,3.31,1,72.9,1925,137,51.2,1,6862 18.7263636363636,1,8,23.3,26.3,18.3657142857143,0,3,3.96,1,72.9,2992,137,53.2,0,6862 19.8340909090909
Answered Same DayJun 01, 2021

Answer To: "AVEFEE","CART","COURSE","DISTANCE","FEE","FEESUB","MGS","MONTH","RAIN","RANGE","RATING","ROUNDS","S...

Himanshu answered on Jun 02 2021
154 Votes
The current problem considers the dependent function as ‘ROUNDS’ which represents the total number of paid rounds of golf played at a specific course in a given month. In order to estimate the value of the dependent variable, we consider it to be impacted by the average price charged by a particular course (FEE), the average fee charged by other 21 courses (FEESUB), the difficulty level of the course for good golfers (RATING), difficulty level of the course for mediocre golfers (SLOPE), the average temperature (TEMP), the winter season (WINTER), and distance to the course in miles (DISTANCE). The regression is run using “lm” function. The results are provided in the screenshot below.
We observe that ‘FEESUB’ (680.97, p=0.00), ‘RATING’ (205.05, p=0.00), and ‘TEMP’ (104.74, p=0.00) have significant positive association with ‘ROUNDS’. The other variables like ‘SLOPE’ (-54.54, p=0.00), ‘WINTER’ (-953.25, p=0.00) and ‘DISTANCE’ (-27.92, p=0.00) have significant negative impact. However, ‘FEE’ is not significant. The overall regression model is also significant with...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here