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
- 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?
- 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
- 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
- As a healthcare manager, how would you use these data in healthcare decision-making for facility you may be working for?
- 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.