1 / 18

PDQ-Explore

PDQ-Explore. Analyzing Poverty and Socioeconomic Trends. Objectives. To learn to: Open the PDQ-Explore Graphical Interface Set up and Execute a PDQ-Explore Query Tabulations Summary Statistics Manipulate Results Totals Percentages Pivoting Sorting Save and Export Results.

dusan
Download Presentation

PDQ-Explore

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. PDQ-Explore Analyzing Poverty and Socioeconomic Trends Analyzing Poverty June 22-26, 2009

  2. Objectives Analyzing Poverty June 22-26, 2009 • To learn to: • Open the PDQ-Explore Graphical Interface • Set up and Execute a PDQ-Explore Query • Tabulations • Summary Statistics • Manipulate Results • Totals • Percentages • Pivoting • Sorting • Save and Export Results

  3. Requirements • PC (Not Mac) with Windows NT or later • 128 MB RAM or more • 100 MB free hard disk space • Write access to installation drive • USB Port (if using flash drive) • Connection to Internet Analyzing Poverty June 22-26, 2009

  4. Installation Note • PDQ-Explore is designed to run as a client on a PC that has Internet access to our PDQ server in Ann Arbor: pdq.psc.isr.umich.edu • By default the installation files should be copied to: • C:\Program Files\PDQ • NPC Computing lab machines do not allow write access to the C: drive. • Thus, PDQ-Explore has been installed on Drive M: (user IFS file space) and on Drive E: (external USB flash drive). Analyzing Poverty June 22-26, 2009

  5. Starting PDQ-Explore • Open My Computer and the M: Drive • Open the PDQ Folder • Double-Click on explore.exe • Or: Start, Run, m:\pdq\explore.exe • If using the flash drive, insert the flash drive in the USB port and proceed as above using Drive E: rather than Drive M:. • Note: The USB Drive letter is machine dependent Analyzing Poverty June 22-26, 2009

  6. Getting Started • Confirm server: pdq.psc.isr.umich.edu • No subscriber name/password is required • Enter/Enter/Enter until “Open” window appears • Double-Click on “npc” workspace • Select and expand “ipacs08” data set • Expand “housing” or “person” variable list • Browse through variable list • Open IPUMS documentation: http://usa.ipums.org/usa Analyzing Poverty June 22-26, 2009

  7. Set Up Query • Select a data set (ipacs08) • Right click (or click on the “Query” tab) • Click on “Setup New Expert Query” • Setup window opens • Fill in the blanks (see the following slides and related handouts) • Click on the “Results” tab Analyzing Poverty June 22-26, 2009

  8. Filling in the Blanks – Example 1 • Query Name: Example 1: Emp… • Query Type: Tabulation • Universe/Selection: year=2007 • Row: statefip • Column: empstat • Weight: <default> Analyzing Poverty June 22-26, 2009

  9. Analyzing Poverty June 22-26, 2009

  10. Execute Example 1 • Click on “Results” • To get totals by row and column: • Click on “Options” “Totals” “Both” • To get percentages by row: • Click on “Options” “Percent Options” “Percent by Row” • To sort in descending order on “Unemployed:” • Click on “Unemployed” Analyzing Poverty June 22-26, 2009

  11. Analyzing Poverty June 22-26, 2009

  12. Filling in the Blanks – Example 1A • Query Name: Example 1 • Query Type: Tabulation • Universe/Selection: year=2007 • Row: statefip • Column: empstat:1..2 • Weight: <default> Analyzing Poverty June 22-26, 2009

  13. Analyzing Poverty June 22-26, 2009

  14. Filling in the Blanks – Example 2 • Query Name: Example 2: Sex by St • Query Type: Tabulation • Universe/Selection: year=2007 • Row: statefip • Column: sex • Weight: <default> Analyzing Poverty June 22-26, 2009

  15. Filling in the Blanks – Example 3 • Query Name: Example 3: Poverty • Query Type: Summary Stats • Universe/Selection: year=2007 • Row: metaread • Describe Expression: poverty • Weight: <default> Analyzing Poverty June 22-26, 2009

  16. Filling in the Blanks – Example 4 • Query Name: Example 4: Poverty by Stat • Query Type: Summary Stats • Universe/Sel: year=2007 & poverty>0 • Row: statefip • Describe Exp.: poverty • Weight: <default> Analyzing Poverty June 22-26, 2009

  17. Data Gotchas • You need to know your data: • Relevance to concerns • Variable names • Codes • Limits, top codes • Missing and N/A Codes • Sense of reasonable and unreasonable results Analyzing Poverty June 22-26, 2009

  18. PDQ-Explore Gotchas • You need to know what you can ignore • Focus on tabulations and summary stats • Large tables can be hard to interpret • You need to understand the options: • Percentages • Totals • Sorting • Saving/Exporting/Printing Setups and Results Analyzing Poverty June 22-26, 2009

More Related