Business Analytics (Predictive analytics)

For this assignment, you will use the data shown in the textbook case in Chapter 7 (page 369-371). Instead of answering the questions posed by the textbook, complete the work described below.

Instructions: Answer the following questions in a short document (document details shown in Submission Instructions below):

1. Generally, what does the data tell you about alumni giving rate (the response variable)?

2. Develop the best linear regression model that you can to predict alumni giving rate (Ignore and do not use the State column). 

3. Using your model, what could you recommend to a university that was seeking to increase its alumni giving rate?

Submission Instructions: Your deliverable for this assignment is a short document (2 pages or less) prepared in Word (or similar software) and submitted as a Word document or PDF. Please submit only your document. No supporting Excel sheets or other work needs to be submitted.

Your document should answer the questions posed above and provide appropriate commentary to support your answers.