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

The Answer is in the image, click to view ...

Question: Coefficient of Correlation in Excel - Both Variables (Correlation - Excel Only) In the PART II tab in Excel, use an Excel function to generate

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

HCA 507 Assignment 2 Part B You have collected data from several physician practices. Here are the variables: ID is simply the sequential identification number for each physician practice. PATIENTS...

Please help me. 'v'a rious demographic and cardiovascular risk factors were collected as a part of the Prevention of REnal and Vascular END-stage Disease [PREVENDII study, which took plaoe in the...

please help me. 'v'a rious demographic and cardiovascular risk factors were collected as a part of the Prevention of REnal and Vascular END-stage Disease [PREVENDII study, which took plaoe in the...

ID Salary Compa Midpoint Age 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 66.6 26.4 35.3 56 47.5 75.5 41.5 22.8 74 24.1 23.6 63.4 41.4 23 23.6 44.1...

State OwnershipRates totalGuns MortalityRates1 totalDeaths Alabama 55.5 161641 23.6 1141 Col B&C from https://worldpopulationreview.com/state-rankings/gun-ownership-by-state Alaska 64.5 15824 23.5...

Set Student Name: 1. Describe the relationship between two variables that have a correlation coefficient value: a. Near -1 b. Near 0 c. Near 1 2. Data was collected where a weightlifter was asked to...

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

AGEC 440 Homework #3 100 Points Available This Homework Will Use the Homework 3 Excel Data Sheet (Data Tab) Please carry any decimals out two places if numbers are involved in your answer. 1....

7. The purpose of this question is to familiarise you with the use of regression analysis to calculate the parameters of the market model and to interpret these parameter estimates and selected...

ID Salary Compa Midpoint Age 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 60 26.8 34.7 57.9 48.5 74.3 42 23.6 74.2 22.6 23.4 61.7 41.3 22.9...

A pet project of top management has been given the green light. You are assigned the task of leading a cross-functional team that includes a 20 year veteran to the company, a recent college graduate...

R.K. Boats Inc. is in the process of making some major investments for growth and is interested in calculating their cost of equity so as to be able to correctly estimate their adjusted WACC. The...

EA 7 . - The Sarbanes - Oxley Act deters fraudulent behavior by protecting whistleblowers and increasing penalties for fraud.Group of answer choicesTrueFalse

1) List a specific example of an activity that a bicycle shop can do in each of the 3 purchasing Phases to attract customers and get them to buy more than they planned. 2) using the concepts learned...

2. What we can learn from the past

17. In a communication context (choose which one), put plus (+) for the areas you find easy to perform and minus (-) for the areas you find difficult to perform. a. to present something to a larger...

2. Develop a good and lasting relationship