Reference no: EM131213127
Assignment: Emergency Room Case
The data included in ED.xls records the time stamps of patient admit times at the emergency department of a large hospital over a five month period (1/1/2003-5/31/2003). For the purposes of this study, we will assume that arrival times and admit times are the same. There are three parts to the assignment. Please read each part carefully.
1. (Data Creation and Manipulation) Using the data available, create the following variables. Do not include any of these answers in your written document.
(a) Numerical variables for month, day of month, day of week, hour, and minute (note: this will create 5 more columns of data, that you need to build).
(b) A variable that reflects the inter-arrival times of patients (time in minutes between successive arrivals).
2. (Data Description) The following questions require you to describe certain aspects of the data. Do not include any of these answers in your written document.
(a) Construct a table showing the average number of patients that arrive on each day of the week.
(b) Plot the average inter-arrival times over the 24 hour period (X axis) for each day of the week (i.e. each day of the week is a separate line on a common plot).
(c) Construct a pivot table that contains the number of patients arriving by hour of day (rows) and day of week (columns).
(d) Construct two pivot tables, one that contains the average and another with the standard deviation of inter-arrival times by hour of day (rows) and day of week (columns).
3. (Analysis and Reporting) Conduct the analyses requested below and create a written document reporting your results and the discussion requested.
(a) Use the results in part 2 (and any additional analysis you need) to construct your best estimate for the average and standard deviation of hourly inter-arrival times for a randomly chosen future MONDAY. Construct a table that shows your estimates of the average inter-arrival times and standard deviation of such times across the 24 period.
Attached is a file with a data set that needs to be manipulated to answer the questions.?
Attachment:- ED.rar
|
System implementation process
: How will the system be used to improve the quality of patient care? Be sure to include reasons why the project planning and system implementation process is so critical to the project's success. This overview should be about a page in length and..
|
|
Are these websites useful to criminals
: Are these websites useful to criminals? What do you find interesting/disturbing about them? Search the Internet to find websites that have hacking tools available for download and use. What kind of information can these sites provide to criminals..
|
|
Recall the definition of functionality
: Recall the definition of functionality (CTQ2) in POI case study. You have inspected 10 boxes of MSDs and couted the number of MSDs that are broken in each box as 10, 9, 5, 4, 5, 9, 6, 6, 9, 11. Based on these samples, you want to claim to your sup..
|
|
Difference between loop antenna and a linear dipole antenna
: If you could measure the magnetic and electric fields of an antenna in the near field, could you tell the difference between a loop antenna and a linear dipole antenna? How?
|
|
Construct a table showing the average number of patients
: (Data Description) The following questions require you to describe certain aspects of the data. Do not include any of these answers in your written document. Construct a table showing the average number of patients that arrive on each day of the we..
|
|
Transactions involving short-term and long-term investments
: Prepare journal entries to record the following transactions involving both the short-term and long-term investments of Cancun Corp., all of which occurred during calendar year 2015. Use the account Short-Term Investments for any transactions that yo..
|
|
What is the practical meaning of this retardation
: The magnetic vector potential of a Hertzian dipole is often called a "retarded magnetic vector potential." What does "retarded" refer to and what is the practical meaning of this retardation?
|
|
Where the offices are located current security in place
: You should describe the organization in detail, providing necessary information such as the size of the organization, type of organization, where the offices are located, current security in place, and what you will seek to address.
|
|
Nonprofit versus for-profit healthcare and organizations
: 1. Use Google search to find a research article(s) (no older than 2001) related to nonprofit versus for-profit healthcare and organizations. Analyze the characteristics of each type of organization and the factors that impact operations. Discuss o..
|