Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started