Reference no: EM133497090
Assignment: Healthcare Analytics Applications
Course Outcome for Assignment:
1) Evaluate research designs, data sources, data collection, and analytical methods.
2) Apply health informatics research using standard design, tools, and techniques.
Instructions
1) 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.)
a) What are these Excel functions that are listed above, and what purpose would you use them in data analytics for your facility?
2) Submit an Excel Spreadsheet, showing your work on the following:
a) 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)
b) Use this Excel File for the Patient Healthcare Data (Excel Worksheet)
Discussions
Compare three data analytical tools - Excel, R, and Python - for their advantages/disadvantages in performing data analytics in healthcare.
Then, come up with an example:
A. Define the provider business type, size, and industry of healthcare services (real or fictitious)
B. Define your job as an analyst in this organization (identify the department, application of the data tools, and such)
C. Assess Excel, R, and Python as they could be used in that organization
D. Which tool would you prefer to use? Why (comparing to the other two)?