Course Outcome for Assignment: Evaluate research designs, data sources, data collection, and analytical methods. Apply health informatics research

 

Course Outcome for Assignment: 

  • Evaluate research designs, data sources, data collection, and analytical methods.
  • Apply health informatics research using standard design, tools, and techniques.

Assignment Instructions:

  • The most common Excel functions used for data analytics are VLOOKUP (), CONCATENATE, LEN, COUNTA, COUNTIFS, SUMIFS, FIND/SEARCH, AVERAGEIFS. IFERROR, LEFT/RIGHT, RANK, MINIFS, MAXIFS, SUMPRODUCT. Provide a Response to the Following: (Note: The answer can be presented in a table format.) 
    • What are these Excel functions that are listed above, and what purpose would you use them in data analytics for your facility?  
  • Submit an Excel Spreadsheet, showing your work on the following:
    • Perform the statistical calculations (Average, Min, Max, Mean, Mode, Median, Standard Deviation) on the provided Patient Healthcare Data file for each of the parameter (weight, height, pulse, age)
    • Use this Excel File for the Patient Healthcare Data (Excel Worksheet)
    • Analyse what this data and your calculations mean for this specific patient healthcare dataset. How your analysis can be used for HC managerial decision making. 
    • Revised
      1. Most common Excel functions used for data analytics are VLOOKUP (), CONCATENATE, LEN, COUNTA, COUNTIFS, SUMIFS, FIND/SEARCH, AVERAGEIFS. IFERROR, LEFT/RIGHT, RANK, MINIFS, MAXIFS, SUMPRODUCT.
        •  Explain these Excel functions and how would you use them in data analytics for your facility?  
      2. Using data on weight, height, pulse, age (columns B, C, D, E and rows 2-21) in the attached Excel file (Patient Healthcare Data (Excel Worksheet): /content/enforced/1061132-M_026921-01-2242/Patient Healthcare Data2.xlsx
      3. Perform calculations for each parameter (weight, height, pulse, age) with the built-in Excel functions and enter in columns A against each function: Average, Min, Max, Mean, Mode, Median, Standard Deviation
      4. As a healthcare manager, how would you use these data in healthcare decision-making for facility you may be working for? 

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

CapstoneDesign and Analysis of a Simple Computer SystemObjective: Students will

Capstone Design and Analysis of a Simple Computer System Objective: Students will design, simulate, and analyze the architecture of a simplified computer system, applying concepts from Stephen D. Burd’s materials such as the CPU, memory hierarchy, I/O, and instruction set architecture (ISA). Components: 1. System Design: . CPU Design: Create

Please see attached detailsDAT 250 Project Two: Organizational Scenarios Scenario A: AmityTech Solutions (CCPA and GDPR) AmityTech Solutions is

Please see attached details DAT 250 Project Two: Organizational Scenarios Scenario A: AmityTech Solutions (CCPA and GDPR) AmityTech Solutions is a well-established technical management company based in North America, providing comprehensive data management services to businesses across various industries. AmityTech specializes in offering secure data solutions, robust server infrastructure management,

see attachment for detailsAs you have read Lesson 8: Identifying and Mitigating Accountability Risk in uCertify Certified Ethical Emerging

see attachment for details As you have read Lesson 8: Identifying and Mitigating Accountability Risk in uCertify Certified Ethical Emerging Technologist, consider an industry with ambiguous data privacy regulations. Responsibility Assignment Matrices (RACI) can build accountability and help safeguard data. Pick one of the following hypothetical scenarios where a company