Your IT department provided you data on patients that received ER services, their GHHS, and their recovery time. Prepare a report to share with the owners of the facility that will help you make informed decisions about how long you can expect a patients’ recovery time would be based on their GHHS. Based on your findings provide recommendations on your plan moving forward to improve the functioning of your facilities in generating revenue. Prepare a report that addresses each of these areas.
ID | Recovery Time | GHSS |
137 | 10 | 1 |
141 | 15 | 1 |
165 | 15 | 2 |
197 | 30 | 10 |
140 | 45 | 11 |
126 | 10 | 12 |
156 | 13 | 13 |
110 | 15 | 13 |
160 | 8 | 14 |
135 | 40 | 14 |
121 | 10 | 15 |
197 | 10 | 15 |
132 | 12 | 16 |
119 | 60 | 16 |
128 | 16 | 16 |
197 | 13 | 19 |
134 | 30 | 22 |
197 | 12 | 23 |
155 | 14 | 24 |
130 | 15 | 25 |
150 | 14 | 25 |
112 | 14 | 26 |
108 | 10 | 26 |
100 | 16 | 26 |
161 | 13 | 27 |
163 | 18 | 34 |
117 | 4 | 36 |
169 | 3 | 36 |
144 | 10 | 36 |
106 | 22 | 36 |
123 | 25 | 36 |
157 | 17 | 44 |
158 | 19 | 45 |
129 | 18 | 46 |
197 | 19 | 46 |
159 | 30 | 48 |
197 | 26 | 48 |
177 | 25 | 49 |
142 | 20 | 49 |
115 | 23 | 55 |
193 | 24 | 55 |
102 | 22 | 55 |
170 | 30 | 55 |
186 | 10 | 55 |
197 | 19 | 55 |
113 | 16 | 56 |
182 | 41 | 57 |
197 | 10 | 59 |
124 | 12 | 61 |
183 | 13 | 63 |
143 | 14 | 66 |
197 | 15 | 66 |
120 | 19 | 67 |
178 | 8 | 73 |
111 | 14 | 73 |
127 | 44 | 74 |
166 | 30 | 77 |
152 | 32 | 77 |
139 | 10 | 77 |
109 | 10 | 77 |
197 | 22 | 78 |
176 | 10 | 79 |
131 | 27 | 79 |
197 | 19 | 79 |
197 | 15 | 79 |
197 | 40 | 79 |
138 | 50 | 79 |
180 | 30 | 86 |
197 | 19 | 86 |
197 | 10 | 86 |
192 | 22 | 88 |
197 | 20 | 88 |
145 | 10 | 88 |
116 | 19 | 88 |
149 | 17 | 88 |
197 | 20 | 88 |
196 | 30 | 89 |
185 | 24 | 89 |
190 | 26 | 89 |
148 | 30 | 89 |
151 | 45 | 89 |
197 | 30 | 89 |
164 | 22 | 89 |
114 | 24 | 90 |
162 | 26 | 90 |
167 | 54 | 93 |
133 | 10 | 93 |
118 | 22 | 94 |
194 | 48 | 98 |
179 | 22 | 98 |
174 | 14 | 99 |
181 | 30 | 99 |
136 | 34 | 99 |
197 | 32 | 99 |
107 | 45 | 99 |
125 | 30 | 99 |
57.96875 |
SUMMARY OUTPUT | |||||
Regression Statistics | |||||
Multiple R | 0.2923 | ||||
R Square | 0.0855 | ||||
Adjusted R Square | 0.0757 | ||||
Standard Error | 11.1635 | ||||
Observations | 96 | ||||
ANOVA | |||||
df | SS | MS | F | Significance F | |
Regression | 1 | 1094.7910 | 1094.7910 | 8.7848 | 0.0038 |
Residual | 94 | 11714.5423 | 124.6228 | ||
Total | 95 | 12809.3333 | |||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | |
Intercept | 15.1881 | 2.4649 | 6.1617 | 0.0000 | 10.2940 |
GHSS | 0.1118 | 0.0377 | 2.9639 | 0.0038 | 0.0369 |
recovery time^ = 15.1881 + 0.1118 GHSS
sample size is 96
Hypothesis
p-value = 0.0038
p-value < alpha
hence we reject the null hypothesis
we conclude that GHSS is significant
Your IT department provided you data on patients that received ER services, their GHHS, and their recovery time. Prepare a report to share with the owners of the facility that will help you make infor...
Organization: Freestanding ER Services Title: ER Operations Manager Outline: Multiple Regression: Effect of Age and General Health Status Score on Total ER Cost. Purpose Importance Variables Sample Size Hypothesis Methodology Findings Interpretations/Implications Description of each Section Purpose: Identify the purpose of the analysis in this section. What questions do you hope to answer? Importance: State and explain the importance of this analysis to the department/organization. How will the findings be used? Variables: List all variables, explain how they will be...
You are the manager of a company that owns several outpatient surgery facilities. You want to determine if there are differences in overall patient health as measured by the General Health Status Score (GHSS) by type of patient carrier (Government, Insured, Uninsured). Your IT department provided you data on patient visits by type of carrier and the GHSS. Prepare a report to share with the owners of the facility that will help you make informed decisions about whether or not...
Please show how you did this in excel.
:13-19 Every home football game for the past eight years at Eastern State University has been sold out. The revenues from ticket sales are significant, but the sale of food, beverages, and souvenirs has contrib- uted greatly to the overall profitability of the football program. One particular souvenir is the football pro- gram for each game. The number of programs sold at each game is described by the following probabil- ity distribution:...
Calculate the range, mean, mode, median, Standard deviation Calculate the skewness and kurtosis for the above data and interpret the data. The following is data collected from the daily salary employees of ZZ COMPANY.. 68 19 43 11 37 30 19 67 65 34 96 23 93 73 46 39 21 12 89 52 33 21 18 57 80 56 91 62 56 48 84 23 78 96 49 36 90 42 65 15 43 36 65 59 34 71...
1. Forecast demand for Year 4.
a. Explain what technique you utilized to forecast your
demand.
b. Explain why you chose this technique over others.
Year 3 Year 1 Year 2 Actual Actual Actual Forecast Forecast Forecast Demand Demand Demand Week 1 52 57 63 55 66 77 Week 2 49 58 68 69 75 65 Week 3 47 50 58 65 80 74 Week 4 60 53 58 55 78 67 57 Week 5 49 57 64 76 77...
Write a python nested for loop that prints out the following pattern 100 99 98 97 96 95 94 93 92 91 90 89 88 87 86 85 84 83 82 81 80 79 78 77 76 75 74 73 72 71 70 69 68 67 66 65 64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47 46 45 44 43 42 41 40 39 38 37 36 35 34 33...
I need it in JAVA Write a program that randomly populates an array of size 100, sorts it, and then finds the median. The random numbers must be from 0-99 and all integer values. Also since there is an even set of numbers the median is found by taking the mean of the two middle numbers (In other words the 50th and 51st). You have to code your own sorting method. You may not use a built in java sorter....
The ExceptionLab class provided: – Creates an array of 100
elements and fills it with random numbers from 1 to 100. – It asks
the user for an index value between 0 and 99. – Prints the element
at that position. – If a number > 99 is entered by the user, the
class will abort with an ArrayIndexOutOfBoundsException • Modify
the ExceptionLab: – Add a try-catch clause which intercepts the
ArrayIndexOutOfBounds and prints the message: Index value cannot be...
data: (copy and paste in excel to view columns in alignment)
Sample Repair Time (days)
1 12
2 17
3 9
4 16
5 10
6 18
7 12
8 14
9 15
10 14
11 14
12 8
13 11
14 10
15 8
16 8
17 14
18 12
19 14
20 13
21 12
22 15
23 15
24 10
25 24
26 17
27 13
28 15
29 13
30 15
31 36
32 40
33 ...
Note: The assignment must be submitted into the designated link in the Blackboard cou page. You are to save each HTML5 document file as the following synt StudentID FirstName_LastName Question Number ► QUESTIONS In this assignment you are required to write HTML5 code which contains JavaScript in order to do the following tasks: 1) Construct the below multiplication table using JavaScript code and HTML5 1 2 3 4 5 6 7 8 9 10 11 12 111 2 3 4...