Question

Upon successful completion of the MBA program, imagine you work in the analytics department for a consulting company. Your assignment is to analyze one of the following databases: Hospital

Part 1 - Preliminary Analysis Generally, as a statistics consultant, you will be given a problem and data. At times, you may have to gather additional data. For this assignment, assume all the data is already gathered for you. State the objective: What are the questions you are trying to address? Describe the population in the study clearly and in sufficient detail: What is the sample? Discuss the types of data and variables: Are the data quantitative or qualitative? What are the levels of measurement for the data?

Part 2 - Descriptive Statistics Examine the given data. Present the descriptive statistics (mean, median, mode, range, standard deviation, variance, CV, and five-number summary). Identify any outliers in the data. Present any graphs or charts you think are appropriate for the data. Note: Ideally, we want to assess the conditions of normality too. However, for the purpose of this exercise, assume data is drawn from normal populations.

Part 3 - Inferential Statistics Use the Part 3: Inferential Statistics document. Create (formulate) hypotheses Run formal hypothesis tests Make decisions. Your decisions should be stated in non-technical terms. Hint: A final conclusion saying "reject the null hypothesis" by itself without explanation is basically worthless to those who hired you. Similarly, stating the conclusion is false or rejected is not sufficient.

Part 4 - Conclusion and Recommendations Include the following: What are your conclusions? What do you infer from the statistical analysis? State the interpretations in non-technical terms. What information might lead to a different conclusion? Are there any variables missing? What additional information would be valuable to help draw a more certain conclusion?

Personnel Births Census Service Hospital Geog. Region Control 347 211 2 2 1 1 1 181 168 1 1 2 93 0 185 10 216 1 1 1 4 79 16 1 1 1 5 538 466 11 1 6 136 99 12 4 7 262 286 13 2 8 205 339 14 9 144 126 15 10 66 15 1 11 322 17 415 12 198 295 17 3 13 85 0 19 2 14 233 257 21 6 15 111 0 21 1 6 16 229 24 352 6 17 106 25 0 18 241 169 27 1 19 386 503 27 3 1 20 300 28 451 6 21 373 28 0 6 22 50 C 28 2 23 437 1161 28 24 0 102 28 6 25 1193 556 29 2 6 26 216 387 29 27 203 30 430 6 28 102 0 30 29 409 0 31 2 30 273 364 31 2 31 96 0 32 1 2 5 32 70 34 14 33 885 342 36 1 34 75 0 7 2 1 35 145 91 38 36 415 509 8 1 37 392 1189 1 1 38 126 0 40 39 61 78 40 40 354 995 42 41 325 43 42 337 43 126 43 153 0 43 1 1 44 395 376 43 1 1 1 45 297 145 45 2 46 1 o

Answer 1

Sol:

The population in the study consist of the hospital across different geographical locations and regions in the country.

The sample consists of 200 hospitals from selected geographical locations and regions.

The following is the qualification of the data:

Geographical Location - Qualitative (With levels - 1,2,3,4,5,6,7)

Region - Qualitative (With levels - 1,2,3,4)

Control service - Qualitative (With levels - 1,2)

Census - Quantitative

Births - Quantitative

Personnel - Quantitative

The data can be summarised as follows:

oft Excel (Product Activation Failed File Home Insert Page Layout Formulas Data Review View Developer Connections Data Analysis EShow Detail Clear A Reapply ?Solver Properties Refresh Edit Links Hide Detail ZI Sort Consolidate What-If From From From From Other Existing Connections Filter Text to YAdvanced Columns Duplicates Remove Data Group Ungroup Subtotal Access Web Analysis Al Get External Data Sort & Filter Connections Data Tools Outline Analysis K2 J L M N O P R S T W 1 Hospital Geog. Control Service Births Personnel Region Census 4 Mean 100.5 Mean 3,03 Mean 2,15 Mean 1.16 Mean 149.095 Mean 873.8 Mean 861.21 75.18947 Standard 4,092676 Standard Error 0,025988 Standard Error 5 Standard Error 0.132602 Standard Error 0.064094 Standard Error 12.36022 Standard Error 58.1016 6 Median 3 Median 2 Median 102.5 Median 480 Median 100.5 Median 1 Median 589.5 7 Mode #N /A Mode 3 Mode 2 Mode 28 Mode 0 Mode 1 Mode 328 8 Standard Deviation 57.87918 Standard Deviation 1.875282 Standard Deviation 0.906426 Standard Deviation 0.367526 Standard Deviation 1063.34 StandardI 821.6807 174.7999 Standard Deviation 3350 Sample Variance 1130691 Sample V 675159.1 2.526028 Kurtosis 9 Sample Variance 0.821608 Sample Variance -0.56326 Kurtosis 0.135075 Sample Variance 30555.01 Sample Variance 3.516683 Sample Variance -0.63873 Kurtosis 1,507758 Kurtosis 21.59807 Kurtosis 10 Kurtosis 1.2 Kurtosis 3.189297 1.868898 Skewness 3.883113 Skewness 0.434505 Skewness 11 Skewness 0.695032 Skewness 1.590836 Skewness 1.791177 -7.2E-17 Skewness 12 Range 199 Range 6 Range 3 Range 1 Range 1459 Range 5699 Range 4037 13 Minimum 1 Minimum 1 Minimum 1 Minimum 1 Minimum 2 Minimum 0 Minimum 5C 5699 Maximum 1461 Maximum 14 Maximum 200 Maximum 7 Maximum 4 Maximum 2 Maximum 4087 172242 15 Sum 20100 Sum 606 Sum 430 Sum 232 Sum 29819 Sum 174760 Sum 16 Count 200 Count 200 Count 200 Count 200 Count 200 Count 200 Count 200 17 ? Data Analysis 18 Analysis Tools OK Anova: Single Factor Anova: Two-Factor With Replication .. Cancel C actor Without Replication Covariance 21 22 Heb Exnonential Smoothino -Test Two-Sample for Variances nalysis 25 Histoaram Ready 国回四 100% O R ENG 10:20 US 01-07-2018

I used the data analysis option in Excel to get the results.

The relevant graphs to spot outliers are:

Book1 - Microsoft Excel (Product Activation Failed) Chart Tools Layout File Home Insert Page Layout Formulas Data Review View Developer Design Format TC S2 |Y Slicer Line Column Win/Loss PivotTable Table Picture Clip Shapes SmartArt Screenshot Columm Line Pie Ba. Area Scatter Other Hyperlink Text Header WordArt Signature Object Equation Symbol Charts Ar Box Footer Line Tables llustrations Charts Sparklines Filter Links Text Symbols Chart 6 E C G J L M N A D E 1 Hospital Geog. Personnel Region Control Se Census Births Census 1762 4. 1 1 356 1027 2310 1 1600 328 0.0259 5. 1 1 1 100 355 168 6 5 7 1 181 1400 7 6 4 2 1 159 3810 1077 n 0.3675 1 735 742 8 4 4 65 1200 9 4 2 1 48 131 0.1350 1 1 10 9 2 253 1733 1594 1.5077 1000 1 1 11 10 1 21 257 233 1,8688 12 11 1 1 1 27 169 241 800 Census 13 12 6 30 430 203 600 14 13 6 43 325 1 15 14 233 2049 676 2 1 400 16 15 211 347 4 17 16 11 16 79 1 1 200 18 17 84 2648 505 545 0 .. 200 250 50 100 150 21 20 124 959 22 21 50 1993 325 1091 671 25 24 1 140 1313 4 Sheet2Sheet3 Sheet1 囲回四 Count: 201 Ready Average: 149.095 Sum: 29819 100 P 10:27 R ENG US 01-07-2018

Book1 - Microsoft Excel (Product Activation Failed) Chart Tools File Home Insert Page Layout Formulas Data Review View Developer Design Layout Format TC S2 Area Scatter Other Charts Line Column Win/Loss PivotTable Table Picture Clip Shapes SmartArt Screenshot Columm Line Pie Ba Slicer Hyperlink Text Header WordArt Signature Object Equation Symbol Ar Box Footer Line Tables llustrations Sparklines Filter Links Text Symbols Scatter Chart 9 E C D E Births G J M N C A 1 Hospital Geog. Region Control Se Census Personne Hospital Control Service Region 312 792 Geog Scatter with Straight Lines and Markers Births 4. 1 1 356 1 Compare pairs of values Error 0.0259 5. 1 1 1 100 Use it when there are a few data data 6 5 7 1 renresents senatate valu 7 6 4 2 1 159 es.. 1 8 7 4 4 65 735 Deviation 0.3675 5000 9 8 4 2 1 48 1 ariance 0.1350 1 10 9 2 253 1733 15 1,5077 1 1 2 4000 1.8688 11 10 1 21 257 12 11 1 1 1 27 169 13 12 6 1 30 430 3000 14 13 6 43 1 Births 15 14 233 2049 2 16 15 211 4 2000 17 16 11 16 1 1 2648 18 17 84 1000 .. 1465 21 20 124 22 21 50 1993 0 100 200 142 50 150 250 671 25 24 1 140 1313 4 Sheet2 Sheet3 Sheet1 100 % ) Average: 873.8 Count: 201 Sum: 174760 Ready ENG US 10:29 Pa R 01-07-2018

Book1 - Microsoft Excel (Product Activation Failed) Chart Tools File Home Insert Page Layout Formulas Data Review View Developer Design Layout Format A TC S2 A PivotTable Table Picture Clip Shapes SmartArt Screenshot Column Line Pie Ba Area Scatter Other Line Column Win/Loss Slicer Hyperlink Text Header WordArt Signature Object Equation Symbol . Footer Charts Ar Box Line Tables llustrations Charts Sparklines Filter inks Text Symbols Chart 10 E C G H J M N C A D E 1 Hospital Geog Region Control Se Census Births Personne Personnel Service 1762 4500 4. 1 1 356 1027 2310 1 0.0259 5. 1 1 1 100 355 328 rTor 4000 18: 168 6 5 7 1 7 6 4 2 1 159 3810 1077 1 735 8 4 4 65 742 Deviation 0.3675 3500 9 8 4 2 1 48 1 131 riance 0.1350 1594 1 1 10 9 2 253 1733 1,5077 3000 1 11 10 1 1 21 257 233 1.8688 12 11 1 1 1 27 169 241 13 12 6 1 30 430 203 2500 14 13 6 43 325 1 Personnel 15 14 233 2049 676 2 1 2000 16 15 211 347 4 17 16 11 16 79 1 1 1500 18 17 84 2648 505 1543 .. 1000 21 20 1 124 959 22 21 50 1993 325 500 1091 25 24 140 1313 671 14 Sheet2Sheet3 Sheet1 100% Count: 201 Sum: 172242 Ready Average: 861-21 ENG 10:32 Pa R US 01-07-2018