The Miami-Dade Zoological Park and Gardens had a record attendance of 1.87 million visitors in 2019. Nonprofit organizations such as zoos and museums are becoming more sophisticated in their use of data to improve the customer experience. Being able to better estimate expected revenue is one use of analytics that allows nonprofits to better manage their operations.

The file Zoo contains sample data on zoo attendance. The file contains the following data on 125 visits by families to the zoo: amount spent, size of the family, the distance the family lives from the zoo (the gate attendee asks for the zip code of each family entering the zoo), and whether or not the family has a zoo membership (1 = yes, 0 = no).

a)Develop an estimated regression equation that predicts the amount of money spent by a family given family size, whether or not it has a zoo membership, and the distance the family lives from the zoo.

b)Test the significance of the zoo membership independent variable at the .05 level. What do you conclude?

c)Give an explanation/interpretation for the sign of the estimate you tested inpart (b)

d)Test the overall significance of the model at the .05 level. What do you conclude?

e)Estimate the amount of money spent in a visit by a family of five that lives 125 miles from the zoo and does not have a zoo membership

Link for gretl file:https://drive.google.com/file/d/1H7dILZPAUDHpjYL0P8frzdzCtUR268Ui/view?usp=sharing