Data is provided on 80 employees of a company. The managers want to determine which factors are most predictive of end-of-the-year performance ratings. Conduct a thorough regression analysis of the data, including 95% and 99% confidence intervals. Be sure to examine all P-values of all coefficients, create appropriate scatterplots and residual plots for each individual variable, test for nonlinearity, and develop a final regression equation for the data. Be prepared to answer questions about your investigation, make predictions and interpret the results.

Person	Seniority	Test1	Test2	Test3	Performance Rating
1	19	65	45	38	67
2	14	64	58	47	58
3	18	68	60	54	73
4	17	57	59	42	70
5	21	49	37	39	53
6	23	63	60	47	58
7	29	75	71	57	89
8	13	48	48	51	56
9	16	64	80	66	70
10	21	56	68	55	81
11	24	64	77	59	85
12	13	56	60	52	65
13	16	53	55	46	52
14	7	74	75	62	59
15	25	60	60	52	69
16	20	70	56	50	77
17	28	53	65	48	70
18	21	54	60	45	55
19	20	56	64	47	68
20	22	60	52	50	75
21	16	58	51	51	67
22	23	74	69	54	68
23	24	63	55	53	68
24	24	60	44	41	61
25	13	69	71	64	65
26	11	62	66	58	65
27	22	67	63	59	74
28	15	42	55	36	56
29	25	72	64	47	84
30	19	80	63	48	70
31	16	71	84	67	62
32	19	58	52	48	58
33	11	67	63	56	72
34	23	59	52	45	56
35	12	70	73	69	75
36	10	56	44	44	60
37	13	71	59	46	59
38	23	57	59	47	63
39	19	64	61	53	61
40	21	54	66	48	70
41	20	50	55	49	61
42	13	55	62	42	66
43	19	58	55	44	64
44	17	80	71	56	81
45	13	54	55	55	67
46	17	62	60	49	56
47	18	31	39	26	50
48	24	75	68	59	77
49	20	56	51	37	60
50	24	54	49	35	59
51	18	77	63	50	67
52	21	58	71	61	76
53	19	56	53	47	64
54	20	45	59	41	47
55	23	56	71	48	54
56	8	47	46	34	38
57	23	64	52	61	76
58	25	67	64	62	72
59	14	53	52	42	46
60	14	82	86	69	84
61	30	72	78	77	100
62	17	57	72	59	71
63	23	50	53	43	71
64	20	63	61	52	71
65	23	62	75	63	80
66	19	65	65	57	65
67	14	71	72	58	64
68	17	52	55	49	51
69	12	53	55	38	57
70	21	63	56	49	63
71	21	42	58	40	59
72	8	66	68	52	57
73	25	56	58	48	51
74	18	65	74	60	76
75	21	53	58	50	75
76	30	75	66	62	74
77	27	58	52	41	75
78	21	52	49	46	61
79	17	57	68	61	56
80	11	47	61	44	54