QNT561 Signature Assignment

Signature Assignment

QNT 561

This week, our team analyzed data gathered for hospitals operating in the United States.  Data was collected from 200 different hospitals, and that data includes geographic region, personnel numbers, census, the number of births that occurred, type of hospital (denoted ‘service’), and type of ownership (denoted ‘control’).  In this paper, we will examine our analysis of the data provided to identify potential trends, correlations, and outliers.  The project has been broken down into four sections; preliminary analysis, descriptive statistics, inferential statistics, and our conclusions.  An Excel spreadsheet has been attached which includes all formulas and calculations performed that support our results and conclusions.

Part I

What are the question you are trying to address?

What is the sample?

Part II

Descriptive statistics were used to further evaluate our given data.  Refer to the attached Excel sheet for a full analytical report of descriptive statistics including mean, median, mode, range, standard deviation, variance, skewness, minimum, 1st quartile, median, 3rd quartile, maximum, sum, count, CV, outlier upper and lower bound, and more.  These calculations provide a basic picture of each of the three measured data sets; census, births, and personnel.

Part III

The qualitative data contains some relevant data about the population of hospitals. The general medical facilities make up most of the healthcare entities in the sampling accounting for 84% of the organizations.

Part IV

Part 4 – Conclusion and Recommendations (1-2 paragraphs)

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?
Powered by