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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!