Question: I'm trying to create regression and scatter plots for my dataset from employee satisfaction. My regression and scatter plot charts do not equal out when
I'm trying to create regression and scatter plots for my dataset from employee satisfaction. My regression and scatter plot charts do not equal out when it comes to the equation. What am I doing wrong?
| SUMMARY OUTPUT | ||||||||||
| Regression Statistics | ||||||||||
| Multiple R | 0.948899828 | |||||||||
| R Square | 0.900410883 | |||||||||
| Adjusted R Square | 0.896080921 | |||||||||
| Standard Error | 19.31364389 | |||||||||
| Observations | 25 | |||||||||
| ANOVA | ||||||||||
| df | SS | MS | F | Significance F | ||||||
| Regression | 1 | 77568.45267 | 77568.45267 | 207.9489295 | 5.208E-13 | |||||
| Residual | 23 | 8579.387331 | 373.0168405 | |||||||
| Total | 24 | 86147.84 | ||||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |||
| Intercept | 88.04049844 | 9.051202095 | 9.726939861 | 1.28557E-09 | 69.31666035 | 106.7643365 | 69.31666035 | 106.7643365 | ||
| X Variable 1 | 31.73104881 | 2.200422528 | 14.42043444 | 5.208E-13 | 27.179128 | 36.28296961 | 27.179128 | 36.28296961 | ||
| | ||||||||||
| employee_id | satisfaction_level | last_evaluation_score | number_of_projects | average_monthly_hours | ||||||
| 00001 | 0.38 | 0.53 | 2 | 157 | ||||||
| 00002 | 0.8 | 0.86 | 5 | 262 | ||||||
| 00003 | 0.11 | 0.88 | 7 | 272 | ||||||
| 00004 | 0.72 | 0.87 | 5 | 223 | ||||||
| 00005 | 0.37 | 0.52 | 2 | 159 | ||||||
| 00006 | 0.41 | 0.5 | 2 | 153 | ||||||
| 00007 | 0.1 | 0.77 | 6 | 247 | ||||||
| 00008 | 0.92 | 0.85 | 5 | 259 | ||||||
| 00009 | 0.89 | 1 | 5 | 224 | ||||||
| 00010 | 0.42 | 0.53 | 2 | 142 | ||||||
| 00011 | 0.45 | 0.54 | 2 | 135 | ||||||
| 00012 | 0.11 | 0.81 | 6 | 305 | ||||||
| 00013 | 0.84 | 0.92 | 4 | 234 | ||||||
| 00014 | 0.41 | 0.55 | 2 | 148 | ||||||
| 00015 | 0.36 | 0.56 | 2 | 137 | ||||||
| 00016 | 0.38 | 0.54 | 2 | 143 | ||||||
| 00017 | 0.45 | 0.47 | 2 | 160 | ||||||
| 00018 | 0.78 | 0.99 | 4 | 255 | ||||||
| 00019 | 0.45 | 0.51 | 2 | 160 | ||||||
| 00020 | 0.76 | 0.89 | 5 | 262 | ||||||
| 00021 | 0.11 | 0.83 | 6 | 282 | ||||||
| 00022 | 0.38 | 0.55 | 2 | 147 | ||||||
| 00023 | 0.09 | 0.95 | 6 | 304 | ||||||
| 00024 | 0.46 | 0.57 | 2 | 139 | ||||||
| 00025 | 0.4 | 0.53 | 2 | 158 | ||||||
| 00026 | 0.89 | 0.92 | 5 | 242 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
