Question
The given data set shows the salaries of employees at Inosmart Inc (dependent variable) with a number of variables ( Independent variables) (i) Use Data
The given data set shows the salaries of employees at Inosmart Inc (dependent variable) with a number of variables ( Independent variables)
(i) Use Data Analysis to and show the correlation matrix for the relationships.
(ii) Which variables significantly impact the employee's salaries? Explain why.
(iii) Which variables are not significantly impacting employees' salaries? Explain why.
(iv) Use a Scatter plot to present the relationship between salaries and Gender. Explain your visualization
(v) Use simple linear regression analysis to find out if the number of years employed significantly determines the salary levels of these employees. Provide your conclusions and recommendations
(vi) Use simple linear regression analysis to show the relationship between "Salary" and all dependent variables. Explain, which variables are significant and which are not.
Employee | Salary | Years Previous Experience | Years Employed | Years Education | Gender | Department | Number Supervised |
1 | $65,487 | 0 | 27 | 12 | 1 | 4 | 44 |
2 | $46,184 | 3 | 20 | 4 | 0 | 4 | 1 |
3 | $32,782 | 1 | 0 | 7 | 0 | 1 | 0 |
4 | $54,899 | 5 | 12 | 8 | 1 | 4 | 0 |
5 | $34,869 | 5 | 7 | 4 | 1 | 4 | 1 |
6 | $35,487 | 2 | 8 | 2 | 1 | 4 | 2 |
7 | $26,548 | 1 | 5 | 0 | 0 | 4 | 2 |
8 | $32,920 | 3 | 15 | 9 | 1 | 1 | 4 |
9 | $29,548 | 6 | 5 | 1 | 0 | 1 | 0 |
10 | $34,231 | 2 | 6 | 6 | 0 | 4 | 3 |
11 | $23,654 | 0 | 0 | 0 | 1 | 3 | 2 |
12 | $39,331 | 3 | 9 | 6 | 1 | 4 | 1 |
13 | $36,512 | 6 | 6 | 4 | 1 | 4 | 2 |
14 | $35,467 | 6 | 3 | 6 | 1 | 2 | 3 |
15 | $68,425 | 2 | 25 | 12 | 0 | 4 | 1 |
16 | $35,468 | 5 | 9 | 4 | 1 | 2 | 5 |
17 | $36,578 | 4 | 4 | 8 | 0 | 3 | 8 |
18 | $39,828 | 6 | 18 | 5 | 1 | 1 | 5 |
19 | $36,487 | 5 | 6 | 2 | 0 | 4 | 3 |
20 | $37,548 | 9 | 19 | 4 | 0 | 3 | 6 |
21 | $31,528 | 11 | 3 | 3 | 0 | 1 | 6 |
22 | $34,632 | 4 | 5 | 4 | 0 | 4 | 0 |
23 | $46,211 | 5 | 14 | 6 | 1 | 4 | 5 |
24 | $29,876 | 0 | 2 | 3 | 1 | 2 | 5 |
25 | $43,674 | 9 | 6 | 4 | 0 | 2 | 2 |
26 | $38,985 | 7 | 18 | 9 | 0 | 1 | 5 |
27 | $53,234 | 0 | 25 | 6 | 0 | 3 | 3 |
28 | $51,698 | 6 | 18 | 6 | 0 | 4 | 1 |
29 | $41,889 | 16 | 22 | 7 | 0 | 1 | 7 |
30 | $38,791 | 4 | 21 | 5 | 0 | 1 | 9 |
31 | $69,246 | 3 | 22 | 10 | 0 | 4 | 45 |
32 | $48,695 | 19 | 6 | 8 | 0 | 4 | 40 |
33 | $34,987 | 6 | 9 | 2 | 1 | 4 | 3 |
34 | $28,985 | 1 | 0 | 4 | 1 | 1 | 4 |
35 | $35,631 | 4 | 6 | 4 | 0 | 4 | 2 |
36 | $54,679 | 3 | 20 | 6 | 1 | 3 | 4 |
37 | $39,743 | 6 | 9 | 5 | 1 | 4 | 1 |
38 | $41,255 | 4 | 9 | 6 | 0 | 4 | 4 |
39 | $36,431 | 4 | 9 | 4 | 1 | 2 | 2 |
40 | $26,578 | 6 | 0 | 2 | 1 | 2 | 2 |
41 | $47,536 | 5 | 15 | 6 | 0 | 3 | 4 |
42 | $36,571 | 1 | 6 | 4 | 0 | 2 | 2 |
43 | $56,326 | 3 | 12 | 8 | 0 | 2 | 6 |
44 | $31,425 | 6 | 7 | 5 | 1 | 3 | 6 |
45 | $24,749 | 2 | 6 | 0 | 1 | 1 | 1 |
46 | $26,452 | 3 | 1 | 2 | 1 | 4 | 0 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started