USA: +1(669)289-8683 
Sign in
1. Is the Massachusetts data set population or sample data? Please explain your answer.
2. Is the Boston data set population or sample data? Please explain your answer.
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.
>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 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-adams-regional-220051 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 http://www.hospitalinspections.org/hospital/beth-israel-deacones-220086
2
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 ADAMS
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
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/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
