I can't figure out the formulas for the relative frequencies and how it relates to the data given with the BINS. This is done in excel

Using an Excel function, generate a mean and standard deviation for the PATIENTS SIZE variable.

Separate the sample into several logical groups based on the PATIENTS SIZE variable. Please use the following bins: 50, 100, 150, 200, 250, 300, and 350.

Construct a frequency table with the frequencies, relative frequencies (in percent), and cumulative relative frequencies for each group based on the "PATIENTS SIZE" variable.

• The "Descriptors" columns are the labels for each group that you created.
• Show the Histogram table that you used to build your frequency table.
• Calculate the relative frequencies.

ID	PATIENT SIZE	REVENUE
1	125	$3,800
2	100	$4,330
3	164	$4,480
4	130	$5,740
5	75	$7,930
6	213	$9,020
7	163	$10,840
8	145	$15,750
9	25	$17,980
10	163	$19,720
11	225	$27,500
12	225	$28,770
13	144	$29,110
14	82	$30,730
15	213	$31,490
16	150	$35,900
17	276	$35,900
18	263	$39,780
19	125	$42,580
20	286	$51,470
21	200	$54,030
22	100	$57,960
23	138	$60,250
24	225	$65,790
25	206	$66,410
26	238	$68,270
27	125	$68,690
28	78	$71,910
29	88	$72,460
30	88	$77,840
31	170	$81,780
32	55	$82,010
33	248	$85,780
34	216	$96,840
35	150	$98,800
36	40	$900,000
37	114	$10,140
38	213	$101,460
39	250	$215,450
40	244	$822,290
41	220	$14,190
42	150	$89,790
43	153	$12,250
44	147	$180,260
45	252	$1,800
46	75	$19,010
47	175	$155,540
48	100	$1,620
49	175	$189,970
50	160	$7,920
51	39	$7,920
52	77	$1,400
53	113	$104,090
54	141	$157,630
55	175	$809,450
56	304	$184,550
57	250	$150,830
58	75	$153,020
59	308	$164,290
60	93	$173,570
61	138	$183,390
62	104	$203,840
63	194	$204,120
64	253	$205,860
65	150	$213,880
66	169	$228,760
67	50	$260,750
68	250	$306,610
69	25	$431,540
70	156	$557,080
71	125	$608,780
72	105	$671,900
73	178	$1,374,720
74	25	$8,300
75	119	$201,390
76	100	$225,750
77	118	$44,430
78	158	$96,210
79	201	$90,470
80	153	$1,960
81	50	$687,550
82	103	$1,570
83	103	$1,550
84	118	$432,210
85	238	$113,540
86	170	$324,150
87	173	$2,360
88	114	$17,650
89	100	$57,860
90	50	$85,930
91	215	$126,150
92	203	$141,560
93	236	$179,640
94	155	$183,690
95	249	$317,610
96	87	$342,150
97	169	$549,000
98	314	$4,610
99	50	$199,840
100	135	$188,260
101	150	$189,640
102	175	$190,990
103	188	$236,660
104	125	$243,780
105	213	$251,880
106	150	$261,840
107	100	$284,350
108	44	$291,990
109	100	$313,510
110	102	$314,250
111	97	$317,790
112	73	$328,840
113	75	$342,450
114	197	$399,840
115	25	$450,940
116	106	$467,090
117	113	$518,250
118	163	$569,580
119	25	$640,910
120	238	$406,750
121	242	$777,030
122	125	$5,410
123	169	$7,650
124	88	$191,380
125	163	$214,460
126	253	$352,200
127	90	$294,450
128	210	$451,960
129	150	$227,900
130	63	$471,420
131	130	$361,410
132	200	$151,930
133	100	$549,350
134	225	$146,420
135	150	$154,600
136	83	$160,110
137	25	$178,660
138	223	$332,870
139	100	$679,300
140	216	$1,370
141	156	$310,810
142	261	$263,020
143	188	$267,740
144	250	$273,640
145	244	$297,780
146	111	$309,760
147	69	$355,070
148	316	$360,090
149	113	$368,380
150	115	$394,900
151	125	$408,960
152	136	$426,960
153	183	$488,510
154	150	$496,430
155	175	$538,790
156	80	$562,940
157	76	$665,770
158	199	$680,150
159	30	$742,370
160	100	$867,780
161	175	$882,860
162	125	$1,355,760
163	160	$2,584,960
164	75	$201,530
165	85	$151,560
166	144	$272,980
167	57	$536,350
168	250	$162,660
169	193	$169,160
170	77	$835,650
171	141	$222,750
172	81	$339,310
173	150	$1,018,280
174	25	$352,270
175	150	$393,590
176	175	$314,420
177	25	$358,720
178	150	$388,710
179	100	$456,980
180	50	$600,140
182	63	$2,290
183	177	$168,960
184	200	$436,780
185	100	$306,590
186	65	$206,310
187	144	$609,550
188	86	$341,760
189	25	$331,550
190	65	$334,380
191	228	$341,710
192	186	$347,740
193	188	$418,070
194	175	$422,520
195	160	$428,570
196	84	$430,890
197	160	$481,850
198	209	$513,140
199	123	$575,810
200	175	$606,660
201	88	$625,340
202	80	$645,890
203	90	$682,430
204	254	$758,500
205	218	$803,190
206	175	$889,560
207	157	$1,137,180
208	89	$1,361,060
209	288	$1,376,760
210	51	$1,836,370
212	50	$231,740
213	200	$5,530
214	63	$649,900
215	118	$374,330
216	74	$699,210
217	166	$1,860
218	205	$357,750
219	40	$210,790
220	213	$350,690
221	90	$350,820
222	88	$504,600
223	38	$835,560
224	235	$283,930
225	175	$4,580
226	55	$479,610
227	125	$433,500
228	28	$291,070
229	38	$1,078,820
230	100	$454,990
231	162	$135,550
232	150	$155,190
233	304	$155,780
234	228	$180,510
235	175	$235,880
236	225	$237,270
237	83	$282,360
238	250	$391,780
239	246	$409,590
240	146	$441,290
241	59	$492,740
242	158	$496,510
243	260	$501,820
244	138	$512,840
245	50	$512,840
246	125	$525,950
247	232	$576,200
248	108	$585,600
249	25	$664,380
250	108	$724,330
251	204	$728,730
252	77	$810,670
253	230	$1,214,130
254	143	$2,075,980
255	188	$808,100
256	225	$418,720
257	225	$392,540
258	215	$863,360
259	76	$168,130
260	111	$801,930
261	70	$564,800
262	181	$4,930
263	25	$61,250
264	65	$175,910
265	88	$300,440
266	144	$653,120
267	25	$780,360
268	102	$927,850
269	150	$328,180
270	79	$187,990
271	95	$290,180
272	240	$340,330
273	154	$359,860
274	125	$392,690
275	100	$400,490
276	25	$425,840
277	250	$429,870
278	133	$577,450
279	96	$662,420
280	84	$697,330
281	75	$731,490
282	65	$733,850
283	25	$755,540
284	148	$930,270
285	81	$960,260
286	78	$998,190
287	163	$1,040,310
288	75	$1,069,910
289	150	$1,199,720
290	265	$1,994,630
291	175	$110,210
292	61	$229,340
293	25	$525,980
294	83	$1,193,310
295	135	$476,660
296	66	$1,414,210
297	313	$215,330
298	188	$3,020
299	108	$268,930
300	188	$283,950
301	108	$463,530
302	100	$496,080
303	75	$1,342,200
304	221	$48,000
305	128	$315,040
306	128	$487,610
307	95	$590,440
308	41	$378,510
309	79	$385,290
310	175	$473,190
311	290	$540,390
312	250	$674,910
313	225	$720,890
314	133	$790,610
315	70	$801,120
316	253	$850,370
317	200	$1,286,800
318	217	$1,665,720
319	70	$2,036,700
320	110	$809,450
321	196	$1,294,780
322	175	$732,660
323	65	$1,115,040
324	244	$203,500
325	150	$260,000
326	213	$275,140
327	202	$580,410
328	107	$883,490
329	230	$1,364,480
330	188	$1,474,730
331	218	$334,330
332	125	$984,850
333	150	$88,610
334	149	$236,060
335	299	$707,340
336	163	$169,680
337	100	$310,510
338	200	$348,580
339	113	$350,630
340	163	$519,230
341	69	$583,870
342	125	$595,250
343	208	$681,260
344	127	$746,510
345	70	$941,020
346	163	$981,020
347	150	$1,312,780
348	138	$1,372,630
349	100	$1,594,080
350	116	$1,882,580
351	151	$2,684,940
352	213	$159,460
353	145	$1,335,650
354	220	$3,550
355	175	$116,440
356	94	$636,720
357	62	$5,720
358	131	$1,341,060
359	219	$172,530
360	129	$1,473,340
361	230	$2,210,770
362	215	$295,020
363	250	$1,172,400
364	88	$851,610
365	125	$1,359,800
366	188	$104,520
367	184	$112,800
368	189	$131,310
369	175	$285,440
370	63	$289,450
371	75	$433,220
372	185	$517,370
373	246	$751,790
374	63	$819,530
375	175	$1,087,820
376	57	$1,175,960
377	190	$1,678,720
378	150	$1,803,740
379	150	$2,098,250
380	25	$2,392,940
382	127	$583,210
383	74	$1,121,750
384	155	$1,456,050
385	25	$771,460
386	213	$152,660
387	236	$289,190
388	155	$206,240
389	158	$156,520
390	188	$901,640
391	57	$2,410
392	159	$551,570
393	98	$1,203,370
394	25	$543,740
395	138	$581,060
396	175	$753,800
397	25	$1,704,440
398	186	$7,520
399	113	$91,810
400	125	$138,850
401	197	$167,530
402	25	$227,840
403	288	$265,610
404	163	$648,080
405	78	$1,031,620
406	25	$1,262,430
407	38	$1,288,930
408	65	$881,610
409	220	$1,510
410	247	$348,180
411	200	$465,330
412	108	$1,928,340
413	163	$2,286,180
414	163	$438,150
415	150	$464,800
416	200	$3,555,520
417	138	$309,020
418	213	$1,130,350
419	244	$85,050
420	163	$86,740
421	122	$164,030
422	125	$428,000
423	56	$550,990
424	99	$980,210
425	125	$1,354,090
426	103	$2,014,200
427	163	$2,119,740
428	125	$2,494,860
429	318	$2,612,990
430	75	$1,614,960
431	90	$304,770
432	175	$1,777,620
433	50	$1,795,810
434	238	$164,380
435	50	$225,640
436	238	$1,253,280
437	138	$3,623,530
438	25	$213,790
439	175	$667,490
440	231	$208,040
441	113	$215,470
442	50	$261,690
443	125	$304,840
444	260	$313,920
445	200	$848,640
446	136	$1,022,410
447	225	$1,415,270
448	163	$1,466,850
449	175	$1,675,520
450	163	$2,684,500
451	117	$896,590
452	102	$610,290
453	271	$1,558,510
454	250	$1,103,730
455	159	$1,155,910
456	81	$1,593,050
457	187	$1,104,390
458	175	$213,850
459	150	$147,190
460	107	$251,790
461	175	$862,430
462	203	$1,126,880
463	180	$1,770,150
464	150	$1,815,480
465	52	$1,856,190
466	238	$2,341,280
467	250	$2,422,510
468	119	$3,322,410
469	218	$3,686,490
470	150	$1,329,500
471	125	$1,902,480
472	313	$1,815,760
473	153	$95,410
474	151	$2,479,660
475	250	$1,461,260
476	301	$1,002,750
477	275	$447,140
478	35	$318,170
479	238	$445,310
480	74	$617,690
481	150	$700,480
482	175	$1,491,960
483	135	$2,158,950
484	181	$2,551,680
485	66	$2,901,970
486	175	$1,505,150
487	266	$509,840
488	300	$954,030
489	188	$3,494,070
490	75	$1,330,460
491	263	$3,680
492	139	$2,150,330
493	80	$1,606,730
494	95	$2,395,060
495	101	$214,400
496	147	$2,879,810
497	37	$128,050
498	138	$160,040
499	150	$2,702,290
500	25	$1,175,160
502	63	$2,399,580
503	259	$2,312,340
504	190	$364,600
505	200	$535,790
506	25	$2,050,750
507	89	$2,575,280
508	50	$1,886,640
509	250	$2,442,290
510	175	$2,612,920
511	63	$634,330
512	147	$1,258,320
513	100	$2,202,110
514	75	$602,780
515	240	$1,758,320
516	138	$1,374,870
517	303	$697,050
518	37	$2,407,380
519	25	$407,050
520	75	$1,675,050
521	163	$417,030
522	200	$172,020
523	194	$2,286,140
524	218	$1,483,870
525	75	$2,385,560
526	43	$2,675,150
527	313	$2,521,980
528	50	$1,606,600
529	50	$2,394,550
530	125	$1,414,570
531	75	$1,706,550
532	25	$278,430
533	160	$344,730
534	131	$2,455,360
535	75	$2,672,570
536	233	$2,927,250
537	213	$1,821,970
538	80	$1,467,650
539	220	$1,214,330
540	63	$1,019,380
541	100	$221,950
542	233	$2,468,670
543	188	$2,679,160
544	173	$1,748,020
546	43	$3,052,500
547	120	$221,000
548	168	$290,880
549	259	$309,780
550	266	$311,480
551	40	$1,674,860
552	181	$2,671,370
553	298	$1,790,090
554	75	$2,163,120
555	125	$2,569,830
556	263	$563,410
557	250	$2,073,950
558	175	$2,831,080
559	202	$552,820
560	50	$1,281,260
561	185	$2,084,380
562	100	$3,266,900
563	225	$6,440
564	76	$1,887,180
565	250	$289,050
566	260	$3,060,820
567	135	$763,750
568	160	$2,010,160
569	202	$1,068,400
570	165	$2,489,590
571	106	$375,560
572	150	$603,180
573	158	$1,438,150
574	90	$3,035,710
575	25	$3,073,840
576	75	$3,568,880
577	225	$2,533,680
578	252	$186,850
579	138	$2,785,960
580	85	$3,415,480
581	113	$1,878,900
582	89	$3,601,130
583	158	$3,526,390
584	138	$2,996,500
585	221	$624,100
586	275	$1,150,880
587	125	$1,437,460
588	105	$3,061,600
591	194	$377,940
592	66	$3,429,650
593	155	$2,787,080
594	73	$2,573,160
595	64	$3,286,290
597	247	$379,960
598	225	$2,717,770
600	301	$386,230
601	100	$589,820
602	64	$251,160
603	25	$366,640
604	25	$584,060
605	200	$3,255,570
606	184	$1,375,880
607	130	$1,347,950
608	167	$261,290
609	50	$548,630
610	50	$2,673,470
612	150	$1,699,420
613	263	$280,500
616	229	$2,600,990
617	31	$396,120
618	73	$252,250
619	233	$299,680
620	75	$495,530
621	43	$1,555,360
622	241	$6,540
623	228	$3,000,910
627	105	$2,682,130
630	86	$3,141,560
631	256	$335,050
632	175	$351,160
635	250	$900,750
639	159	$935,280
640	178	$2,756,590
642	85	$2,217,530
643	98	$636,580
644	150	$3,283,850
645	25	$316,970
646	196	$396,860
647	99	$3,188,300
648	229	$3,279,120
652	177	$3,180,010
653	190	$164,400
654	194	$485,140
655	214	$3,742,960
657	195	$272,500
659	100	$513,950
663	244	$394,010
664	125	$1,848,880
667	250	$241,130
668	225	$534,580
669	100	$450,830
670	175	$398,500
671	143	$367,190
672	80	$2,642,380
675	150	$2,944,890
676	225	$298,390
678	35	$487,690
679	90	$1,090,550
681	155	$3,453,110
683	50	$2,788,190
685	68	$605,670
687	162	$3,009,820
689	213	$2,691,460
694	225	$3,552,970
696	88	$2,403,780
698	75	$2,503,590
699	181	$3,613,360
703	113	$3,588,050
704	89	$767,450
709	75	$3,580,580
711	25	$514,140
714	58	$644,090
722	175	$2,202,780
725	225	$1,285,810
726	71	$604,960
728	25	$696,640
729	225	$2,761,100
732	155	$1,303,660
733	67	$2,508,020
743	250	$1,011,300
744	100	$483,740
746	125	$1,506,000
750	75	$3,031,790
760	141	$527,490
763	180	$2,337,340