# Stats Assignment

3.  Are the values in columns E, F, and G discrete or continuous variables?  Please explain your answer.

4.  Label a worksheet “4. MA sorted” and perform a custom sort on the Massachusetts data on “complete reports” from highest to lowest.  To make a copy for sorting, right click on the worksheet name “Massachusetts” then click copy. An additional “Massachusetts” worksheet will appear and you will need to rename that worksheet “MA sorted”

5.  Label a worksheet “5. Boston sorted” and sort the Boston “Complete Reports” from lowest to highest.   What is the average number of completed reports for Massachusetts and for Boston.

6.  Label a worksheet “6.  MA categorized”.  Create this additional worksheet the same way you created the new sheet in question 4.  Add a column that transforms the “Missing Reports” to “Missing Categories”.  Hospitals with 0-3 missing reports are category A; 4-6 are category B and 7-9 are category C.

7.  Using the Boston dataset, create a basic bar graph that shows the number of complete reports for each hospital.  Be sure to label the sheet “7. Boston bar graph”

8.  Perform a custom sort on the Massachusetts data and create a listing which is alphabetical order by city name.  You will be sorting the entire string of data that goes with the city name (not just listing the cities).  You will need a new worksheet and you should label it “8. MA city sort”

9.  Create a frequency distribution of the completed reports for the Massachusetts dataset on a worksheet labeled “9. MA freq completed reports”.

10.  Create a pie chart of the complete reports for the Boston dataset and display on a worksheet labeled “10. Boston pie”.

11.  Create a cumulative frequency distribution for missing reports in the Massachusetts dataset and display all of your work on a worksheet labeled “11. MA freq missing reports”.

12.  Create a worksheet labeled “12. Narrative” And answer the following questions:

a.  Please list and describe the four types of frequency distributions.

b.  Which type of distribution applies to the one you created for question 9?

13.  Create a worksheet labeled “13. Hypothesis” and using the Massachusetts dataset test the hypothesis H0: complete reports for cities =3 against the alternative H1: complete reports <3, and indicate your conclusion.

Please create a worksheet labeled “14.-15. Narrative” and answer the following two questions.

14.  Which statistical test is used to assess the independence of two variables when both variables are categorical?

15.  Which statistical test is used to assess the independence of two variables when one variable is a numerical variable measured in either discrete or continuous units and the other is a categorical variable taking on only two values.

2

>Massachusetts

MA Voluntary non-profit – Private

0 1

MA Voluntary non-profit – Private 2 0 3

MA

1 0 2

MA Voluntary non-profit – Private

0

BOSTON MA Voluntary non-profit – Private

0

HEALTH ALLIANCE

CAMBRIDGE MA

1 0 1

MA Voluntary non-profit – Private 2 0 2

BOSTON MA

2 0 6

MA Voluntary non-profit – Private 1 0 2

BOSTON MA Voluntary non-profit – Private 1 0 2

MA Voluntary non-profit – Private 2 1 5

BOSTON MA Voluntary non-profit – Private 3 0 9

MA Proprietary 2 0 9

MA Voluntary non-profit – Private 2 0 3

MA Voluntary non-profit – Other 2 0

MA Proprietary 1 0 1

MA Voluntary non-profit – Private 1 0 1

MA Voluntary non-profit – Private 4 0

GENERAL HOSPITAL

LAWRENCE MA Voluntary non-profit – Private 3 0 5

GENERAL HOSPITAL

LOWELL MA Voluntary non-profit – Private 0 1 2

HOSPITAL

MARLBOROUGH MA Voluntary non-profit – Private 3 1 7

BOSTON MA Voluntary non-profit – Private 1 0 1

SPRINGFIELD MA Voluntary non-profit – Private 1 0 1

MA Proprietary 2 0

MA Voluntary non-profit – Private 2 0 5

REGIONAL MEDICAL CENTER

MILFORD MA Voluntary non-profit – Other 3 0 7

HOSPITAL INC

MILTON MA

1 0 1

MA Proprietary 4 0

CAMBRIDGE MA Voluntary non-profit – Private 1 0 2

MA Proprietary 1 0 4

-WELLESLEY HOSPITAL

NEWTON MA Voluntary non-profit – Other 1 0 3

MA Government – Federal 2 0 4

REGIONAL HOSPITAL

NORTH ADAMS MA Voluntary non-profit – Private 1 0 1

MA Voluntary non-profit – Private 1 0 1

HOSPITAL

NORWOOD MA Proprietary 4 0

MEDICAL CENTER

QUINCY MA Proprietary 1 1 5

MA Proprietary 2 0 3

LOWELL MA

2 0 4

MA Voluntary non-profit – Private 5 0

FALL RIVER MA Voluntary non-profit – Private 7 1 10

MA Proprietary 4 0 8

MA Proprietary 4 0 8

MA Voluntary non-profit – Other 1 0 3

BOSTON MA Voluntary non-profit – Private 1 1 5

WORCESTER MA Voluntary non-profit – Private 5 0

Hospital City State Ownership type Complete reports (?) Missing reports (?) Violations
ANNA JAQUES HOSPITAL NEWBURYPORT MA Voluntary non-profit – Private 3 0 5
BAYSTATE FRANKLIN MEDICAL CENTER GREENFIELD 1
BAYSTATE MEDICAL CENTER SPRINGFIELD
BERKSHIRE MEDICAL CENTER INC PITTSFIELD Voluntary non-profit – Other
BETH ISRAEL DEACONESS MEDICAL CENTER BOSTON 4 6
BRIGHAM AND WOMEN’S HOSPITAL 9 13
CAMBRIDGE Government – Local
CAPE COD HOSPITAL HYANNIS
CARNEY HOSPITAL Proprietary
COOLEY DICKINSON HOSPITAL INC,THE NORTHAMPTON
DANA-FARBER CANCER INSTITUTE
EMERSON HOSPITAL W CONCORD
FAULKNER HOSPITAL
GOOD SAMARITAN MEDICAL CENTER BROCKTON
HARRINGTON MEMORIAL HOSPITAL SOUTHBRIDGE
HEALTHALLIANCE HOSPITALS, INC LEOMINSTER 7
HOLY FAMILY HOSPITAL METHUEN
JORDAN HOSPITAL INC PLYMOUTH
LAHEY CLINIC HOSPITAL BURLINGTON 12
LAWRENCE
LOWELL
MARLBOROUGH
MASSACHUSETTS GENERAL HOSPITAL
MERCY MEDICAL CENTER
MERRIMACK VALLEY HOSPITAL HAVERHILL 8
METROWEST MEDICAL CENTER FRAMINGHAM
MILFORD
MILTON Government – Federal
MORTON HOSPITAL TAUNTON 14
MOUNT AUBURN HOSPITAL
NASHOBA VALLEY MEDICAL CENTER AYER
NEWTON
NOBLE HOSPITAL WESTFIELD
NORTH SHORE MEDICAL CENTER SALEM
NORWOOD 11
QUINCY
SAINT ANNE’S HOSPITAL FALL RIVER
SAINTS MEDICAL CENTER INC Voluntary non-profit – Church
SOUTH SHORE HOSPITAL SOUTH WEYMOUTH 10
SOUTHCOAST HOSPITAL GROUP, INC
ST ELIZABETH’S MEDICAL CENTER BRIGHTON
ST VINCENT HOSPITAL WORCESTER
STURDY MEMORIAL HOSPITAL ATTLEBORO
TUFTS MEDICAL CENTER
UMASS MEMORIAL MEDICAL CENTER INC 17

http://www.hospitalinspections.org/hospital/anna-jaques-hospital-220029

http://www.hospitalinspections.org/hospital/cooley-dickinson-hos-220015

http://www.hospitalinspections.org/hospital/dana-farber-cancer-i-220162

http://www.hospitalinspections.org/hospital/emerson-hospital-220084

http://www.hospitalinspections.org/hospital/faulkner-hospital-220119

http://www.hospitalinspections.org/hospital/good-samaritan-medic-220111

http://www.hospitalinspections.org/hospital/harrington-memorial-220019

http://www.hospitalinspections.org/hospital/healthalliance-hospi-220001

http://www.hospitalinspections.org/hospital/holy-family-hospital-220080

http://www.hospitalinspections.org/hospital/jordan-hospital-inc-220060

http://www.hospitalinspections.org/hospital/lahey-clinic-hospita-220171

http://www.hospitalinspections.org/hospital/baystate-franklin-me-220016

http://www.hospitalinspections.org/hospital/lawrence-general-hos-220010

http://www.hospitalinspections.org/hospital/lowell-general-hospi-220063

http://www.hospitalinspections.org/hospital/marlborough-hospital-220049

http://www.hospitalinspections.org/hospital/massachusetts-genera-220071

http://www.hospitalinspections.org/hospital/mercy-medical-center-220066

http://www.hospitalinspections.org/hospital/merrimack-valley-hos-220174

http://www.hospitalinspections.org/hospital/metrowest-medical-ce-220175

http://www.hospitalinspections.org/hospital/milford-regional-med-220090

http://www.hospitalinspections.org/hospital/milton-hospital-inc-220108

http://www.hospitalinspections.org/hospital/morton-hospital-220073

http://www.hospitalinspections.org/hospital/baystate-medical-cen-220077

http://www.hospitalinspections.org/hospital/mount-auburn-hospita-220002

http://www.hospitalinspections.org/hospital/nashoba-valley-medic-220098

http://www.hospitalinspections.org/hospital/newton-wellesley-hos-220101

http://www.hospitalinspections.org/hospital/noble-hospital-220065

http://www.hospitalinspections.org/hospital/north-shore-medical-220035

http://www.hospitalinspections.org/hospital/norwood-hospital-220126

http://www.hospitalinspections.org/hospital/quincy-medical-cente-220067

http://www.hospitalinspections.org/hospital/saint-annes-hospita-220020

http://www.hospitalinspections.org/hospital/saints-medical-cent-220082

http://www.hospitalinspections.org/hospital/berkshire-medical-ce-220046

http://www.hospitalinspections.org/hospital/south-shore-hospital-220100

http://www.hospitalinspections.org/hospital/southcoast-hospital-220074

http://www.hospitalinspections.org/hospital/st-elizabeths-medic-220036

http://www.hospitalinspections.org/hospital/st-vincent-hospital-220176

http://www.hospitalinspections.org/hospital/sturdy-memorial-hosp-220008

http://www.hospitalinspections.org/hospital/tufts-medical-center-220116

http://www.hospitalinspections.org/hospital/umass-memorial-medic-220163

http://www.hospitalinspections.org/hospital/beth-israel-deacones-220086

http://www.hospitalinspections.org/hospital/brigham-and-womens-220110

http://www.hospitalinspections.org/hospital/cambridge-health-all-220011

http://www.hospitalinspections.org/hospital/cape-cod-hospital-220012

http://www.hospitalinspections.org/hospital/carney-hospital-220017

## Boston

Hospital City State Ownership type Complete reports (?) Missing reports (?) Violations
BETH ISRAEL DEACONESS MEDICAL CENTER BOSTON MA Voluntary non-profit – Private 4 0 6
BRIGHAM AND WOMEN’S HOSPITAL BOSTON MA Voluntary non-profit – Private 9 0 13
CARNEY HOSPITAL BOSTON MA Proprietary 2 0 6
DANA-FARBER CANCER INSTITUTE BOSTON MA Voluntary non-profit – Private 1 0 2
FAULKNER HOSPITAL BOSTON MA Voluntary non-profit – Private 3 0 9
MASSACHUSETTS GENERAL HOSPITAL BOSTON MA Voluntary non-profit – Private 1 0 1
TUFTS MEDICAL CENTER BOSTON MA Voluntary non-profit – Private 1 1 5

http://www.hospitalinspections.org/hospital/beth-israel-deacones-220086
http://www.hospitalinspections.org/hospital/brigham-and-womens-220110
http://www.hospitalinspections.org/hospital/carney-hospital-220017
http://www.hospitalinspections.org/hospital/dana-farber-cancer-i-220162
http://www.hospitalinspections.org/hospital/faulkner-hospital-220119
http://www.hospitalinspections.org/hospital/massachusetts-genera-220071
http://www.hospitalinspections.org/hospital/tufts-medical-center-220116