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 indicates the amount spent per family, the number of family members, and the distance from the park families live.A) run regression analysis to determine the variable(s) that significantly influence the amount of money families spend at the parks (see below)B)which variable(s) significantly affect(s) house prices? Explain?C) what is the amount of variation that the number of family members and distance from the parks explain?D) is the regression model significant? Explain.E)based on the excel output, what is the regression equation?F) based on the regression equation, estimate the amount of spending a family of 6 that's lives 28 KM from the parks is expected to spend. Show your work Based on the graph below Variable 1 = number of family members Variable 2 = distance from the parks (km)Please let me know if you require more information

A B C D E F G H P SUMMARY OUTPUT N W Regression Statistics Multiple R 0.84098481 5 R Square 0.70725545 6 Adjusted R Sq 0.70245636 7 Standard Erro 26.1482132 8 Observations 125 10 ANOVA 11 df SS MS F Significance F 12 Regression 2 201526.1269 100763.0634 147.372798 2.85639E-33 13 Residual 122 83414.94434 683.7290519 14 Total 124 284941.0712 15 16 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 17 Intercept 1.8136818 6.449536875 0.281211168 0.779024823 10.95382062 14.58118421 -10.95382062 14.58118421 18 X Variable 1 7.75683002 1.082069947 7.168510725 6.33653E-11 5.614764486 9.898895558 5.614764486 9.898895558 19 X Variable 2 0.83818319 0.051981475 16.12465174 5.02997E-32 0.735280665 0.94108571 0.735280665 0.94108571 20 21 22 23