Basic descriptive statistics and graphs

Assignment Help Basic Statistics
Reference no: EM13702698

A health agency is conducting an evaluation of all the hospitals in its region. The main aim of this assignment is to produce a report summarising the characteristics of the data. The agency needs a report that studies the number of admissions, type of control, and type of service at each of these hospitals.

The data collected is contained in a file called 'hospitals.xls' which has been placed in Moodle.  Make sure you check with your lab tutor how to obtain this data.  For this assignment, you need to use Excel to conduct the statistical analyses.

The columns of the file contain the following information:






Hospital Number



Type of control (1 = government, non-federal;

   2 = nongovernment, not-for-profit;

   3 = for-profit;

   4 = federal government)



Type of service (1 = general medical; 2 = psychiatric)



Number of beds



Number of admissions

Before you begin any analysis you must take a random sample of 140 hospitals from the 200 provided in the data set.  To do this, use the Random Sample Generator available on Moodle (Random Sample Generator-sem1_15). Make sure you check with your tutor how to obtain a random sample of 140 hospitals using this generator. Your answers to the assignment tasks below are based on your sample of 140 hospitals. Make sure you keep a safe copy of your sample, since you cannot use the Random Sample Generator to reproduce the first sample.

The main aim of this assignment is to investigate the effect of various variables on the number of admissions in hospitals. Each of the tasks below will guide you through various descriptive statistical analyses that will assist you to formulate a conclusion about the main aim. Your responses to these tasks should be represented in a well written manner with appropriate statistical analyses. Appropriate computer output should be incorporated within the body of each response.

Assignment Tasks:

Task 1: Basic Descriptive Statistics and Graphs

For the variable Admissions, obtain some basic descriptive statistics as well as a histogram and a boxplot. Include the output from the plots and descriptive statistics in your assignment. Briefly describe the shape, location and spread of the distribution of Admissions with appropriate linking to the descriptive statistics. That is, state which central measure and measure of spread would be best to use to describe the distribution and the reason(s) why.Make comments on the presence of any outliers (for example, what effect would they have on the summary statistics).

Task 2: Side-by-Side Boxplots

Produce a side-by-side boxplot that visually depicts the relationship between Admissions and Service. The boxplots should show the distribution of the number of admissions for both the general medical and psychiatric hospitals. Include the output in your assignment. Describe what is shown by the boxplots in terms of the shape, spread and location of each distribution.

Task 3: Pivot Tables:

Construct a pivot table to compare the type of service with the type of control.Place control in the rows and service in the columns and a count of hospitals in the body of the table.

Obtain a second pivot table by converting the frequencies in each column into relative frequencies in each column (right click on any number in the table, then choose Show Values as % of column totals).

Include both tables in your assignment. You need to compare the percentage of the 4 types of control within each of the general medical and psychiatric hospitals. Discuss whether the types of control differ within the two types of service by referring to the two pivot tables.

Task 4: Conclusion

From the tasks above, you should have some idea of the variables in the hospital data set and how some of them relate to others. In this section you should write a short paragraph summarising your main findings.

Reference no: EM13702698

Create an erd based on the crows foot model

Show the dependency diagram for each of the normal forms. Do not go beyond the 3rd normal form - Show the dependency diagram for each of the normal forms. Do not go beyon

What is the probability that it is brown

Find the probability that the selected student is the oldest or an only and find the probability that the selected student is enrolled in the College of Arts & Science.

What distribution seem most appropriate to model ttr data

What distribution would seem most appropriate to model the TTR data - If your suggested model were valid what proportion of TTR values is likely to exceed the maximum allowabl

Determine the variance of the random variable x

Marketing estimates that a new instrument for the analysis of soil samples will be very successful, moderately successful, or unsuccessful, with probabilities 0.6, 0.6, and

Find the linear correlation coefficient

Find the linear correlation coefficient for the systolic and diastolic measurements - determine the linear regression equation that uses the systolic pressure to predict the d

Systolic blood pressure in different age groups

SYSTOLIC BLOOD PRESSURE IN DIFFERENT AGE GROUPS - Is there sufficient evidence to support the claim that women in the different age categories have different mean blood press

Determine the regression equation

Suppose a large sample is selected (instead of just 10). About 95 percent of the predictions regarding sales would occur between what two values? Determine the regression equa

How long will it take him to try each possibility

He also knows that the number has 7 digits and the last digit is not a zero. if jay were to dial all of the possible numbers and it takes him 21 seconds to try each one, how


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd