Question
Gender is coded as 0 for Female and 1 for Male. Why and what is this called?
Perform a multiple regression analysis using Self Esteem (SE) as the dependent variable (Y) and Age, Months Unemployed, Wage at last job, Social Support, and Financial Hardship as independent variables (X).
What is the Multiple Regression Equation?
What is the Coefficient of Multiple Determination?
City County State Gender Age Months Unemployed Wage at last job
Social support Financial Hardship SE GSE JSSE Boise Ada ID 1 58 26.23 13 38 53 43 34 24 Parma Canyon ID 0 17 3.02 15 47 22 33 36 23 Vale Malhuer Or 0 18 3.25 8 40 44 38 36 27 Reno Washoe NV 0 19 2.36 12 21 37 38 35 18 Ontario Malhuer OR 1 20 2.33 9 50 21 46 45 12 Reno Washoe NV 1 20 0.71 11 41 57 40 44 30 Reno Washoe NV 1 20 2.92 16 50 46 47 45 30 Reno Washoe CA 0 23 0.71 9 50 50 50 45 29 Caldwell Canyon ID 0 24 0.62 22 50 40 50 45 30 Ontario Malhuer OR 0 25 7.29 9 40 46 44 44 27 Reno Washoe NV 0 25 6.83 18 40 52 38 32 28 Boise Ada ID 0 26 2.62 9 45 29 45 37 25 Reno Washoe NV 0 26 3.58 8 38 44 40 36 24 Ontario Malhuer OR 0 27 50.06 10 49 50 39 35 30 Reno Wahoe VN 0 27 4.73 11 39 55 43 40 27 Kuna Ada Id 1 27 26.75 16 21 59 25 26 16 Reno Washoe NV 1 29 59.30 10 46 47 32 32 21 Nampa Canyon ID 1 29 3.11 12 20 70 27 24 17 Nyssa Malhuer Or 1 30 3.28 8 27 42 45 42 29 Ontario Malhuer Or 0 30 2.46 23 34 45 29 33 22 Reno Washoe NV 1 30 4.79 20 41 45 41 16 19 Ontario Malhuer OR 1 31 17.32 8 39 41 35 35 19 Reno Washoe NV 0 31 28.86 14 36 48 35 27 17 Reno Washoe NV 0 31 8.31 26 50 44 48 45 29 boise united states id 0 31 7.82 12 27 59 33 45 30 Ontario Malhuer Or 0 32 13.44 24 40 38 40 34 21 Sparks Washoe NV 1 33 5.19 8 48 32 42 39 23 Reno Washoe NV 0 33 23.27 16 25 49 37 33 24 Nyssa Malhuer OR 1 34 0.32 14 46 50 31 26 26 Ontario Malhuer Or 1 35 2.85 14 31 47 36 33 20 Reno Washoe NV 1 36 11.56 14 30 50 30 37 17 boise ada id 0 36 12.98 13 46 42 36 30 20 Reno Washoe NV 0 37 3.74 11 50 63 50 40 30 Reno Washoe NV 1 37 3.08 15 50 68 13 13 30 Meridian Ada ID 0 38 12.65 15 47 34 48 36 25 Reno Washoe NV 0 38 17.91 12 32 51 31 26 19 Ontario Malhuer OR 0 39 2.13 9 32 53 35 29 25 Reno Wahoe NV 1 39 4.56 24 41 41 41 33 22 Sparks Washoe NV 1 41 2.26 9 50 66 50 38 23 Reno Washoe NV 0 41 6.27 8 33 46 38 34 13 Boise Ada ID 1 41 9.30 9 37 51 41 27 20 Parma Canyon ID 1 43 0.75 30 47 31 40 40 28 Sparks Washoe NV 1 44 3.81 15 39 35 31 24 25 nampa canyon id 1 44 11.60 9 49 51 44 43 25 Vale Malhuer Or 1 45 1.96 9 42 43 38 36 27 Reno Washoe NV 1 45 22.38 10 49 32 41 41 24 Meridian Ada ID 1 45 20.34 8 27 49 38 34 25 Reno Washoe NV 1 46 1.93 15 50 59 33 31 26 Ontario Malhuer Or 0 46 1.83 10 48 37 40 39 28 Reno Washoe NV 0 46 5.81 10 34 56 31 31 26 Ontario Malhuer OR 0 47 0.55 8 38 49 38 36 21 Nampa Canyon ID 1 47 46.25 12 38 60 20 20 19 Sparks Washoe NV 0 48 11.70 32 46 50 44 41 30 Ontario Malhuer Or 0 48 1.93 9 24 56 33 27 22 Reno Washoe NV 0 48 45.99 14 34 60 35 40 27 Reno Washoe NV 1 48 30.30 10 26 46 34 27 20 Reno Washoe NV 0 48 3.64 9 35 42 29 32 25 Reno Washoe NV 1 48 3.35 12 38 60 37 34 30 Boise Ada ID 1 48 5.81 11 35 66 22 33 21 Sparks Washoe NV 0 49 10.25 9 45 34 45 40 24 Ontario Malhuer OR 0 50 9.79 16 30 42 38 32 24 Sparks Washoe NV 1 50 11.86 9 46 62 30 41 28 Sparks Washoe NV 1 50 13.31 13 47 63 29 36 30 Vale Malhuer Or 1 50 2.59 17 45 46 49 45 30 Ontario Malhuer OR 0 51 9.36 9 39 44 42 42 20 Ontario Malhuer Or 0 52 4.27 15 50 62 37 27 21 Reno Washoe NV 1 52 7.75 20 50 51 47 39 30 Reno Washoe NV 1 52 28.86 14 32 42 34 33 25 Ontario Malhuer Or 0 53 0.78 17 41 38 41 36 27 Reno Washoe NV 0 53 23.27 11 32 55 26 27 18 Ontario Malhuer Or 0 53 1.96 9 18 56 29 28 20 Ontario Malhuer Or 1 53 20.61 9 35 57 27 28 22 Reno Washoe NV 0 53 2.79 8 38 51 38 36 22 Garden City ADA ID 1 53 11.47 10 27 52 44 31 25 Vale Malhuer OR 0 54 0.71 10 34 63 26 30 16 Sparks Washoe NV 1 54 10.25 9 23 70 36 36 21 Reno Washoe NV 1 54 3.54 9 12 60 38 34 28 Reno Washoe NV 0 54 2.65 13 10 42 40 33 18 Nyssa Malhuer Or 1 54 1.44 10 46 38 44 29 23 Reno Washoe NV 0 54 10.25 14 30 46 26 23 26 Sparks Washoe NV 0 55 0.95 10 35 40 40 34 25 Reno Washoe NV 1 55 12.95 19 30 45 38 38 28 Sparks Washoe NV 1 55 10.64 15 49 45 46 35 24 Ontario Malhuer Or 0 55 1.67 11 38 50 39 35 20 Boise Ada Id 1 55 8.87 18 36 55 29 32 21 Nampa Canyon ID 0 55 14.33 21 42 51 40 35 23 Vale Malhuer Or 0 56 2.75 8 32 50 42 34 30 Reno Washoe NV 0 56 12.25 17 48 59 48 43 28 Reno Washoe NV 1 56 21.92 16 37 58 44 38 25 Reno Washoe NV 1 56 22.71 21 45 60 41 39 26 Sun Valley Washoe NV 1 56 11.17 15 30 62 30 28 19 Boise Ada ID 1 56 6.96 19 43 47 32 36 27 Sparks Washoe NV 0 57 1.50 12 43 26 36 35 25 Reno Washoe NV 1 57 1.80 9 46 40 32 29 30 Reno Washoe NV 1 57 15.28 14 29 46 30 24 29 Ontario Malhuer Or 0 57 1.44 9 33 44 37 33 22 Nampa Canyon ID 0 57 139.91 8 38 49 38 35 25 Reno Washoe NV 0 57 3.64 10 36 49 43 37 29 Reno Washoe NV 1 57 65.35 17 30 32 38 33 14 Ontario Mauhuer Or 1 58 6.30 13 31 42 26 30 30 Reno Washoe NV 1 58 30.30 13 49 31 48 41 30 Caldwell, Id Canyon ID 1 59 7.88 15 43 44 50 41 29 Parma Canyon ID 0 60 1.80 9 47 56 23 22 18 Sparks Washoe NV 0 60 0.75 11 39 45 40 36 26 Reno Washoe NV 1 60 40.30 14 40 34 40 34 23 Sparks Washoe NV 0 61 4.27 26 44 58 40 42 28 Reno Washoe NV 0 61 4.92 18 30 39 30 28 30 Boise ADA Id 1 61 9.85 17 40 64 33 34 23 Reno Washoe NV 1 64 55.85 13 24 56 32 34 29 Sparks Washoe NV 0 64 1.27 8 37 50 45 37 30 Reno Washoe NV 1 64 23.89 14 44 60 44 41 27 Nampa Canyon ID 1 64 24.22 16 40 35 42 36 25 Reno Washoe NV 1 67 24.39 10 48 38 39 38 26 Ontario Malhuer Or 0 68 1.31 11 44 51 40 42 30 Reno Washoe NV 0 75 1.73 10 49 38 50 37 26 Sparks Washoe NV 0 87 1.04 12 48 33 45 36 19 Ontario Malhuer Or 0 121 17.61 14 40 45 40 32 20
Explanation / Answer
Result:
Gender is coded as 0 for Female and 1 for Male. Why and what is this called?
Gender is binary categorical variable and is coded as 0 for Female and 1 for Male. This is called dummy variable.
Perform a multiple regression analysis using Self Esteem (SE) as the dependent variable (Y) and Age, Months Unemployed, Wage at last job, Social Support, and Financial Hardship as independent variables (X).
What is the Multiple Regression Equation?
Regression Equation
SE
=
36.66 + 0.0167 Age - 0.0292 Months Unemployed + 0.010 Wage at last job
+ 0.2591 Social support - 0.1985 Financial Hardship
What is the Coefficient of Multiple Determination?
R square = Coefficient of Multiple Determination = 0.2295
or 22.95%
MINITAB used
Regression Analysis: SE versus Age, Months ... port, Financial Hardship
Analysis of Variance
Source
DF
Adj SS
Adj MS
F-Value
P-Value
Regression
5
1400.55
280.110
6.61
0.000
Age
1
7.34
7.339
0.17
0.678
Months Unemployed
1
30.45
30.447
0.72
0.398
Wage at last job
1
0.26
0.261
0.01
0.938
Social support
1
572.94
572.941
13.53
0.000
Financial Hardship
1
456.64
456.638
10.78
0.001
Error
111
4701.45
42.355
Total
116
6102.00
Model Summary
S
R-sq
R-sq(adj)
R-sq(pred)
6.50810
22.95%
19.48%
13.84%
Coefficients
Term
Coef
SE Coef
T-Value
P-Value
VIF
Constant
36.66
4.91
7.47
0.000
Age
0.0167
0.0400
0.42
0.678
1.02
Months Unemployed
-0.0292
0.0344
-0.85
0.398
1.02
Wage at last job
0.010
0.126
0.08
0.938
1.03
Social support
0.2591
0.0705
3.68
0.000
1.09
Financial Hardship
-0.1985
0.0605
-3.28
0.001
1.05
Regression Equation
SE
=
36.66 + 0.0167 Age - 0.0292 Months Unemployed + 0.010 Wage at last job
+ 0.2591 Social support - 0.1985 Financial Hardship
SE
=
36.66 + 0.0167 Age - 0.0292 Months Unemployed + 0.010 Wage at last job
+ 0.2591 Social support - 0.1985 Financial Hardship