Share
Explore BrainMass

Descriptive Statistics, Histograms and Missing Data

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 unit, we will begin our analysis of the data set. Analysis of the dataset is the first step in any statistical analysis. 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).

For the week 8 assignment, you will do a univariate analysis 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.

Attachments

Solution Preview

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 unit, we will begin our analysis of the data set. Analysis of the dataset is the first step in any statistical analysis. In this first step, you must examine the data for abnormalities such as missing data and outliers. If you are conducting a parametric test ...

Solution Summary

The solution is comprised of descriptive, graphical and missing data importance and methods using excel. Histograms, descriptive statistics were performed using Excel with full interpretation of the results. Missing data imputation details are discussed with appropriate methods used in case of normal and non-normal data.

$2.19