Overview: The purpose of this exercise is to allow you to familiarize yourself with and practice using Microsoft Excel's Data Analysis ToolPak and to allow you to apply the statistical methods you have learned. For assistance with the Analysis ToolPak, refer to Atomic Learning. Analyze each problem using the appropriate statistical method, report and interpret the appropriate measures, and illustrate the results appropriate charts, graphs, or both.

Prompt: Use the following resources to complete the analysis. Download the American National Election Studies (ANES 2000) data set. Open and read the Codebook to understand the meaning of each variable. Then open the Simplified Codebook spreadsheet, which is a basic version of the data set with only the variables necessary to complete this analysis.

Refer to the 6-1 Activity: Statistical Exercise video for further instruction.

Analysis

- You are interested in examining how respondents in the survey voted in the 1996 election. Find the appropriate variable (v000304) and generate and evaluate a frequency distribution for this variable. Choose and report the most appropriate measure of central tende Use an appropriate graph to illustrate the results of your analysis.

- Next, compare the 1996 vote for president with the respondent's vote in the 2000 election (v001249). Generate a frequency distribution for this variable, choose and report the most appropriate measure of central tendency, and use an appropriate graph to illustrate the results.

- 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.

Price: $3.94

Solution: The downloadable solution consists of 2 pages, 194 words and 2 charts.
Deliverable: Word Document