Help with a project

Sheet1

Sales (Y)	Calls (X1)	Time (X2)	Years (X3)	Type
37	131	16.9	2	GROUP
44	134	19.4	3	GROUP		Type	Average of Years X3
33	139	19.3	3	GROUP		Group	2.482758621
40	145	14.7	2	GROUP		NONE	1.777777778
35	149	15.6	1	GROUP		ONLINE	2.245283019
47	149	15.8	1	GROUP
26	150	14.9	2	GROUP
39	150	15.3	3	GROUP
47	151	16.6	2	GROUP
25	152	15.0	3	GROUP
41	152	14.5	4	GROUP
49	153	19.0	3	GROUP
42	154	14.3	2	GROUP
42	124	15.3	1	GROUP
25	155	17.9	1	GROUP
45	156	13.2	3	GROUP
50	157	15.9	3	GROUP
44	159	14.6	2	GROUP
42	161	13.2	1	GROUP
48	162	14.5	4	GROUP
41	164	17.8	3	GROUP
67	166	18.9	1	GROUP
44	168	12.4	2	GROUP
43	169	14.0	5	GROUP
22	170	14.3	4	GROUP
46	172	14.7	3	GROUP
43	175	13.6	5	GROUP
49	178	18.3	2	GROUP
44	192	16.7	1	GROUP
25	130	12.8	2	NONE
36	131	11.7	3	NONE
35	131	21.6	1	NONE
36	131	18.5	0	NONE
49	131	14.6	1	NONE
37	132	10.0	3	NONE
38	135	18.5	3	NONE
22	139	16.9	4	NONE
39	140	12.4	0	NONE
42	140	17.5	3	NONE
37	142	13.9	2	NONE
25	143	15.4	1	NONE
50	144	15.8	2	NONE
22	145	19.0	2	NONE
50	148	16.0	0	NONE
67	155	17.9	1	NONE
37	159	18.1	0	NONE
39	160	14.3	4	NONE
45	138	15.3	2	ONLINE
36	140	15.7	1	ONLINE
39	144	17.7	1	ONLINE
41	149	17.3	0	ONLINE
45	149	13.5	1	ONLINE
42	152	14.6	1	ONLINE
44	153	15.3	2	ONLINE
41	155	16.0	2	ONLINE
44	156	20.0	0	ONLINE
40	157	15.4	1	ONLINE
34	158	14.2	3	ONLINE
41	159	18.8	2	ONLINE
43	160	10.9	4	ONLINE
44	160	14.8	2	ONLINE
43	161	17.3	3	ONLINE
46	163	16.6	2	ONLINE
44	165	15.7	3	ONLINE
44	165	12.4	3	ONLINE
48	167	14.8	3	ONLINE
42	168	16.4	0	ONLINE
44	168	11.0	5	ONLINE
41	170	12.3	0	ONLINE
45	170	14.2	1	ONLINE
48	170	17.4	5	ONLINE
46	171	14.9	5	ONLINE
48	171	13.0	5	ONLINE
30	173	17.5	1	ONLINE
43	174	12.7	2	ONLINE
45	174	13.6	2	ONLINE
40	176	12.6	1	ONLINE
21	177	17.0	0	ONLINE
41	178	13.4	2	ONLINE
49	178	151.0	3	ONLINE
49	178	16.4	2	ONLINE
51	178	16.5	1	ONLINE
41	180	14.0	2	ONLINE
42	181	11.5	4	ONLINE
48	182	13.0	2	ONLINE
46	183	15.4	4	ONLINE
46	184	12.7	5	ONLINE
52	184	11.4	4	ONLINE
21	185	18.9	2	ONLINE
47	186	13.5	3	ONLINE
48	186	14.2	1	ONLINE
48	188	13.6	0	ONLINE
48	188	11.3	2	ONLINE
50	189	14.3	1	ONLINE
56	189	15.0	3	ONLINE
40	191	19.0	5	ONLINE
52	193	13.7	5	ONLINE
42	194	13.6	2	ONLINE
41	198	13.2	2	ONLINE
8	201	12.5	1	ONLINE

1

2

3

4

5

6

7

8

9

10

A

B

C

D

Sales (Y)

Calls (X1)

Time (X2)

Years (X3)

37

131

16.9

2

44

134

19.4

3

33

139

19.3

3

40

145

14.7

2

35

149

15.6

1

47

149

15.8

1

26

150

14.9

2

39

150

15.3

3

47

151

16.6

2