In developing an overall understand of income payments, each of the factors included in the data set might be considered to have an impact. Conduct a regression analysis to determine the extent to which income can be explained by the other variables as well. Fully describe the results including all necessary tests. Do you believe there is anything in the relationship between the independent variables which may affect these results? Are the results consistent with the other tests you have conducted? Income ($000) GPA Test Result Age Higher Degree (Y=1, N=0) Gender 94.1 3.07 163 21 0 F 69.4 2.82 148 30 1 F 81.7 3.02 142 26 0 F 72.1 2.98 173 31 0 F 90.1 3.02 168 29 0 F 84.4 3.35 155 39 1 F 77.5 2.9 163 29 0 F 124 2.96 194 28 1 F 71.2 2.67 119 25 0 F 72.1 2.95 124 24 0 F 75.7 3.45 149 29 0 F 79.8 2.71 171 26 1 F 76.7 3.07 160 34 0 F 65.1 3.37 104 23 0 F 83.8 3.01 165 34 1 F 85.8 3.03 154 32 1 F 70.6 3.3 122 32 0 F 93.3 3.19 160 27 0 F 80.1 3.12 148 34 1 F 80.8 2.89 138 28 0 F 85.5 2.86 158 32 0 F 62.1 2.91 112 24 0 F 88.5 3.08 189 28 0 F 88.2 3.15 163 30 1 F 110.3 3.13 203 25 0 F 124.6 2.88 165 41 0 F 97.6 4 176 33 1 F 82.4 3.32 152 30 0 F 58.2 2.4 74 26 0 F 75.5 2.88 129 25 0 F 75.1 2.76 166 35 0 F 70.5 3.1 134 32 0 F 83.9 2.91 124 25 0 F 95.5 3.25 169 32 1 F 150.2 3.61 187 54 0 F 84.4 3.26 163 22 0 F 88.7 3.12 172 28 1 F 135.4 3.84 195 29 1 F 72.3 2.63 149 26 0 F 65.5 2.46 107 27 0 F 80.3 3.2 156 30 0 F 136.8 3.62 183 28 1 F 75.8 2.75 133 34 1 F 47.5 2.57 83 36 1 F 86.6 3.36 148 31 0 F 64.4 2.8 127 25 0 F 99.3 3.3 173 27 1 F 40 2.94 95 22 0 F 69.1 3.02 139 29 1 F 107.7 3.17 179 35 0 F 74.7 2.75 136 28 0 F 90.3 3.14 153 32 1 F 82.2 3.04 141 30 1 F 97 3.19 155 33 1 F 125.3 3.9 179 36 1 F 111.1 3.17 152 32 0 F 60.4 2.78 129 44 0 F 102.7 3.03 155 27 0 F 89 2.59 145 32 0 F 69.4 2.8 113 27 0 F 61.6 3.24 142 32 0 F 93.1 2.97 147 28 0 F 87.2 3.14 171 38 1 F 67.7 3.73 139 31 1 F 130.6 3.21 174 33 1 F 83.2 3.16 143 28 0 F 50.4 2.95 96 34 1 F 132.7 3.71 199 45 1 F 69.1 3.01 143 32 0 F 103.6 3.39 172 39 0 F 80.2 2.98 123 31 0 F 73.9 3.28 146 24 0 F 56.3 2.97 128 21 0 F 130.2 3.69 187 36 1 F 80.7 2.92 138 27 1 F 83.1 2.89 163 30 1 M 95.4 3.04 178 35 0 M 128.2 3.55 154 49 1 M 127.3 2.91 199 28 0 M 96.8 2.96 164 28 1 M 94 3.31 123 26 0 M 125.5 3.64 201 26 1 M 107.2 3.25 205 28 1 M 92.4 3 135 45 0 M 90.5 2.8 123 34 1 M 84.1 3.09 138 27 1 M 98.9 3.3 195 28 0 M 89.3 3.83 184 23 0 M 103.1 3.04 165 27 0 M 119.5 3.24 196 29 0 M 82.7 3 154 34 1 M 103.6 2.73 176 32 1 M 87.5 2.6 82 29 0 M 134.3 3.67 173 45 1 M 92.9 3.36 156 30 0 M 91.4 3.4 149 25 1 M 86.5 2.79 152 33 0 M 72.6 2.88 116 42 0 M 99.9 3 174 28 1 M 92.4 3.09 141 30 1 M 73.9 2.75 111 28 0 M 79.7 2.55 74 24 0 M 80.4 3.51 123 25 0 M 112.3 3.98 182 25 0 M 88.8 2.76 157 30 0 M 95.2 2.94 141 29 0 M 97.7 2.85 167 30 0 M 92.2 3.52 162 21 0 M 78.5 3.02 172 29 0 M 72.8 2.59 107 36 1 M 89 2.93 149 30 1 M 93.5 3.34 182 30 1 M 93.1 2.79 112 32 0 M 83.1 3.08 135 26 0 M 79.1 3.31 177 25 0 M 108.9 4 159 26 0 M 84.9 2.49 138 33 1 M 108 2.92 163 37 1 M 83.7 2.72 148 31 0 M 116.6 3.92 198 27 1 M 134.5 3.33 173 29 1 M 111.4 3.29 152 26 1 M 91.2 3.36 142 35 0 M 87.6 3.12 153 23 0 M 57.5 3.44 138 26 0 M 46.6 3.12 102 22 0 M 73.6 2.99 150 26 1 M 86.7 3.38 163 31 1 M 95.1 3.22 170 31 0 M 85.1 3.3 155 30 1 M 86 3.27 148 31 1 M 51.2 3.31 104 33 0 M 67.8 3.31 132 31 1 M 86.6 3.04 137 33 1 M 103.2 2.99 151 27 1 M 104.9 3.13 152 28 0 M 94.3 3.03 168 33 0 M 65.6 3.06 109 34 0 M 77.9 3.02 126 27 0 M 58.5 3.52 123 21 0 M 109.9 3.68 209 29 0 M 60.1 2.79 112 33 0 M 96.8 3.1 154 27 0 M 113.1 3.65 181 32 1 M 91.6 3.05 157 29 1 M 95.6 3.02 150 34 0 M 104.3 3.41 179 32 1 M 88.2 3.45 161 32 1 M 73.5 2.64 118 25 0 M 63.3 2.97 125 27 0 M
Correlation
Correlation defines a relationship between two independent variables. It tells the degree to which variables move in relation to each other. When two sets of data are related to each other, there is a correlation between them.
Linear Correlation
A correlation is used to determine the relationships between numerical and categorical variables. In other words, it is an indicator of how things are connected to one another. The correlation analysis is the study of how variables are related.
Regression Analysis
Regression analysis is a statistical method in which it estimates the relationship between a dependent variable and one or more independent variable. In simple terms dependent variable is called as outcome variable and independent variable is called as predictors. Regression analysis is one of the methods to find the trends in data. The independent variable used in Regression analysis is named Predictor variable. It offers data of an associated dependent variable regarding a particular outcome.
- In developing an overall understand of income payments, each of the factors included in the data set might be considered to have an impact. Conduct a
regression analysis to determine the extent to which income can be explained by the other variables as well. Fully describe the results including all necessary tests. Do you believe there is anything in the relationship between the independent variables which may affect these results? Are the results consistent with the other tests you have conducted? -
Income ($000) GPA Test Result Age Higher Degree (Y=1, N=0) Gender 94.1 3.07 163 21 0 F 69.4 2.82 148 30 1 F 81.7 3.02 142 26 0 F 72.1 2.98 173 31 0 F 90.1 3.02 168 29 0 F 84.4 3.35 155 39 1 F 77.5 2.9 163 29 0 F 124 2.96 194 28 1 F 71.2 2.67 119 25 0 F 72.1 2.95 124 24 0 F 75.7 3.45 149 29 0 F 79.8 2.71 171 26 1 F 76.7 3.07 160 34 0 F 65.1 3.37 104 23 0 F 83.8 3.01 165 34 1 F 85.8 3.03 154 32 1 F 70.6 3.3 122 32 0 F 93.3 3.19 160 27 0 F 80.1 3.12 148 34 1 F 80.8 2.89 138 28 0 F 85.5 2.86 158 32 0 F 62.1 2.91 112 24 0 F 88.5 3.08 189 28 0 F 88.2 3.15 163 30 1 F 110.3 3.13 203 25 0 F 124.6 2.88 165 41 0 F 97.6 4 176 33 1 F 82.4 3.32 152 30 0 F 58.2 2.4 74 26 0 F 75.5 2.88 129 25 0 F 75.1 2.76 166 35 0 F 70.5 3.1 134 32 0 F 83.9 2.91 124 25 0 F 95.5 3.25 169 32 1 F 150.2 3.61 187 54 0 F 84.4 3.26 163 22 0 F 88.7 3.12 172 28 1 F 135.4 3.84 195 29 1 F 72.3 2.63 149 26 0 F 65.5 2.46 107 27 0 F 80.3 3.2 156 30 0 F 136.8 3.62 183 28 1 F 75.8 2.75 133 34 1 F 47.5 2.57 83 36 1 F 86.6 3.36 148 31 0 F 64.4 2.8 127 25 0 F 99.3 3.3 173 27 1 F 40 2.94 95 22 0 F 69.1 3.02 139 29 1 F 107.7 3.17 179 35 0 F 74.7 2.75 136 28 0 F 90.3 3.14 153 32 1 F 82.2 3.04 141 30 1 F 97 3.19 155 33 1 F 125.3 3.9 179 36 1 F 111.1 3.17 152 32 0 F 60.4 2.78 129 44 0 F 102.7 3.03 155 27 0 F 89 2.59 145 32 0 F 69.4 2.8 113 27 0 F 61.6 3.24 142 32 0 F 93.1 2.97 147 28 0 F 87.2 3.14 171 38 1 F 67.7 3.73 139 31 1 F 130.6 3.21 174 33 1 F 83.2 3.16 143 28 0 F 50.4 2.95 96 34 1 F 132.7 3.71 199 45 1 F 69.1 3.01 143 32 0 F 103.6 3.39 172 39 0 F 80.2 2.98 123 31 0 F 73.9 3.28 146 24 0 F 56.3 2.97 128 21 0 F 130.2 3.69 187 36 1 F 80.7 2.92 138 27 1 F 83.1 2.89 163 30 1 M 95.4 3.04 178 35 0 M 128.2 3.55 154 49 1 M 127.3 2.91 199 28 0 M 96.8 2.96 164 28 1 M 94 3.31 123 26 0 M 125.5 3.64 201 26 1 M 107.2 3.25 205 28 1 M 92.4 3 135 45 0 M 90.5 2.8 123 34 1 M 84.1 3.09 138 27 1 M 98.9 3.3 195 28 0 M 89.3 3.83 184 23 0 M 103.1 3.04 165 27 0 M 119.5 3.24 196 29 0 M 82.7 3 154 34 1 M 103.6 2.73 176 32 1 M 87.5 2.6 82 29 0 M 134.3 3.67 173 45 1 M 92.9 3.36 156 30 0 M 91.4 3.4 149 25 1 M 86.5 2.79 152 33 0 M 72.6 2.88 116 42 0 M 99.9 3 174 28 1 M 92.4 3.09 141 30 1 M 73.9 2.75 111 28 0 M 79.7 2.55 74 24 0 M 80.4 3.51 123 25 0 M 112.3 3.98 182 25 0 M 88.8 2.76 157 30 0 M 95.2 2.94 141 29 0 M 97.7 2.85 167 30 0 M 92.2 3.52 162 21 0 M 78.5 3.02 172 29 0 M 72.8 2.59 107 36 1 M 89 2.93 149 30 1 M 93.5 3.34 182 30 1 M 93.1 2.79 112 32 0 M 83.1 3.08 135 26 0 M 79.1 3.31 177 25 0 M 108.9 4 159 26 0 M 84.9 2.49 138 33 1 M 108 2.92 163 37 1 M 83.7 2.72 148 31 0 M 116.6 3.92 198 27 1 M 134.5 3.33 173 29 1 M 111.4 3.29 152 26 1 M 91.2 3.36 142 35 0 M 87.6 3.12 153 23 0 M 57.5 3.44 138 26 0 M 46.6 3.12 102 22 0 M 73.6 2.99 150 26 1 M 86.7 3.38 163 31 1 M 95.1 3.22 170 31 0 M 85.1 3.3 155 30 1 M 86 3.27 148 31 1 M 51.2 3.31 104 33 0 M 67.8 3.31 132 31 1 M 86.6 3.04 137 33 1 M 103.2 2.99 151 27 1 M 104.9 3.13 152 28 0 M 94.3 3.03 168 33 0 M 65.6 3.06 109 34 0 M 77.9 3.02 126 27 0 M 58.5 3.52 123 21 0 M 109.9 3.68 209 29 0 M 60.1 2.79 112 33 0 M 96.8 3.1 154 27 0 M 113.1 3.65 181 32 1 M 91.6 3.05 157 29 1 M 95.6 3.02 150 34 0 M 104.3 3.41 179 32 1 M 88.2 3.45 161 32 1 M 73.5 2.64 118 25 0 M 63.3 2.97 125 27 0 M
Step by step
Solved in 2 steps with 4 images