nu Www will compete perform datu ceperform sie data for the celle you will work with is withi wote March mal wiewoni Using online and your experience poem the followme Once you have completed the file within name in the little bit for 1. Formate Tool Collection to display whes 2. decimal places 2. Formate 10MM/DD/YYYY 1. For the entire table Format the couphouer with the area code in parent 5 Credes new tamil Anw 6 How many columns Datab? Type the wintocell Alo Amen" 7. How many rows are in the Day Type dhewerint cell A2 of the Ausweb. & Which patient has the highest Total Changes in the date of Type the name of the partito cell AJ of the Anwestb. 9. In your opinion, why we view, csupan bau forming important to do before it is Type your opinio ell A4 of the web. Please limit your response to 2.3 MRN Name Last 71829711 KAIDE 71829422 MAHIN 71025805 DWYN 71129041 AVALEIGH 71827377 SAFFAH 71826443 KOBEY 71824196 OLLIVER 71829136 1 10 73828490 IFEOLUWA 11 71826922 VAKARE 71523544 HADLEIGH 7182944 EAMONN 14 71823912 SHARAN 71829116 ZAYNE 16 71124788 ZELIA 17 71827988 HARMANNAT 71029257 AMBIKA 13 7533345 ZENA 7102788 MEDHA 21 71625557 HARSHIKA 22 7199 DAREN 71823510 HAFELZ 2127214 TAFARA T1B29240 LAHMARNI 2182344 AYSENUR STAR KRISTIANA Name First KONI KEENAN JOSHUA MADINA AREEBA ALBA ERIC LEWI AZALEA UMME YISROEL OZZY ADAN ERICA ANABELLA TIEGAN LADA MAUD ELOWEN CECE MOHAMED BAXTER OWAIS HARVEER TAYAH D SOK DOB City M May 30, 1920 Garland M October 25, 1950 Sherman M September 3, 1919 Bedford F April 19, 1944 Mabank F. April 22, 1920 DeKalb M September 7, 1982 Groveton M January 14, 1949 Sidney M May 9, 1968 Kemp F July 20, 1978 Dallas F July 31, 1967 Panola M February 25, 1989 Hubbard M June 3, 1979 Irving F November 14, 1986 Killeen F February 14, 1954 Mabank F January 6, 1963 Sadler F March 19, 1973 Bagwell F April 13, 1972 Ennis F July 4, 1999 McGregor F December 7, 1962 Commerce F January 30, 1944 Rhome M September 9, 1985 Mesquite M September 16, 1918 Irene M December 11, 1921 Longview M July 18, 1946 Desoto Manuary 11, 1952 Mexis November 161929 nalla G H State Zip Country Phone E-mail TX 75047 United States 2141347733 KOBIKAIDE4@email.com TX 75091 United States 2144179611 KEENANMAHIN5mail.com TX 76021 United States 2142602536 JOSHUAEDWYN@email.com TX 75156 United States 2148868799 MADINAAVALEIGH5Demail.com TX 75559 United States 2141748060 AREERASAFFAHemail.com TX 75845 United States 4691709617 ALBIKODEYS@email.com TX 76474 United States 2149753503 ERICOLLIVER5@email.com TX 75143 United States 4692503333 LEWW email.com TX 75264 United States 2147249546 AZALEAIFEOLUWASemail.com TX 75685 United States 9722126588 UMMEVAKARES email.com TX 76648 United States 9723206070 YISROELHADLEIGHS@email.com TX 75014 United States 2147749242 OZZYEAMONNSPemail.com TX 76545 United States 9728599120 ADANSHARANS@email.com TX 25147 United States 8174955156 ERICAZAYNE85 email.com TX 76264 United States 8177122309 ANABELLAZELA5email.com TX 75412 United States 8174195411 TIEGANHARMANNATS@email.com TX 75120 United States 2145337683 JADAAMBIKAS@email.com TX 76657 United States 2146547494 MAUDZENABS@email.com TX 75428 United States 2146254750 FLOWENMEDHASemail.com TX 75078 United States 9721430863 CECEHARSHIKASemail.com TX 75187 United States 2142629460 MOHAMEDDARENSmail.com TX 76650 United States 9723468693 BAXTERHAFEEZ4mail.com TX 75607 United States 4657795680 OWAISTAFARA email.com TX 75123 United States 8174341056 HARVEERIAHMARNIS@email.com TX 76667 United States 8175058112 TAYAHAYSENURSDemail.com TY 762 nito at 2145SACIARI R Ave Patient Satisfaction Score 55 97 100 95 10 97 16 94 1. Email 7 ALBIKOLEYS@email.com BERICOLLIVERSmail.com 9 LEWIS email.com 10 AZALEALFEOLUWAS Pemail.com 11 UMMEVAKARES@email.com 12. VISROELHADLEIGHS@email.com 13 OZZYEAMONNSDemail.com 14 ADANSHARANSEDemail.com 15 ERICAZAYNE85 email.com 16 ANABELLAZELIAS@email.com 17 TIEGANHARMANNATS@email.com 18 JADAAMBIKAS Demail.com 19 MAUDZENABS email.com 20 ELOWENMEDHAS@email.com 21 CECEHARSHIKASSmail.com 22 MOHAMEDDARENSPemail.com 23 BAXTERHAFEEZ4email.com 24 OWAISTAFARM email.com 3 HARVEERIAHMARNIS@email.com IG TAYAHAYSENURSDema.com MASMINAKRISTURASmail.com 28 KAYAJADANS mail.com 29 DHILANDARRELLSmail.com 10 MAXIMLASTLOSmail.com 31 AUBREYALLISONS email.com 1 LATAYAM M N Death Date Inpatient Visit Count Outpatient Visit Count Total Charges Total Collection Payer 2 11 149,846 S 26,419 PPO 3 11 $ 149,844 S 44,839 Medicaid 2 SS 149,832 $ 144 087 Medicaid 4 22 $ 149,817 5 80,730 HMO 3 21 5 149 807 $ 115,655 HMO 3 10 S 149,8045 53.048 Medicaid 5 19 S 149,7925 147,405 PPO 25 149.768 $ 26,486 PPO 9 20$ 149,768 5 103,441 Medicare 8 65 149,764 5 5,115 Medicaid 4 26 $ 149,7365 133,591 PPO 9 75 149,7235 139,665 HMO 15 149,6855 121,844 PPO 6 7 $ 149,631 5 142,968 Medicare 5 24 5 149,6045 80 168 PPO 3 19 $ 149,4115 103,159 Medicaid 4 1$ 149.4055 101.928 Medicare 3 18 5 149,3815 83.508 Medicare 4/24/2018 7 19 $ 149,3645 125,858 Medicare 4 26 5 149,3625 5,916 HMO 1 15 149,3365 146,777 HMO 2 65 149,327 S 19,449 Medicaid 5 18 $ 349,2845 BR051 Medicaid 1 95 149,271 $ 57,126 HMO 5 19 $ 149,2255 119,211 MO ILS 189 199 5 100 M 90 99 62 98 95 M 98 100 98 new Tastructions This week we will conductable review of a sample healthcare perform data clip, and perform some basic dates formatting The Excel file you will be working with seved in this week's folder Please that everything completo fictional None of the ware real Using online resources and your past experience perform the following up Once you have completed each step, save the Excel file with you first same in the title and submit it for grading 1 Format the Total Collection column to display values out to decimal places 2. Format the "DO" columnas a MM/DD/YYYY date 3. Format the entire data set as a table 4. Format the "Phone" come as a place be with the sea code in parenthesis 5. Create a new tab and name it "Answers 6. How many columns are in the "Data" by Type the nuwer inte all Al of the Anwentah 7. How many rows are in the "Dastab? Type the swer into cell A2 of the Answers 8. Which patient has the highest Total Charges in the date? Type the name of the patient into cell 3 of the "Answers" tab. 9. In your opinion, why are data review, cleanup, and basic formatting important to do before starting analysis Type your response to cell All of the Answertih. Please limit your response to 3.5 sentences