Do question 6 For this midterm, answer the questions below and answer using what

Do question 6
For this midterm, answer the questions below and answer using what you’ve learned this semester. You must upload your R code as a .R file or markdown file. Please provide an explanation describing your results in the comments or markdown text. Any graphs and tables must have appropriate labels and titles and not show direct variable names.
This is a group assignment – you will submit one file per group. Your code must run when given the data provided (we can set the working directory etc.). If not, you will lose 25 points.
1. Using the “Oxygen_Delivery” sheet, find the maximum Exhaled Tidal volume per patient per day. Is the average maximum title volume across patients higher in March of 2020, or May of 2020?
2. Recategorize the Race variable as African-American or Other. Which lab from the “Long_Labs” sheet has the greatest difference between averages given this grouping?
3. Was there a difference in vital signs (systolic bp, diastolic bp, map cuff/arterial, heart rate, respiratory rate, temperature) among those who died and those who survived? Please write code to capture the median of each vital for each group.
4. Is there a difference in the IQR of patients’ initial c-reactive protein, d-dimer, or white blood cell count based on the patient’s individual code status? Use code to support your answer.
5.Categorize BMI as Underweight (<=18), Normal (<=25), Overweight (<=30), and Obese (>30). Which of these groups had the highest death rate (people who died / people within group)?
6. Filter the “Long_Labs” sheet so the only values that remain are between a patient’s ICU admission and discharge (ICU_Admit_DEID and ICU_DC_DEID from “Main_Dataset”). Sumarize the distribution and characteristics of the various values remaining.
7. Develop one question about any of the sheets (or multiples of them) and answer it with the data. Have it approved in email by Alex or Chad.