Analyzing Employee Salaries: Key Factors and Trends

Employee Salary Years Previous Experience Years Employed Years Education Gender 1 $65,487 0 27 12 1 2 $46,184 3 20 4 0 3 $32,782 1 0 7 0 4 $54,899 5 12 8 1 5 $34,869 5 7 4 1 6 $35,487 2 8 2 1 7 $26,548 1 5 0 0 8 $32,920 3 15 9 1 9 $29,548 6 5 1 0 10 $34,231 2 6 6 0 11 $23,654 0 0 0 1 12 $39,331 3 9 6 1 13 $36,512 6 6 4 1 14 $35,467 6 3 6 1 15 $68,425 2 25 12 0 16 $35,468 5 9 4 1 17 $36,578 4 4 8 0 18 $39,828 6 18 5 1 19 $36,487 5 6 2 0 20 $37,548 9 19 4 0 21 $31,528 11 3 3 0 22 $34,632 4 5 4 0 23 $46,211 5 14 6 1 24 $29,876 0 2 3 1 25 $43,674 9 6 4 0 26 $38,985 7 18 9 0 27 $53,234 0 25 6 0 28 $51,698 6 18 6 0 29 $41,889 16 22 7 0 30 $38,791 4 21 5 0 31 $69,246 3 22 10 0 32 $48,695 19 6 8 0 33 $34,987 6 9 2 1 34 $28,985 1 0 4 1 35 $35,631 4 6 4 0 36 $54,679 3 20 6 1 37 $39,743 6 9 5 1 38 $41,255 4 9 6 0 39 $36,431 4 9 4 1 40 $26,578 6 0 2 1 41 $47,536 5 15 6 0 42 $36,571 1 6 4 0

43 $56,326 3 12 8 0 44 $31,425 6 7 5 1 45 $24,749 2 6 0 1 46 $26,452 3 1 2 1

Department Number Supervised 4 44 4 1 1 0 4 0 4 1 4 2 4 2 1 4 1 0 4 3 3 2 4 1 4 2 2 3 4 1 2 5 3 8 1 5 4 3 3 6 1 6 4 0 4 5 2 5 2 2 1 5 3 3 4 1 1 7 1 9 4 45 4 40 4 3 1 4 4 2 3 4 4 1 4 4 2 2 2 2 3 4 2 2 The human resources manager of DataCom, Inc., wants to examine the relationship between annual salari (Y ) and the number of years employees have work at DataCom (X ). These data have been collected for a sample of employees and are given in columns B and C of the file P10_05.xlsx. a. Estimate the relationship between Y and X. Inter the least squares line. b. How well does the estimated simple linear regression equation fit the given data? Provide evidence for y answer. The human resources manager of DataCom, Inc., wants to examine the relationship between annual salar (Y ) and the number of years employees have wor at DataCom (X ). These data have been collected for sample of employees and are given in columns B and C of the file P10_05.xlsx. a. Estimate the relationship between Y and X. Inte the least squares line. b. How well does the estimated simple linear regression equation fit the given data? Provide evidence for y answer.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

2 6 3 6 1 1 4 0

ies ked a rpret your ries rked a f erpret your

P10_05 (p434)

Related Documents