Executive Solution Overview
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 …
Instant Solution Download
$6.99Immediate access to the full model answer, formatted citations, and rubric breakdown.
Need a Fresh Custom Paper?
Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →Assignment Prompt & Instructions
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)](https://learn.umgc.edu/content/enforced/1340331-026921-01-2252-GO1-9041/Patient%20Healthcare%20Data1.xlsx)
– 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)](https://learn.umgc.edu/content/enforced/1340331-026921-01-2252-GO1-9041/Patient%20Healthcare%20Data1.xlsx): [/content/enforced/1061132-M_026921-01-2242/Patient Healthcare Data2.xlsx](https://learn.umgc.edu/content/enforced/1340331-026921-01-2252-GO1-9041/Patient%20Healthcare%20Data2.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: A _verage, 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?
– 2 years ago