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 sorted5. 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 graph8. 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 sort9. 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
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 categorical15. 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.
Attachments: