For the Unit VII Essay, you will visit an art museum of your choice. You may visit one in person or take a virtual tour via the Internet. Below is a list of museums that offer virtual tours that you

Preparing and analyzing data

Part 1: Preparing Data

In Part 1 of the assignment, you will be using a raw data file extracted directly from the Centers for Disease Control's (CDC) WONDER data, which includes many measurements critical to the nation's health. You can read more about CDC WONDER on the CDC website using the link below:

  • Website: https://wonder.cdc.gov/wonder/help/main.html#What%20is%20WONDER

Data File

When creating the data file that you will use for this assignment, cancer information was compiled on deaths by principal site of the cancers, U.S. regions, races, ethnicity and sex of the deceased. Puerto Rico was not included in this particular data pull. Data over three years' time, 2007-2009, were aggregated and presented.

Download and open the Excel spreadsheet below:


  • Source: United States Cancer Mortality Statistics: 1999-2013, WONDER Online Database. United States Department of Health and Human Services, Centers for Disease Control and Prevention; 2016. Accessed at http://wonder.cdc.gov/CancerMort-v2013.html on Apr 7, 2017.

Instructions

Since the data file provided above was a direct data pull from WONDER, several steps are needed to manipulate and prepare the data. Follow the steps in the Assignment Instructions below to prepare the Excel file provided above.

  • Assignment Instructions: part 1

Part 2: Analyzing Data

After successfully completing Part 1 of this assignment, you should have a set of data about cancer deaths, organized by types of cancer and sorted by region. Now, in Part 2 of the assignment, you can begin your analysis of the data. Download and open the question sheet below:

  • Question part 2

The names of the files should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below: