working with d-nominate data in excel data are stored on the courses server in the icpsr folder data...
Post on 21-Dec-2015
223 views
TRANSCRIPT
![Page 1: Working with D-nominate data in Excel Data are stored on the courses server in the ICPSR folder Data are in Excel or in Stata format Key variables are:](https://reader030.vdocuments.us/reader030/viewer/2022032522/56649d6c5503460f94a4c32e/html5/thumbnails/1.jpg)
Working with D-nominate data in Excel
• Data are stored on the courses server in the ICPSR folder
• Data are in Excel or in Stata format
• Key variables are:– Congress number– Party (100=Dem, 200=Rep)– First dimension nominate score
![Page 2: Working with D-nominate data in Excel Data are stored on the courses server in the ICPSR folder Data are in Excel or in Stata format Key variables are:](https://reader030.vdocuments.us/reader030/viewer/2022032522/56649d6c5503460f94a4c32e/html5/thumbnails/2.jpg)
Files are in this directory
![Page 3: Working with D-nominate data in Excel Data are stored on the courses server in the ICPSR folder Data are in Excel or in Stata format Key variables are:](https://reader030.vdocuments.us/reader030/viewer/2022032522/56649d6c5503460f94a4c32e/html5/thumbnails/3.jpg)
This is what the spreadsheet looks like. Notice that there are no “header” (variable names). It’s pretty easy to figure out what each column represents. We want columns A and H, but we have to pay attention to column F.
![Page 4: Working with D-nominate data in Excel Data are stored on the courses server in the ICPSR folder Data are in Excel or in Stata format Key variables are:](https://reader030.vdocuments.us/reader030/viewer/2022032522/56649d6c5503460f94a4c32e/html5/thumbnails/4.jpg)
Look at how I will sort the data, on state, then on district, then on year.
![Page 5: Working with D-nominate data in Excel Data are stored on the courses server in the ICPSR folder Data are in Excel or in Stata format Key variables are:](https://reader030.vdocuments.us/reader030/viewer/2022032522/56649d6c5503460f94a4c32e/html5/thumbnails/5.jpg)
The data are now sorted the way I want.
![Page 6: Working with D-nominate data in Excel Data are stored on the courses server in the ICPSR folder Data are in Excel or in Stata format Key variables are:](https://reader030.vdocuments.us/reader030/viewer/2022032522/56649d6c5503460f94a4c32e/html5/thumbnails/6.jpg)
I have deleted all rows except for Illinois districts.
![Page 7: Working with D-nominate data in Excel Data are stored on the courses server in the ICPSR folder Data are in Excel or in Stata format Key variables are:](https://reader030.vdocuments.us/reader030/viewer/2022032522/56649d6c5503460f94a4c32e/html5/thumbnails/7.jpg)
First, I copy/paste the data for member two to the right of the data for member one.
Hey why does this not line up??
![Page 8: Working with D-nominate data in Excel Data are stored on the courses server in the ICPSR folder Data are in Excel or in Stata format Key variables are:](https://reader030.vdocuments.us/reader030/viewer/2022032522/56649d6c5503460f94a4c32e/html5/thumbnails/8.jpg)
Now I create three new columns. I title the first dimension for member 1 “1 Dem” since that seat was always held by a Dem. I make two more columns (2 Rep and 2 Dem) for the second district data. Now I manually copy/paste.
![Page 9: Working with D-nominate data in Excel Data are stored on the courses server in the ICPSR folder Data are in Excel or in Stata format Key variables are:](https://reader030.vdocuments.us/reader030/viewer/2022032522/56649d6c5503460f94a4c32e/html5/thumbnails/9.jpg)
Now I have reorganized things, eliminated extraneous columns, and am working with district 3.
![Page 10: Working with D-nominate data in Excel Data are stored on the courses server in the ICPSR folder Data are in Excel or in Stata format Key variables are:](https://reader030.vdocuments.us/reader030/viewer/2022032522/56649d6c5503460f94a4c32e/html5/thumbnails/10.jpg)
Now I am done with district 3 data.
![Page 11: Working with D-nominate data in Excel Data are stored on the courses server in the ICPSR folder Data are in Excel or in Stata format Key variables are:](https://reader030.vdocuments.us/reader030/viewer/2022032522/56649d6c5503460f94a4c32e/html5/thumbnails/11.jpg)
Now my graphic is ready to paste into my paper.