3. Predicting Software Reselling Profits: Magical Software is a software catalog firm that sells games and educational software. It started out as a software manufacturer, and added third party titles to its offerings. It has recently put together a revised collection of items in a new catalog, which it mailed out to its customers. This mailing yielded 1000 purchases. Based on these data, Magical wants to devise a model for predicting the spending amount that a purchasing customer will yield. The file Magical Software.xlsx contains the following information on 1000 purchases: a. Write the regression model. b. Interpret the multiple coefficient of determination. c. Refer your ANOVA Table. Is the model significant? Explain. Show both null and alternate hypothesis. d. Among the independent variables, which variables are significant? Interpret any two significant independent variables. e. Compute the mean spending amount for the customer with following characteristics: US Address Frequency Last Update Web Order Gender Address Res 1 1 3342 No Male No f. Based on this model, what type of purchaser is most likely to spend a large amount of money? Interpret. g. Did you observe any significant multicollinearity? Comment. [Hint: VIF]