Using the donations database on the companion site, and using only people who made a donation in response to the current mailing, consider predicting the amount of a donation (named “Donation_D1” in the worksheet) from the indicator variable that tells if the person is a catalog shopper (“CatalogShopper_D1”), the indicator variable that tells whether or not the person has a published home phone number (“HomePhone_D1”), and the number of recent gifts made (“RecentGifts_D1”).
a. Find the regression equation and the coefficient of determination.
b. Is there a significant relationship overall?
c. Which, if any, of the explanatory variables has a significant t test? What does this tell you?