Required Reading This module requires you to use Microsoft Excel

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.  

Don't use plagiarized sources. Get Your Custom Essay on
Required Reading This module requires you to use Microsoft Excel
Just from $13/Page
Order Essay
Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
Live Chat+1(978) 822-0999EmailWhatsApp

Order your essay today and save 20% with the discount code GOODESSAY