Select a continuous variable from the data set and provide full definition for each variable.

Assignment : Data Structure ET

This week you considered the many possibilities for the way that data are structured within your database. Your understanding of that data structure is pivotal as you analyze the data. By now, you know that having the ability to identify and manipulate the different variables in the database will allow you to obtain meaningful information and maybe even find new information that was not initially collected.

For this Assignment, you will use a given data set to create and update a database in SPSS.

To prepare:

• Use the original (not modified) data set selected for your SPP (on week 1), and open it in SPSS.

Perform the following operations on the data set:

• Select a continuous variable from the data set and provide full definition for each variable.

• Convert your continuous variable to a categorical variable.

• Provide reason for how you converted the variable.

• Provide descriptive statistics for the continuous variable.

• Produce frequency tables for the new variable you made.

• If any of the cells in your frequency table has less than 6 individuals in it, combine thatlevel with other levels so there is no frequency less than 6.

• Submit descriptive statistics for both the original and new variables.

Resources

UCLA. Learning SPSS. https://stats.idre.ucla.edu/spss/seminars/notes/fmi/

CDC. State-Based Birth Defect Tracking

Systems. https://www.cdc.gov/ncbddd/birthdefects/states/index.html

CDC. BRFSS 2011 Codebook

Report. https://www.cdc.gov/brfss/annual_data/2011/pdf/codebook11_llcp.pdf

http://calcnet.mth.cmich.edu/org/spss/data_manipulation.htm

http://calcnet.mth.cmich.edu/org/spss/toc.htm

Hellerstein, J. M. (2008). Quantitative data cleaning for large databases. Retrieved from

http://db.cs.berkeley.edu/jmh/papers/cleaning-unece.pdf

Last Completed Projects