The Cincinnati Zoo and Botanical Gardens had a record attendance oflisT million visitors in 2011' (Cincinnati Business Courier website]. Nonprot 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 nonprots to better manage their operations. The le ZooSpend contains sample data on zoo attendance. The file contains the folfowmg data on 125 Visits by families to a zoo: amount spentI 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 : yea, [I = no). Ctick on the datafile logo to reference the data. DATAi a. Develop an estimated regression equation that predicts the amount of money spent by a family given famiky size, whether or not it has a zoo membership, and the distance the family ll'VES from the zoo (to 4 decimals). Enter negative value as negative number. Zoo Spend = _ + _ Number ofFamily Members + , Miles Erom the Zoo + , Membership b. Test the signicance of the zoo membership independent variabie at the 0.05 level. Use the appropriate table from Appendix B. The pvaiue is . Therefore, the zoo membership signicant at the 0.05 revel. c. Test the overall signicance of the model at the 0.05 level. Use the appropriate table from Appendix B. Them... is - Therefore, the equation -Selll:tvnuranmr v significant at the 005 level. (1. Estimate the amount of money spent in a visit by a family of four that lives 125 miles from the zoo and does not have a zoo membership (to 2 decimals). $