A B C D E F G H K L M N Q4 12 Marks The "Multinational Parks" is interested in determining the variables that influence the amount of money families spend at their parks. The "ParkSpend" table to the right indicate the amount spent per family, the number of family members, and the distance from the park families live. a) Run regression analysis using Excel to determine the variable(s) that significantly influence the amount of money families spend at the parks. Note: use a 95% confidence level. 2 Marks b) Which variable(s) significantly affect(s) spending at parks? Explain. 2 Marks c) What is the amount of variation that the number of family members and distance from the parks? Explain. 2 Marks d) Is the regression model significant? Explain. 2 Marks e) Based on the Excel output, what is the regression equation? 2 Marks f) Based on the regression equiation, estimate the amount of spending a family of 6 that lives 28 kilometres from the parks is expected to spend. Show your work. 2 MarksO P Q rks ParkSpend Spend ($) Number of Family members Distance from the Parks (KM) 38.39 20 31.04 34 51.45 11 107.19 61 144.24 119 72.54 28 36.13 41 100.09 85 151.96 148 82.3 13 201.18 134 91.74 70 56.66 4 56.69 50 19.9 59 99.32 34 62.82 28 25.74 5 94.84 43 132.31 132 J J O J A O A - - N A J O J N J A DO J A A A UI W J UI W H A UI J O O O N W W W a VIA 86.52 96 25.33 20 17.2 9 158.95 108 64.97 38 152.15 73 130.47 143 161.04 107 27.41 9 165.2 130 13.15 24 75 3 50.7 82 64.63 40 44.94 6 93.02 59 45.62 42 84.72 26 53.52 14 169.76 134 62.07 45