Coefficient of Correlation in Excel - Both Variables (Correlation - Excel Only)

In the PART II tab in Excel, use an Excel function to generate a coefficient of correlation for your sample's two variables (PATIENTS SIZE and REVENUE). Additionally, generate an appropriately labeled scatterplot with a trend line.

PATIENT SIZE	REVENUE
125	$3,800
100	$4,330
164	$4,480
130	$5,740
75	$7,930
213	$9,020
163	$10,840
145	$15,750
25	$17,980
163	$19,720
225	$27,500
225	$28,770
144	$29,110
82	$30,730
213	$31,490
150	$35,900
276	$35,900
263	$39,780
125	$42,580
286	$51,470
200	$54,030
100	$57,960
138	$60,250
225	$65,790
206	$66,410
238	$68,270
125	$68,690
78	$71,910
88	$72,460
88	$77,840
170	$81,780
55	$82,010
248	$85,780
216	$96,840
150	$98,800
40	$900,000
114	$10,140
213	$101,460
250	$215,450
244	$822,290
220	$14,190
150	$89,790
153	$12,250
147	$180,260
252	$1,800
75	$19,010
175	$155,540
100	$1,620
175	$189,970
160	$7,920
39	$7,920
77	$1,400
113	$104,090
141	$157,630
175	$809,450
304	$184,550
250	$150,830
75	$153,020
308	$164,290
93	$173,570
138	$183,390
104	$203,840
194	$204,120
253	$205,860
150	$213,880
169	$228,760
50	$260,750
250	$306,610
25	$431,540
156	$557,080
125	$608,780
105	$671,900
178	$1,374,720
25	$8,300
119	$201,390
100	$225,750
118	$44,430
158	$96,210
201	$90,470
153	$1,960
50	$687,550
103	$1,570
103	$1,550
118	$432,210
238	$113,540
170	$324,150
173	$2,360
114	$17,650
100	$57,860
50	$85,930
215	$126,150
203	$141,560
236	$179,640
155	$183,690
249	$317,610
87	$342,150
169	$549,000
314	$4,610
50	$199,840
135	$188,260
150	$189,640
175	$190,990
188	$236,660
125	$243,780
213	$251,880
150	$261,840
100	$284,350
44	$291,990
100	$313,510
102	$314,250
97	$317,790
73	$328,840
75	$342,450
197	$399,840
25	$450,940
106	$467,090
113	$518,250
163	$569,580
25	$640,910
238	$406,750
242	$777,030
125	$5,410
169	$7,650
88	$191,380
163	$214,460
253	$352,200
90	$294,450
210	$451,960
150	$227,900
63	$471,420
130	$361,410
200	$151,930
100	$549,350
225	$146,420
150	$154,600
83	$160,110
25	$178,660
223	$332,870
100	$679,300
216	$1,370
156	$310,810
261	$263,020
188	$267,740
250	$273,640
244	$297,780
111	$309,760
69	$355,070
316	$360,090
113	$368,380
115	$394,900
125	$408,960
136	$426,960
183	$488,510
150	$496,430
175	$538,790
80	$562,940
76	$665,770
199	$680,150
30	$742,370
100	$867,780
175	$882,860
125	$1,355,760
160	$2,584,960
75	$201,530
85	$151,560
144	$272,980
57	$536,350
250	$162,660
193	$169,160
77	$835,650
141	$222,750
81	$339,310
150	$1,018,280
25	$352,270
150	$393,590
175	$314,420
25	$358,720
150	$388,710
100	$456,980
50	$600,140
63	$2,290
177	$168,960
200	$436,780
100	$306,590
65	$206,310
144	$609,550
86	$341,760
25	$331,550
65	$334,380
228	$341,710
186	$347,740
188	$418,070
175	$422,520
160	$428,570
84	$430,890
160	$481,850
209	$513,140
123	$575,810
175	$606,660
88	$625,340
80	$645,890
90	$682,430
254	$758,500
218	$803,190
175	$889,560
157	$1,137,180
89	$1,361,060
288	$1,376,760
51	$1,836,370
50	$231,740
200	$5,530
63	$649,900
118	$374,330
74	$699,210
166	$1,860
205	$357,750
40	$210,790
213	$350,690
90	$350,820
88	$504,600
38	$835,560
235	$283,930
175	$4,580
55	$479,610
125	$433,500
28	$291,070
38	$1,078,820
100	$454,990
162	$135,550
150	$155,190
304	$155,780
228	$180,510
175	$235,880
225	$237,270
83	$282,360
250	$391,780
246	$409,590
146	$441,290
59	$492,740
158	$496,510
260	$501,820
138	$512,840
50	$512,840
125	$525,950
232	$576,200
108	$585,600
25	$664,380
108	$724,330
204	$728,730
77	$810,670
230	$1,214,130
143	$2,075,980
188	$808,100
225	$418,720
225	$392,540
215	$863,360
76	$168,130
111	$801,930
70	$564,800
181	$4,930
25	$61,250
65	$175,910
88	$300,440
144	$653,120
25	$780,360
102	$927,850
150	$328,180
79	$187,990
95	$290,180
240	$340,330
154	$359,860
125	$392,690
100	$400,490
25	$425,840
250	$429,870
133	$577,450
96	$662,420
84	$697,330
75	$731,490
65	$733,850
25	$755,540
148	$930,270
81	$960,260
78	$998,190
163	$1,040,310
75	$1,069,910
150	$1,199,720
265	$1,994,630
175	$110,210
61	$229,340
25	$525,980
83	$1,193,310
135	$476,660
66	$1,414,210
313	$215,330
188	$3,020
108	$268,930
188	$283,950
108	$463,530
100	$496,080
75	$1,342,200
221	$48,000
128	$315,040
128	$487,610
95	$590,440
41	$378,510
79	$385,290
175	$473,190
290	$540,390
250	$674,910
225	$720,890
133	$790,610
70	$801,120
253	$850,370
200	$1,286,800
217	$1,665,720
70	$2,036,700
110	$809,450
196	$1,294,780
175	$732,660
65	$1,115,040
244	$203,500
150	$260,000
213	$275,140
202	$580,410
107	$883,490
230	$1,364,480
188	$1,474,730
218	$334,330
125	$984,850
150	$88,610
149	$236,060
299	$707,340
163	$169,680
100	$310,510
200	$348,580
113	$350,630
163	$519,230
69	$583,870
125	$595,250
208	$681,260
127	$746,510
70	$941,020
163	$981,020
150	$1,312,780
138	$1,372,630
100	$1,594,080
116	$1,882,580
151	$2,684,940
213	$159,460
145	$1,335,650
220	$3,550
175	$116,440
94	$636,720
62	$5,720
131	$1,341,060
219	$172,530
129	$1,473,340
230	$2,210,770
215	$295,020
250	$1,172,400
88	$851,610
125	$1,359,800
188	$104,520
184	$112,800
189	$131,310
175	$285,440
63	$289,450
75	$433,220
185	$517,370
246	$751,790
63	$819,530
175	$1,087,820
57	$1,175,960
190	$1,678,720
150	$1,803,740
150	$2,098,250
25	$2,392,940
127	$583,210
74	$1,121,750
155	$1,456,050
25	$771,460
213	$152,660
236	$289,190
155	$206,240
158	$156,520
188	$901,640
57	$2,410
159	$551,570
98	$1,203,370
25	$543,740
138	$581,060
175	$753,800
25	$1,704,440
186	$7,520
113	$91,810
125	$138,850
197	$167,530
25	$227,840
288	$265,610
163	$648,080
78	$1,031,620
25	$1,262,430
38	$1,288,930
65	$881,610
220	$1,510
247	$348,180
200	$465,330
108	$1,928,340
163	$2,286,180
163	$438,150
150	$464,800
200	$3,555,520
138	$309,020
213	$1,130,350
244	$85,050
163	$86,740
122	$164,030
125	$428,000
56	$550,990
99	$980,210
125	$1,354,090
103	$2,014,200
163	$2,119,740
125	$2,494,860
318	$2,612,990
75	$1,614,960
90	$304,770
175	$1,777,620
50	$1,795,810
238	$164,380
50	$225,640
238	$1,253,280
138	$3,623,530
25	$213,790
175	$667,490
231	$208,040
113	$215,470
50	$261,690
125	$304,840
260	$313,920
200	$848,640
136	$1,022,410
225	$1,415,270
163	$1,466,850
175	$1,675,520
163	$2,684,500
117	$896,590
102	$610,290
271	$1,558,510
250	$1,103,730
159	$1,155,910
81	$1,593,050
187	$1,104,390
175	$213,850
150	$147,190
107	$251,790
175	$862,430
203	$1,126,880
180	$1,770,150
150	$1,815,480
52	$1,856,190
238	$2,341,280
250	$2,422,510
119	$3,322,410
218	$3,686,490
150	$1,329,500
125	$1,902,480
313	$1,815,760
153	$95,410
151	$2,479,660
250	$1,461,260
301	$1,002,750
275	$447,140
35	$318,170
238	$445,310
74	$617,690
150	$700,480
175	$1,491,960
135	$2,158,950
181	$2,551,680
66	$2,901,970
175	$1,505,150
266	$509,840
300	$954,030
188	$3,494,070
75	$1,330,460
263	$3,680
139	$2,150,330
80	$1,606,730
95	$2,395,060
101	$214,400
147	$2,879,810
37	$128,050
138	$160,040
150	$2,702,290
25	$1,175,160
63	$2,399,580
259	$2,312,340
190	$364,600
200	$535,790
25	$2,050,750
89	$2,575,280
50	$1,886,640
250	$2,442,290
175	$2,612,920
63	$634,330
147	$1,258,320
100	$2,202,110
75	$602,780
240	$1,758,320
138	$1,374,870
303	$697,050
37	$2,407,380
25	$407,050
75	$1,675,050
163	$417,030
200	$172,020
194	$2,286,140
218	$1,483,870
75	$2,385,560
43	$2,675,150
313	$2,521,980
50	$1,606,600
50	$2,394,550
125	$1,414,570
75	$1,706,550
25	$278,430
160	$344,730
131	$2,455,360
75	$2,672,570
233	$2,927,250
213	$1,821,970
80	$1,467,650
220	$1,214,330
63	$1,019,380
100	$221,950
233	$2,468,670
188	$2,679,160
173	$1,748,020
43	$3,052,500
120	$221,000
168	$290,880
259	$309,780
266	$311,480
40	$1,674,860
181	$2,671,370
298	$1,790,090
75	$2,163,120
125	$2,569,830
263	$563,410
250	$2,073,950
175	$2,831,080
202	$552,820
50	$1,281,260
185	$2,084,380
100	$3,266,900
225	$6,440
76	$1,887,180
250	$289,050
260	$3,060,820
135	$763,750
160	$2,010,160
202	$1,068,400
165	$2,489,590
106	$375,560
150	$603,180
158	$1,438,150
90	$3,035,710
25	$3,073,840
75	$3,568,880
225	$2,533,680
252	$186,850
138	$2,785,960
85	$3,415,480
113	$1,878,900
89	$3,601,130
158	$3,526,390
138	$2,996,500
221	$624,100
275	$1,150,880
125	$1,437,460
105	$3,061,600
194	$377,940
66	$3,429,650
155	$2,787,080
73	$2,573,160
64	$3,286,290
247	$379,960
225	$2,717,770
301	$386,230
100	$589,820
64	$251,160
25	$366,640
25	$584,060
200	$3,255,570
184	$1,375,880
130	$1,347,950
167	$261,290
50	$548,630
50	$2,673,470
150	$1,699,420
263	$280,500
229	$2,600,990
31	$396,120
73	$252,250
233	$299,680
75	$495,530
43	$1,555,360
241	$6,540
228	$3,000,910
105	$2,682,130
86	$3,141,560
256	$335,050
175	$351,160
250	$900,750
159	$935,280
178	$2,756,590
85	$2,217,530
98	$636,580
150	$3,283,850
25	$316,970
196	$396,860
99	$3,188,300
229	$3,279,120
177	$3,180,010
190	$164,400
194	$485,140
214	$3,742,960
195	$272,500
100	$513,950
244	$394,010
125	$1,848,880
250	$241,130
225	$534,580
100	$450,830
175	$398,500
143	$367,190
80	$2,642,380
150	$2,944,890
225	$298,390
35	$487,690
90	$1,090,550
155	$3,453,110
50	$2,788,190
68	$605,670
162	$3,009,820
213	$2,691,460
225	$3,552,970
88	$2,403,780
75	$2,503,590
181	$3,613,360
113	$3,588,050
89	$767,450
75	$3,580,580
25	$514,140
58	$644,090
175	$2,202,780
225	$1,285,810
71	$604,960
25	$696,640
225	$2,761,100
155	$1,303,660
67	$2,508,020
250	$1,011,300
100	$483,740
125	$1,506,000
75	$3,031,790
141	$527,490
180	$2,337,340