DATA ANALYSIS ASSIGNMENT

Directions: Please answer the questions and exercises below using either SPSS or Excel and the data from the PDF file (RAWDATA). Please be brief in answering the questions below and provide the output and answers in only 1 word document; th e data file you are to create needs to be printed out and put in a PDF file.

Scenario: Participants were randomly called to participate in a telephone survey about their attitudes concerning people with HIV.

1. Enter data from the PDF file (RAWDATA) into an Excel or SPSS file.
   • Be sure to use the coding provided.
   • Be sure to use only 1 line in the Excel or SPSS file for each participant.
   • Develop your own names for the variables. For example, for gender you can call this variable "gender" or "sex"; make sure that the names of the variables make sense.
   • Tally the scores for the HIV Stigma Scale to create a single composite of the scale; make sure you do the reverse coding of the items that have a reverse valence (4=1, 3=2, 2=3, 1=4). Items with reverse scores are questions 2, 4, 5, 6, 7, 9, 11, and 13.
   • Make a hard copy of the data file and convert it to a PDF file and provide the complete database in an attached file. (20 points)
     Data Analysis Tips:
   • Whether you use Excel or SPSS, be sure to give yourself some time to become familiar with either program. Each one has idiosyncratic properties and will take time to get use to.
   • Feel free to collaborate with your classmates concerning how to use the programs since some of you will have more experience with these programs than others.
   • For this assignment, set all statistical tests to an alpha of .05 .
     Data Analysis Tips for Excel:
   • Go to Formulas, then More Functions, then Statistical.
   • Once there, you can choose which statistical analysis to use. All of the statistical functions that you need are here. They will be in abbreviated form. Definitions are provided and instructions are provided for each. Feel free to click on the help button when within each statistical function if you require additional assistance.
   • You must specify the cells that are to be considered in the analysis.
   • The analysis will provide the result within your data file.
   • Feel free to use the tutorial if you are not familiar with Excel.
     Data Analysis Tips for SPSS :
   • For producing descriptive statistics, go to Analyze, then to Descriptive Statistics, then to Frequency and Descriptive, select the variables you want to analyze, then click on either Statistics or Options to chose the statistics you want (e.g., means, standard deviation, range, etc.). Then click on OK.
   • For conducting a t-test, go to Analyze, then to Compare Means, then to One-Way ANOVA, then put the independent variable in the Factor box and the dependent variable into the Dependent List box. Then click on OK.
   • For conducting a correlation, go to Analyze, then to Correlate, then to Bivariate. Then click on the two variables you want to correlate. Then click on OK. By the way, Pearson correlation is the default; stick with the default.
   • For conducting a chi-square, got to Analyze, then to Descriptive Statistics, then to Cross Tabs, select one nominal variable to be in the row and another nominal variable to be in the column (it doesn’t matter which one you put where as long as both aren’t in the same row or column). Then click on Statistics and click on the Chi-Square box. Then click on OK.
   • Feel free to use the tutorial if you are not familiar with SPSS.
2. Cut and paste the descriptive statistics (frequencies for nominal data variable(s) and means, standard deviation, and ranges for ordinal, interval, and ratio data variables) of all of the variables. (20 points)
3. Are there significantly more men 50 and older compared to the women 50 and older? Yes or No? Provide the value (Pearson value for those using SPSS) of the appropriate statistical test needed to answer this question along with the degrees of freedom and the p-value. Cut and paste your output as well. (20 points)

HINT: In order to analyze this, you will need to create another age variable and put a 0 for those younger than 50 and a 1 for those 50 and older. This is called recoding.

4A. We hypothesize that men will have more negative attitudes towards people with HIV. Clearly state what the null hypothesis is and what the alternative hypothesis is. (10 points)

The Null Hypothesis –

The Alternative Hypothesis –

4B. Statistically test this hypothesis stating why you accept the null or alternative hypothesis and provide the values of the appropriate statistical test (statistical value, p-value, etc.) needed to answer this using the data provided in your SPSS or Excel file you created. Cut and paste your output as well. (10 points)

5A. We hypothesize that those who are more educated will have more positive attitudes towards people with HIV. Clearly state what the null hypothesis is and what the alternative hypothesis is. (10 points)

The Null Hypothesis –

The Alternative Hypothesis –

5B. Statistically test this hypothesis stating why you accept the null or alternative hypothesis and provide the values of the appropriate statistical test (statistical value, p-value, etc.) needed to answer this using the data provided in your SPSS or Excel file you created. Cut and paste your output as well. (10 points)

Price: $19.7

Solution: The downloadable solution consists of 8 pages, 1170 words and 13 charts.
Deliverable: Word Document