Employee Years Employed Salary 1 27 $65,487 2 20 $46,184 3 0 $32,782 4 12 $54,899 5 7 $34,869 6 8 $35,487 7 5 $26,548 8 15 $32,920 9 5 $29,548 10 6 $34,231 11 0 $23,654 12 9 $39,331 13 6 $36,512 14 3 $35,467 15 25 $68,425 16 9 $35,468 17 4 $36,578 18 18 $39,828 19 6 $36,487 20 19 $37,548 21 3 $31,528 22 5 $34,632 23 14 $46,211 24 2 $29,876 25 6 $43,674 26 18 $38,985 27 25 $53,234 28 18 $51,698 29 22 $41,889 30 21 $38,791 31 22 $69,246 32 6 $48,695 33 9 $34,987 34 0 $28,985 35 6 $35,631 36 20 $54,679 37 9 $39,743 38 9 $41,255 39 9 $36,431 40 0 $26,578 41 15 $47,536 42 6 $36,571 43 12 $56,326 44 7 $31,425 45 6 $24,749 46 1 $26,452 The human resources manager of DataCom, Inc., wants to examine the relationship between annual salaries (Y)...

50.1K

Verified Solution

Question

General Management

Employee Years Employed Salary
1 27 $65,487
2 20 $46,184
3 0 $32,782
4 12 $54,899
5 7 $34,869
6 8 $35,487
7 5 $26,548
8 15 $32,920
9 5 $29,548
10 6 $34,231
11 0 $23,654
12 9 $39,331
13 6 $36,512
14 3 $35,467
15 25 $68,425
16 9 $35,468
17 4 $36,578
18 18 $39,828
19 6 $36,487
20 19 $37,548
21 3 $31,528
22 5 $34,632
23 14 $46,211
24 2 $29,876
25 6 $43,674
26 18 $38,985
27 25 $53,234
28 18 $51,698
29 22 $41,889
30 21 $38,791
31 22 $69,246
32 6 $48,695
33 9 $34,987
34 0 $28,985
35 6 $35,631
36 20 $54,679
37 9 $39,743
38 9 $41,255
39 9 $36,431
40 0 $26,578
41 15 $47,536
42 6 $36,571
43 12 $56,326
44 7 $31,425
45 6 $24,749
46 1 $26,452
The human resources manager ofDataCom, Inc., wants to examine the relationship between annualsalaries (Y) and the number of years employees have worked atDataCom (X). These data have been collected for a sample ofemployees and are given above.
1. Draw a normal probability plot ofresiduals by finding out the Z-score of the residuals. Use Excel.Plot Z-score at Y – axis and residuals at X – axis. Do theresiduals seem normally distributed? Explain.

Answer & Explanation Solved by verified expert

3.6 Ratings (266 Votes)

The initial graph for the dataNorml Probability Plot for X axis number of years employees haveworked at DataComOrder the data according to the number of years employed Thennumbering is done in order from 1 46 Cumulative Probability iscalculatedi number of the data n 46Cumulative Probability i05Z score for the probability is calulated in excel using theformula NORMSINVprobabilityYears EmployedSalaryNumberCumilative ProbabilityZ score0 32782100109229490 23654200326184380 28985300543160410 26578400761143191 See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

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