I need help with how to work on this assignment. I am not get used to with excel. I attached the questions on the file. Please help to guide me step by step to do the excel. Thanks

1.By comparing the admit date to the discharge date, create a column that calculates Length of Stay (days) for patients for whom this data exists.

2.Calculate the number of encounters (not patients) that were emergency room visits; present as percent of total visits.

3.Count the number of patients who had 3 or more emergency room visits

4.Create a separate column called Glucose and tease out glucose value from Column Y - if not available fill NA in cell.

5.The file has ICD-10 codes in multiple columns.Assuming that columnDG1 is the primary (or admitting) diagnosis, rank the most frequent diagnosis for each Emergency Room visit from highest to low.

6.Break down patients' insurance type (i.e. number of patients with Medicare, Medicaid, commercial, etc)

7.Rank the prevalence and type of discharge locations (i.e. home, SNIF, rehab, etc) by encounter.

After working with CMS claims and cost data, this assignment provides real patient information (de- identified to avoid any PHI concerns). This is an actual excerpt of 25 patients [identified by Patient ID) from a file of 10,000 + patients. A few things to note: 1. Some patients have several lines of data so be aware of that when responding to a question about patients or visits/encounters. Some columns contain HL7 type messages (Column Y has all lab information in along data string). Not all cells are complete; depending on the question, only include lines with data for the appropriate question. As you will see, this data is not near as clean as CMS data- CMS data is submitted after the fact (note that data typically goes multi-years back) while this clinical data set is obtained in real time. Clinical dataodsx Tasks: By comparing the admit date to the discharge date, create a column that calculates Length of Stay (days) for patients for whom this data exists. Calculate the number of encounters (not patients) that were emergency room visits; present as percent of total visits. Count the number of patients who had 3 or more emergency room visits Create a separate column called Glucose and tease out glucose value from Column Y if not available fill NA in cell. The file has lCD-10 codes in multiple columns. Assuming that column D61 is the primary (or admitting) diagnosis, rank the most frequent diagnosis for each Emergency Room visit from highest to low. Break down patients' insurance type (i.e. number of patients with Medicare, Medicaid, com mercial, gm) Rank the prevalence and type of discharge locations (i.e. home, SNIF, rehab, 935) by encounter