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?