Looking for someone who can really help complete this project. It was assigned to someone who ended up canceling.
You have been hired as the chief operating officer of a multi-hospital health care system. The CEO approaches you in your new role and asks you to do an analysis of factors affecting the total costs of hospitals in your region.
In this first step, you must examine the data for abnormalities such as missing data and outliers. If you are conducting a parametric test such as ANOVA, t-test, or regression, the variables in the analysis should all be evenly distributed (that is, the variables when displaced graphically should be as close to a normal bell curve as possible).
Do a univariate analysis in Excel on all the variables in the given Excel file. This analysis will include, for each variable, the following:
1. An assessment of mean, mode, median, standard deviation.
2. Any missing data and an application of a decision rule to that missing data. Discuss your decision and explain your change, if any.
3. A frequency graph (histogram or bar graph) for each variable. Is the data skewed, kurtotic, or normally distributed for each variable? Explain how each variable will contribute to the regression equation if it is heavily skewed or kurtotic.
It might be helpful to make a table where each variable's individual properties can be addressed. Each variable must be painstakingly discussed and addressed.
The CEO has approached you in your new role and asked you to do an analysis of factors affecting the total costs of hospitals in your region based on the data provided to you in an Excel file.
You will select the appropriate statistical test that allows you to conduct an analysis of the factors affecting hospital costs in excel. You will have to select the correct statistical test and conduct that test in Excel. Based on the output you produce in Excel, analyze your data and produce a 250-word (approximately) summary describing the major findings of your analysis. Your final analysis should include (minimally), the following:
1. the variables that most affect hospital cost.
2. an overview of the P and F values in your Excel tables.
3. a discussion of the degrees of freedom and the sample size.
4. Describe the statistical concepts of probability, random variation, and probability distributions.
5. Explain how statistical methods are used to translate vital statistics and public health records into public health information and reports
6. Describe how statistical methods of inference are used in analysis and interpretation of public health data.
You should also discuss any significant relationships that present themselves in the Excel files produced from your statistical analysis. You are not limited by the information presented above. In fact, only discussing the aforementioned items will result in a score of "Basic" proficiency in the scoring rubric.
Provide a narrative assessment of recommendations and findings for the CEO. Write a 500-word (approximately) summary of your findings. Remember, your CEO is not very statistically savvy, so please do not include too much pedantic jargon in your memo. What do you tell the CEO about your analysis? What are your findings, and what are your recommendations after doing this analysis? Consider the following points as you prepare your memo:
1. The manner in which you format your memo is up to you. A simple memo with the date, subject, and lines with "to" and "from" will suffice. The "To" line is the name of your course instructor and the "From" line is your own name. Include your findings in the body of the memo.
2. You should include in your memo the number of hospitals reviewed, what factors were considered in the model, and what factors contribute most to hospital costs.
3. Make an argument for the creditability or legitimacy of the model without getting too technical; however, do not make your memo seem like you are offering an opinion. Write your memo dispassionately, and let the data speak for itself; however, include any other pertinent information you think the CEO wants to see.
Make sure to address how statistical methods are used to translate vital statistics and public health records into public health information and reports, Describe how statistical methods support data analyses, Define statistical methods of inference, Describe how statistical methods of inference are used in analysis and interpretation of public health data, and Identify statistical methods used in public health research
|Due By (Pacific Time)
||06/05/2015 02:00 am