the Excel file Salary to answer the questions in W7's assignment, statistics homework help

User Generated

QUbbire

Mathematics

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

ID Salary Compa Midpoint Age 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 62,9 27,2 34,9 64,6 49,2 77,7 41,2 22 73,4 23,9 21,8 60,8 41,8 23,3 24,6 47,4 66,6 34,8 24,5 35,9 77,1 58,9 23,8 55,1 24,6 24,1 45,3 75,2 78,7 48,3 24,2 27,6 61,2 27 23,8 24,4 23,5 61,3 34,4 24,7 1,104 57 31 31 57 48 67 40 23 67 23 23 57 40 23 23 40 57 31 23 31 67 48 23 48 23 23 40 67 67 48 23 31 57 31 23 23 23 57 31 23 34 52 30 42 36 36 32 32 49 30 41 52 30 32 32 44 27 31 32 44 43 48 36 30 41 22 35 44 52 45 29 25 35 26 23 27 22 45 27 24 0,879 1,127 1,134 1,026 1,160 1,029 0,956 1,095 1,039 0,947 1,066 1,044 1,012 1,070 1,186 1,169 1,124 1,065 1,159 1,150 1,228 1,036 1,147 1,069 1,047 1,133 1,122 1,175 1,006 1,050 0,889 1,074 0,872 1,036 1,060 1,023 1,075 1,109 1,076 Performance Service Gende Raise Rating r 85 80 75 100 90 70 100 90 100 80 100 95 100 90 80 90 55 80 85 70 95 65 65 75 70 95 80 95 95 90 60 95 90 80 90 75 95 95 90 90 8 7 5 16 16 12 8 9 10 7 19 22 2 12 8 4 3 11 1 16 13 6 6 9 4 2 7 9 5 18 4 4 9 2 4 3 2 11 6 2 0 0 1 0 0 0 1 1 0 1 1 0 1 1 1 0 1 1 0 1 0 1 1 1 0 1 0 1 0 0 1 0 0 0 1 1 1 0 1 0 5,7 3,9 3,6 5,5 5,7 4,5 5,7 5,8 4 4,7 4,8 4,5 4,7 6 4,9 5,7 3 5,6 4,6 4,8 6,3 3,8 3,3 3,8 4 6,2 3,9 4,4 5,4 4,3 3,9 5,6 5,5 4,9 5,3 4,3 6,2 4,5 5,5 6,3 41 42 43 44 45 46 47 48 49 50 45,8 22,4 75,6 61,3 59,7 55,1 63,8 62,8 64 66,3 1,145 0,975 1,129 1,075 1,244 0,967 1,119 1,101 1,122 1,163 40 23 67 57 48 57 57 57 57 57 25 32 42 45 36 39 37 34 41 38 80 100 95 90 95 75 95 90 95 80 5 8 20 16 8 20 5 11 21 12 0 1 1 0 1 0 0 1 0 0 4,3 5,7 5,5 5,2 5,2 3,9 5,5 5,3 6,6 4,6 Degree Gender 1 0 0 1 1 1 1 1 1 1 1 1 0 0 1 1 0 1 0 1 0 1 1 0 0 0 0 1 0 0 0 1 0 1 1 0 0 0 0 0 0 M M F M M M F F M F F M F F F M F F M F M F F F M F M F M M F M M M F F F M F M Gr E B B E D F C A F A A E C A A C E B A B F D A D A A C F F D A B E B A A A E B A The column labels in the table mean: ID – Employee sample number Salary – Salary in thousands Age – Age in years Performance Rating - Appraisal rating (em Service – Years of service (rounded) Gender – 0 = male, 1 = female Midpoint – salary grade midpoint Raise – percent of last raise Grade – job/pay grade Degree (0= BS\BA 1 = MS) Gender1 (Male or Female) Compa - salary divided by midpoint 0 1 0 1 1 1 1 1 0 0 M F F M F M M F M M C A F E D E E E E E ance Rating - Appraisal rating (employee evaluation score)
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Great study resource, helped me a lot.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags