Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elementary Linear Algebra with Applications

Authors: Howard Anton, Chris Rorres

9th edition

471669598, 978-0471669593

More Books

Students also viewed these Mathematics questions

Question

4 How common are mental disorders?

Answered: 1 week ago

Question

Examine data collection in research using the questions provided.

Answered: 1 week ago