Download the data set at http://snhu-media.snhu.edu/files/course_repository/graduate/pol/pol510/pol510_anes2000_dataset.xlsx
This is a download so you will have to open the excel download
Open the simplified codebook as you will only be using this for the assignment at http://snhu-media.snhu.edu/files/course_repository/graduate/pol/pol510/pol510_simplified_codebook.xlsx
This is also a download that you will have to open.
To look at the 1996 data you will look at the codebook and create a chart that represents the central frequency you think is best…see the announcement earlier this week where I discussed how to choose center frequency. The code book column you want is (v000304) and you generate and evaluate a frequency distribution for this variable. For the 2000 election you will look at column (v001249). You will have two separate charts. And should compare them when answering the other questions: After comparing these two measures, what differences do you see in the data? What conclusions can you draw from this comparison? In your response, use complete sentences and explain in detail what the numbers mean.
when you create your “bin” (a way of sorting data in a histogram) it is just the numbers in the “y” axis. So in excel type in one cell the word bin and then in each cell under it you type 1,3,5,7 (1996 election) and 1,2,3,4,5,6,7 (2000 election). Then you go to data analysis, select histogram, select the input range (the cells you want to get the frequency: $a$2:$a$857 etc). This should make the frequency easy to find.
This is a screen shot for just the 1996.
Once you do this in the data analysis tool histogram it will open a new window in excel with frequency.
Bin Frequency
1 430
3 318
5 88
7 20
More 0
Once you have this you will then go into the “insert chart” and select the right chart (hint: Histogram).
Once you have the two charts you will then need to use your own impressions and answer the questions.
I hope this helps
Activity 6.1 Assignment – Step by step instructions
Download the data set at http://snhu-media.snhu.edu/files/course_repository/graduate/pol/pol510/pol510_anes2000_dataset.xlsx
This is a download so you will have to open the excel download
Open the simplified codebook as you will only be using this for the assignment at http://snhu-media.snhu.edu/files/course_repository/graduate/pol/pol510/pol510_simplified_codebook.xlsx
This is also a download that you will have to open.
To look at the 1996 data you will look at the codebook and create a chart that represents the central frequency you think is best…see the announcement earlier this week where I discussed how to choose center frequency. The code book column you want is (v000304) and you generate and evaluate a frequency distribution for this variable. For the 2000 election you will look at column (v001249). You will have two separate charts. And should compare them when answering the other questions: After comparing these two measures, what differences do you see in the data? What conclusions can you draw from this comparison? In your response, use complete sentences and explain in detail what the numbers mean.
when you create your “bin” (a way of sorting data in a histogram) it is just the numbers in the “y” axis. So in excel type in one cell the word bin and then in each cell under it you type 1,3,5,7 (1996 election) and 1,2,3,4,5,6,7 (2000 election). Then you go to data analysis, select histogram, select the input range (the cells you want to get the frequency: $a$2:$a$857 etc). This should make the frequency easy to find.
This is a screen shot for just the 1996.
Once you do this in the data analysis tool histogram it will open a new window in excel with frequency.
Bin Frequency
1 430
3 318
5 88
7 20
More 0
Once you have this you will then go into the “insert chart” and select the right chart (hint: Histogram).
Once you have the two charts you will then need to use your own impressions and answer the questions.
I hope this helps
