Question: Perform multiple regression to predict Credit Card Balance using all variables except RecordID. (Hint: If needed, you may re-arrange the order of columns.) RecordID Income
Perform multiple regression to predict Credit Card Balance using all variables except RecordID. (Hint: If needed, you may re-arrange the order of columns.)
| RecordID | Income | Age | Credit Card Balance | Education |
| 1 | 64.891 | 34 | 770 | 11 |
| 2 | 136.025 | 82 | 1250 | 15 |
| 3 | 104.593 | 71 | 580 | 12 |
| 4 | 78.924 | 36 | 964 | 11 |
| 5 | 85.882 | 55 | 331 | 16 |
| 6 | 180.18 | 77 | 1151 | 7 |
| 7 | 120.996 | 37 | 1203 | 8 |
| 8 | 91.408 | 60 | 872 | 9 |
| 9 | 85.125 | 66 | 500 | 11 |
| 10 | 101.061 | 41 | 1350 | 10 |
| 11 | 120.77 | 30 | 1407 | 9 |
| 12 | 65.045 | 71 | 900 | 16 |
| 13 | 80.616 | 57 | 1350 | 8 |
| 14 | 112.03 | 49 | 1081 | 9 |
| 15 | 109.144 | 75 | 148 | 13 |
| 16 | 20.089 | 57 | 750 | 8 |
| 17 | 93.598 | 73 | 200 | 9 |
| 18 | 36.496 | 69 | 368 | 8 |
| 19 | 41.57 | 28 | 891 | 9 |
| 20 | 42.079 | 44 | 1048 | 9 |
Answer the following questions:
Q1: What is your adjusted R squared value? Does the model fit the data well? Please explain your reason.
Q2. Write out your final regression equation
Q3: What is the most influential variable?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
