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 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 Mathematics Questions!