Based on the Excel chart of patient information: Break the patient data into 5 ranges of 20 ages: 0 - 20, 21 - 40, etc Which age range has the most patients? Type your answer as xx-xx do not have spaces Question 14 0 / 1 pts Based on the Excel chart of patient information: Break the patient data into 5 ranges of 20 ages: 0 - 20, 21 - 40, etc Which age range has the fewest patients? Type your answer as xx-xx do not have spacesA clinic sees 110 patients in January. 80 patients are female. What reduced FRACTION of patients are female Answer using xx/xx as your format - do NOT put spaces before or after the / 80/110 = 8/11Based on the Excel chart of patient information: The mode(s) for these patients ages = ?? If there is one mode = type as xx Multimode = type as xx-xx etc ... 34,60,79A clinic sees 110 patients in January. 20 patients have a family history of heart disease What percentage (to the tenths place) of patients have a family history of heart disease? Answer using xx.x% as your format - use the percent sign and do not put spaces between any of your numbers 18..2%Based on the Excel chart of patient information: "Primary Payer" is a value / variable / frequency / class Pick one answer Question 12 0 / 1 pts Based on the Excel chart of patient information: What is the relative frequency of Medicare patients in this group, rounded to the hundredths place? Type your answer as xx.Xx% Use the percent signBased on the Excel chart of patient information: The cumulative frequency of males ages 21 - 60 who are uninsured = Question 16 0 / 1 pts Based on the Excel chart of patient information: The relative frequency of males ages 21 - 60 who are uninsured = ? Type your answer as X.X% no spaces, use the percent signA clinic sees 110 patients in January. 20 patients are married What reduced FRACTION of patients are married?Dr. Stevenson see 13 patients in 6 hours. What is the rate of patient encounters (to the hundredths place) in minutes? Enter your answer as 1 patient every xx.xx minutesA clinic sees 110 patients in January. 80 patients are female. What reduced FRACTION of patients are female Answer using xx/xx as your format - do NOT put spaces before or after the / 80/110 = 8/11Patients treated January 3, 20XX Patient Name Age Gender Primary Payer Allman, G 8 Male Medicaid Ali, M 54 Female Medicare UI AWN Y Archuleta, J 45 Female Private Insurance Bergstrom, C 68 Female Medicare Butterfield, K 15 Male Private Insurance Cheung, H 22 Female Other Coppola, H 60 Male Medicare Crisp, J 79 Female Medicare 9 D'Onofrio, L 79 Male Medicare 10 Dozier, D 34 Female Uninsured 11 French, C 30 Male Private Insurance 12 Hill, J 44 Male Private Insurance 13 Gilmore, D 14 Male Medicaid 14 Hull, J 18 Female Private Insurance 15 Kapinos, Q 19 Male Uninsured 16 Lee, H 80 Female Medicare 17 Millen, P 33 Male Private Insurance 18 Moye, D 66 Female Medicare 19 Odrick, F 60 Female Private Insurance 20 Parks-Odom, S 75 Female Medicare 21 Parsons, J 49 Female Other 22 Pittman, S 55 Female Private Insurance 23 Powell, A 6 Male Private Insurance 24 Powell, D 72 Female Medicare 25 Royster, W 34 Male Uninsured 26 Scott, G 29 Female Other 27 Tapper, L 58 Female Private Insurance 28 Tays, B 62 Female Private Insurance 29 Verne, G 67 Male Medicare 30 Warner, N 27 Male Uninsured 31 Wisniewski, J 3 Male Private Insurance 32 Zorich, P 81 Female Medicare