logo Hurry, Grab up to 30% discount on the entire course
Order Now logo
380 Times Downloaded

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Jyoti PrajapatiStatistics
(/5)

940 Answers

Hire Me
expert
rahul kumarOthers
(/5)

913 Answers

Hire Me
expert
Vishal BhadwajAccounting
(5/5)

562 Answers

Hire Me
expert
Pankaj KukrejaSociology
(5/5)

516 Answers

Hire Me
Tableau
(5/5)

I need a dashboard link, report, and presentation for the analysis answering the questions

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

I need a dashboard link, report, and presentation for the analysis answering the questions

 

Present your findings from an analysis on the attached dataset. The presentation will be 10 minutes long. Feel free to use whatever software package you like for this analysis.

 

The attached file is a sample dataset showing a list of all inpatients that were discharged from a hospital in the years 2013, 2014 and 2015. Each row represents 1 discharge. One of the most important variables for hospitals is Length of Stay (LOS). LOS is the number of days a patient spends in hospital. Patients staying longer than necessary can lead to hospitals requiring additional beds and can also lead to increased numbers of patients on trolleys due to reduced bed availability.

 

The points we would like you to cover in your analysis of the dataset are (but not limited to):

·  Activity (i.e. the number of discharges)

·  Length of Stay

o What areas would you target in an attempt to reduce Length of Stay and why?

·  Number of beds required to house the patients in this dataset (hint: there are 365 days in the year)

·  How many patients were in the hospital at 5am on 30/09/2014?

·  Create a field that groups patients into adult and child categories.

·  Predict the hospital’s bed requirement if the average age of patients increased by 20%

 

 

(5/5)
Attachments:

Expert's Answer

380 Times Downloaded

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme