Health & Medical Homework Help

Required Reading This module requires you to use Microsoft Excel. If you are not familiar with this program, there are many ways to get assistance with learning. A link to the Microsoft Excel basic skills page is provided. If you prefer video tutorials, feel free to search YouTube or other appropriate platforms. I encourage you to share links to videos and other resources you find particularly helpful with your classmates. Microsoft Basic Tasks in Excel https://support.office.com/en-us/article/basic-tasks-in-excel-dc775dd1-fa52-430f-9c3c-d998d1735fca The required Excel data workbook is available for download in the module folder. Recommended Resources None Module Activities NOTE: Work for all activities should be on the same Excel file. Post your Excel file addressing activities 1-3 to the module discussion board by midnight on Friday. Activity 1: Using the required Excel worksheet, complete the following data cleaning activities. • Remove all non-number characters (including spaces) from cells in the following rows: o SBP o RESP o PULSE o GCS o Motor o ISS • Identify how many missing values there are for each variable – give the raw number and % of total • Post links to any Excel tutorial you found helpful for this activity Activity 2: Create a new variable to help identify patients classified as being in hypovolemic shock. • Use the SBP variable values to create the shock variable (create a new column in the existing sheet). • Code SBP < 90 mm Hg as being 0. • Code SBP > 90 mm Hg as being 1. • Identify how many patients were classified as being in shock – raw number and % of total • Post links to any Excel tutorial you found helpful for this activity Activity 3: Recode the mode of transport to be either HEMS or GEMS regardless of transport origin. • Create a new column in the Excel sheet • AS and AT are GEMS transports (ambulance) • HS and HT are HEMS transports (helicopter) • Identify how many patients were HEMS – raw number and % of total • By year, identify how many patients were HEMS – raw number and % per year • Post links to any Excel tutorial you found helpful for this activity Activity 4: Compare your raw numbers and % for activities 1-3 with at least 2 other students. • Do the numbers match? • If not, see if you can identify the reason and help resolve the issue. • Post your responses by midnight on Sunday. Module Grading • Full Credit (10 points): All required postings present. Initial postings completed by midnight on Friday. Response postings completed by midnight on Sunday. • Partial Credit (5 points): Missing required postings or elements.