Explore BrainMass
Share

Descriptive Statistics, Histograms and Missing Data

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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.

© BrainMass Inc. brainmass.com October 25, 2018, 10:10 am ad1c9bdddf
https://brainmass.com/statistics/central-tendency/descriptive-statistics-histograms-missing-data-600931

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
See Also This Related BrainMass Solution

STATISTICS ASSIGNMENT USING SPSS

MGMT814-1402C-01 Quantitative Research Methods
Task Name: Phase 2 Individual Project
Deliverable Length: SPSS Outputs and 200-500 words answering questions
Details:
Weekly tasks or assignments (Individual or Group Projects) will be due by Monday, and late submissions will be assigned a late penalty in accordance with the late penalty policy found in the syllabus. NOTE: All submission posting times are based on midnight Central Time.

Using the data set electric.sav, use SPSS to run a distribution analysis on diastolic blood pressure (DBP58), examining the following for individuals who have had no history of cardiovascular heart disease and the group with a history of cardiovascular heart disease (CHD). The variable that looks at history is CHD.

Compute the following for each group:
Mean
Median
Mode
Quartiles
Range
Variance
Standard deviation
Skewness
Kurtosi
Under Plots, run a histogram, and show the normal curve on the histogram and run Stem-and-Leaf and Box-and-Whiskers
Submit your outputs from all SPSS runs, and briefly describe your results by answering the following questions:

What can you determine from the measures of skewness and kurtosis relative to a normal curve? What are the mean and median?
Does one seem better than the other to represent the scores?
What differences can you see in the pattern of responses those with history versus those with no history?
What information can you determine from the box plots?
Please submit your assignment.

View Full Posting Details