Organization: Freestanding ER Services
Title: ER Operations Manager
Outline:
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 measured, and how they will be collected.
Sample Size: State your sample size and when data is collected.
Hypothesis: What are your null and alternate hypothesis?
Methodology: State the statistical method used in this section.
Findings: Copy and Paste all relevant output from Excel into this section. State your major findings from the included tables/charts.
Interpretaions/Implications: Discuss what the department/organization needs to do based on the findings.
ID | Insurance | Location | Wait Time | Age | GHSS | Cost |
126 | Uninsured | Moore | 60 | 11 | 12 | $12,000 |
107 | Uninsured | Moore | 25 | 13 | 99 | $7,800 |
110 | Uninsured | Moore | 45 | 16 | 13 | $478 |
141 | Uninsured | West | 34 | 31 | 1 | $135 |
160 | Insurance | Moore | 2 | 47 | 14 | $1,200 |
128 | Uninsured | Moore | 22 | 47 | 16 | $4,600 |
166 | Insurance | Moore | 12 | 49 | 77 | $4,400 |
121 | Insurance | Moore | 25 | 52 | 15 | $4,500 |
120 | Insurance | West | 15 | 56 | 67 | $4,450 |
124 | Insurance | Moore | 22 | 57 | 61 | $1,200 |
132 | Insurance | Moore | 54 | 59 | 16 | $1,200 |
130 | Insurance | Moore | 55 | 60 | 25 | $1,200 |
108 | Uninsured | Moore | 10 | 60 | 26 | $1,365 |
161 | Insurance | Moore | 56 | 62 | 27 | $1,200 |
115 | Government | Moore | 15 | 63 | 66 | $13,000 |
163 | Insurance | Moore | 61 | 66 | 34 | $1,400 |
158 | Uninsured | Moore | 56 | 71 | 45 | $1,300 |
138 | Uninsured | Moore | 15 | 74 | 79 | $4,900 |
113 | Government | Moore | 25 | 78 | 56 | $13,000 |
139 | Uninsured | West | 13 | 78 | 77 | $4,850 |
180 | Government | Moore | 33 | 79 | 86 | $12,000 |
182 | Government | Moore | 34 | 80 | 57 | $900 |
176 | Government | Moore | 55 | 85 | 79 | $1,245 |
177 | Government | Moore | 60 | 87 | 49 | $678 |
178 | Government | Moore | 45 | 89 | 73 | $450 |
133 | Uninsured | West | 45 | 89 | 93 | $9,850 |
149 | Uninsured | Moore | 14 | 90 | 88 | $4,500 |
193 | Government | Moore | 34 | 90 | 99 | $8,700 |
114 | Government | Moore | 44 | 91 | 90 | $5,000 |
102 | Government | Pelican | 20 | 5 | 1 | $680 |
165 | Uninsured | Pelican | 11 | 5 | 2 | $899 |
109 | Uninsured | Pelican | 89 | 6 | 77 | $12,000 |
152 | Insurance | Pelican | 15 | 6 | 77 | $14,000 |
140 | Insurance | Pelican | 20 | 7 | 11 | $9,000 |
192 | Government | West | 20 | 7 | 13 | $450 |
174 | Government | Pelican | 20 | 7 | 15 | $6,785 |
155 | Insurance | Pelican | 20 | 7 | 24 | $850 |
112 | Government | West | 22 | 8 | 26 | $450 |
169 | Insurance | Pelican | 20 | 8 | 36 | $960 |
137 | Insurance | Pelican | 25 | 9 | 1 | $6,000 |
194 | Government | West | 22 | 9 | 11 | $450 |
156 | Insurance | West | 25 | 10 | 13 | $11,000 |
197 | Government | Pelican | 23 | 12 | 18 | $195 |
143 | Insurance | Pelican | 26 | 14 | 66 | $650 |
164 | Uninsured | West | 22 | 14 | 89 | $4,500 |
170 | Government | West | 24 | 15 | 99 | $4,630 |
135 | Insurance | Pelican | 31 | 16 | 14 | $9,000 |
119 | Insurance | Pelican | 34 | 17 | 16 | $1,200 |
196 | Government | Pelican | 24 | 18 | 19 | $1,645 |
150 | Uninsured | Pelican | 23 | 18 | 25 | $879 |
134 | Insurance | Pelican | 36 | 19 | 22 | $950 |
185 | Government | Pelican | 26 | 19 | 26 | $1,200 |
145 | Government | West | 28 | 19 | 88 | $13,000 |
179 | Government | West | 28 | 22 | 1 | $456 |
157 | Insurance | West | 36 | 22 | 44 | $980 |
181 | Government | Pelican | 29 | 24 | 13 | $7,100 |
144 | Insurance | Pelican | 44 | 24 | 36 | $1,300 |
100 | Uninsured | Pelican | 45 | 27 | 26 | $1,500 |
159 | Insurance | Pelican | 44 | 27 | 48 | $15,000 |
131 | Insurance | Pelican | 45 | 30 | 79 | $1,500 |
125 | Uninsured | Pelican | 56 | 30 | 99 | $12,000 |
186 | Government | West | 36 | 34 | 13 | $156 |
136 | Insurance | Pelican | 45 | 34 | 99 | $4,500 |
116 | Government | West | 36 | 36 | 16 | $4,900 |
148 | Insurance | West | 48 | 36 | 89 | $14,800 |
106 | Insurance | West | 55 | 38 | 36 | $1,356 |
129 | Insurance | Pelican | 55 | 43 | 46 | $4,500 |
190 | Government | Pelican | 36 | 44 | 16 | $1,200 |
123 | Insurance | Pelican | 56 | 44 | 36 | $1,630 |
142 | Uninsured | Pelican | 61 | 45 | 49 | $4,680 |
117 | Government | Pelican | 39 | 46 | 36 | $4,950 |
104 | Government | Pelican | 43 | 47 | 12 | $4,977 |
154 | Government | Pelican | 44 | 48 | 24 | $1,200 |
103 | Government | West | 46 | 50 | 56 | $5,500 |
184 | Government | Pelican | 24 | 51 | 57 | $5,500 |
189 | Government | Pelican | 46 | 55 | 23 | $1,300 |
122 | Government | West | 49 | 56 | 66 | $1,230 |
153 | Government | West | 15 | 56 | 99 | $5,600 |
191 | Government | West | 15 | 57 | 68 | $1,340 |
183 | Uninsured | Pelican | 9 | 58 | 63 | $1,345 |
101 | Government | Pelican | 18 | 59 | 89 | $8,800 |
151 | Insurance | Pelican | 14 | 64 | 89 | $5,600 |
173 | Government | Pelican | 13 | 66 | 23 | $2,300 |
172 | Government | Pelican | 55 | 67 | 69 | $678 |
146 | Government | Pelican | 14 | 67 | 88 | $6,600 |
175 | Government | Pelican | 24 | 74 | 37 | $1,300 |
105 | Government | Pelican | 15 | 74 | 88 | $8,890 |
188 | Government | Pelican | 4 | 76 | 36 | $134 |
187 | Government | Pelican | 3 | 78 | 69 | $7,400 |
162 | Insurance | Pelican | 14 | 88 | 90 | $2,000 |
147 | Government | Pelican | 13 | 88 | 99 | $9,450 |
168 | Government | Pelican | 13 | 91 | 73 | $8,700 |
118 | Insurance | Pelican | 13 | 91 | 94 | $10,000 |
167 | Insurance | Pelican | 13 | 93 | 93 | $8,999 |
127 | Insurance | Pelican | 14 | 94 | 74 | $550 |
171 | Government | Pelican | 14 | 98 | 74 | $15,000 |
111 | Insurance | Pelican | 12 | 99 | 73 | $900 |
197 | Uninsured | West | 55 | 80 | 59 | $780 |
197 | Government | West | 21 | 19 | 26 | $1,450 |
197 | Uninsured | West | 14 | 29 | 88 | $8,900 |
197 | Government | West | 19 | 36 | 44 | $1,200 |
197 | Uninsured | West | 15 | 36 | 55 | $1,300 |
197 | Government | West | 17 | 43 | 99 | $900 |
197 | Uninsured | West | 16 | 44 | 46 | $4,400 |
197 | Government | West | 35 | 45 | 78 | $7,780 |
197 | Uninsured | Pelican | 19 | 45 | 86 | $4,465 |
197 | Uninsured | West | 60 | 47 | 23 | $1,200 |
197 | Government | Pelican | 47 | 48 | 22 | $1,430 |
197 | Government | Pelican | 14 | 55 | 88 | $12,800 |
197 | Insured | Pelican | 10 | 65 | 10 | $1,200 |
197 | Government | West | 46 | 67 | 67 | $650 |
197 | Insured | Pelican | 21 | 69 | 79 | $4,458 |
197 | Insured | West | 22 | 70 | 15 | $1,200 |
197 | Insured | Pelican | 27 | 73 | 66 | $4,600 |
197 | Insured | Pelican | 28 | 74 | 78 | $7,748 |
197 | Insured | Pelican | 36 | 76 | 19 | $1,200 |
197 | Insured | Pelican | 25 | 77 | 48 | $1,400 |
197 | Government | Pelican | 13 | 77 | 79 | $12,000 |
197 | Insured | Pelican | 44 | 78 | 79 | $9,900 |
197 | Government | Pelican | 25 | 78 | 99 | $1,800 |
197 | Insured | Pelican | 76 | 81 | 89 | $4,500 |
197 | Insured | Pelican | 38 | 82 | 79 | $5,000 |
197 | Government | Pelican | 19 | 89 | 44 | $3,000 |
197 | Government | Moore | 55 | 89 | 96 | $5,750 |
197 | Insured | Moore | 37 | 89 | 99 | $12,000 |
197 | Government | Moore | 56 | 90 | 79 | $10,000 |
197 | Insured | Moore | 44 | 94 | 86 | $55 |
51.18898 | 53.24409 | 4486.15 |
Using Excel
data -> data analysis-> regression
SUMMARY OUTPUT | |||||
Regression Statistics | |||||
Multiple R | 0.4689 | ||||
R Square | 0.2199 | ||||
Adjusted R Square | 0.2073 | ||||
Standard Error | 3732.5434 | ||||
Observations | 127 | ||||
ANOVA | |||||
df | SS | MS | F | Significance F | |
Regression | 2 | 486961883.1374 | 243480941.5687 | 17.4765 | 0.0000 |
Residual | 124 | 1727553135.0201 | 13931880.1211 | ||
Total | 126 | 2214515018.1575 | |||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | |
Intercept | 2070.5160 | 752.3254 | 2.7522 | 0.0068 | 581.4533 |
Age | -26.9953 | 13.6582 | -1.9765 | 0.0503 | -54.0286 |
GHSS | 71.3223 | 12.2760 | 5.8099 | 0.0000 | 47.0247 |
y^ = 2070.5160 -26.9953 Age +71.3223 GHSS
the model is overall significant as p-value = 0.0000 < alpha
when Age increases by 1 year, on averege ER cost decrease by 27
when GHSS increases by 1 unit, on average ER cost increase by 71.3223
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...
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...
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...
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...
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:...
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...
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...
Plot the Frequency vs Speed and Cumalative Frequency vs Speed of the vehicles No. Speed (mph) 1 33.2 2 38.3 3 67.1 4 45.2 5 41.1 6 35.1 7 44 8 66.3 9 44.3 10 36.3 11 38.3 12 44.6 13 45.2 14 41.1 15 55.1 16 50.2 17 54.3 18 65.2 19 55.2 20 45.7 21 54.1 22 54 23 46.1 24 54.2 25 52.3 26 57.3 27 46.8 28 57.8 29 36.8 30 55.8 31 43.3 32 55.3...
Method #3: Systematic Random Sample Pick a number at random from 1-10. Then sample every 10th household af ter that, For exomple, your sample could be H-holds #3, 13, 23, 33, 43, 93, Go ahead and try this. No, of residents sample mean Method #4: Simple Random Sample Select 10 households at random from the 100. The random selection can be accomplished in several ways. You could put the numbers 1-100 in a "hat" and draw 10 out at randorn,...
The data from data349.dat contains information on 78 seventh-grade students. We want to know how well each of IQ score and self-concept score predicts GPA using least-squares regression. We also want to know which of these explanatory variables predicts GPA better. Give numerical measures that answer these questions. (Round your answers to three decimal places.) (Regressor: IQ) R 2 (Regressor: Self-Concept) R 2 Which variable is the better predictor? IQ Self Concept obs gpa iq gender concept 1 7.94 112 ...