Description
I need to use the Excel file Salary to answer the questions in W7's assignment (pdf). My previous assignments I was able to find them on study pool and purchase them. I can't seem to find this assignment - -
Could someone please help me with the assignment?
Thank you,
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hey buddy!Attached is the draft assignment.Please have a look at it and feel free to seek any further clarification. I will revise any part part that you will want me to until you are 100% satisfied with the work. Thanks. 😉
SUMMARY OUTPUT
Age Residual Plot
Performance Rating Residual
50
50
Residuals
Residuals
Regression Statistics
Multiple R 0,585915
R Square 0,343296
Adjusted R Square
0,284923
Standard Error
16,38886
Observations
50
0
0
20
-50
40
60
Age
0
0
20
-50
Performance Rating
ANOVA
SS
MS
F
Significance F
4 6318,441 1579,61 5,881017 0,000678
45 12086,76 268,5948
49 18405,21
Coefficients
Standard Error t Stat
Intercept
-0,8704 21,45348 -0,04057
Age
1,10697 0,309612 3,575349
Performance Rating
0,105 0,208622 0,503302
Gender
-7,11749 5,068767 -1,40419
Degree
2,877372 4,646723 0,619226
RESIDUAL OUTPUT
P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
0,967817 -44,0799 42,33912 -44,0799 42,33912
0,00085 0,48338 1,73056 0,48338 1,73056
0,617207 -0,31519 0,525187 -0,31519 0,525187
0,167128 -17,3265 3,091534 -17,3265 3,091534
0,53889 -6,48161 12,23635 -6,48161 12,23635
PROBABILITY OUTPUT
Normal Probability Plot
Salary
Observation
Predicted
Salary
Residuals
Percentile Salary
100
1 45,69157 17,20843
1
21,8
250 65,09203
-37,892
3
22
3 0 35,97358 -1,07358
5
22,4
4 58,9997
5,6003
7
23,3
0
20
40
60
80
100
120
5 51,30788 -2,10788
9
23,5
6 49,20...