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