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

Creating a plan Competencies7035.1.1  :  Health Information Systems and Business Process The graduate explains

Creating a plan  Competencies 7035.1.1  :  Health Information Systems and Business Process The graduate explains how information systems affect business processes within the healthcare industry. 7035.1.2 :  Systems Development The graduate analyzes the different methods of system development for the purpose of recommending an appropriate method for a project. 7035.1.3 :  Health Information

The topic is Katherine JohnsonKatherine Johnson, an American mathematician, played a crucial role in NASA’s space missions. She excelled at orbital

The topic is Katherine Johnson Katherine Johnson, an American mathematician, played a crucial role in NASA’s space missions. She excelled at orbital mechanics calculations and pioneered the use of computers. During her 33-year tenure at NASA, Johnson calculated trajectories, launch windows, and emergency return courses for the Project Mercury, Apollo

 Hiring a local digital marketing agency in Los Angeles offers numerous advantages. A digital marketing agency in Los Angeles, like Matebiz Pvt Ltd,

 Hiring a local digital marketing agency in Los Angeles offers numerous advantages. A digital marketing agency in Los Angeles, like Matebiz Pvt Ltd, provides personalized services tailored to the unique dynamics of the LA market. Local agencies understand the regional audience, ensuring more effective targeting and engagement. We offer comprehensive

how does medicare certs affect healthcare COMPETENCIES7022.1.3 :  Licensure, Certification, and Accreditation Standards

how does medicare certs affect healthcare  COMPETENCIES 7022.1.3 :  Licensure, Certification, and Accreditation Standards The graduate analyzes how licensing, certification, and accreditation agencies for healthcare organizations impact healthcare delivery at federal, state, local, and organizational levels. 7022.1.4 :  Quality, Reimbursement, and Patient Access to Healthcare The graduate analyzes how relationships between clinical