• You must document all SPSS output necessary to show your work. Points will be taken off for any
answers below that are not supported by SPSS output.
• References numbers in your written answer and/or highlight the SPSS output numbers that correspond to
• Bring one hard copy and upload one Word document labeled as A4_lastname(s)
• Automatic 10 points out for not using the format below. Keep all questions with points intact.
• You will receive zero points for any answer that uses examples from class/class materials.
Univariate Analysis. Using the student questionnaire data (SQ_A4) set under Content, under Quantitative
Tools and Data) on Beachboard, answer the following questions:
• What is the category/attribute with the highest frequency for the parental pressure variable (use
parpres)? (3 pts).
• What is the mean and range for age in the sample? (3 pts.)
• Choose a variable for which the median would be an appropriate central tendency. Report the variable
and the median value here (3 pts.)
• Report the relative frequency for any appropriate variable you choose. (3 pts.)
4. Test the relationship between sex and GPA. Hint: Use crosstab in SPSS to create a table for you to analyze (4
• Do you conclude based on your analysis that GPA depends on sex? What numbers tell you that(4 pts.)
• If you found a relationship, what is the strength of the relationship? Refer to numbers (2 pts.)
5. Use the Census data set on Long Beach (Census_A4) to examine the relationship between race (use
race1p_4cats) and household income (hincp2_cats) using a bivariate crosstab (4 pts.)
• Which racial group has the highest level of households with lower income? Hint: Examine the percent
within race row. (3 pts.)
• Among those with higher household income, what racial group makes up the largest percent? (3 pts.)
• What is the total number of Others in the total sample (2 pts.) Hint: Total sample is 1000.
• What percent represents lower income Asian households in the total sample? (2 pts.) Hint: There are
three rows that calculate percent totals. Make sure your on the right row.
6. Using the student questionnaire data set (SQ_A4) or the Census data set available to you on the class website
examine the relationship between two nominal/categorical variables using a bivariate crosstab (4 points)
• Name the variables you chose and why you think they are related. (6 points)
• Is there a relationship between the two variables? (2 points)
• Discuss the strength of the relationship and what numbers tell you about the level of the strength? (2
• What do the results tell you about the two variables? Related or not and why (based on the numbers)? (2
Data Presentation and Graphing. For the last two questions you need to use the student questionnaire data
• Univariate Analysis. Make a column chart in Excel that shows the frequency distribution for the
momed2_cats variable that represents level of mother’s education. Copy and paste SPSS output that
gives you frequency (4 pts.) Copy and paste one final chart made in Excel that includes a)-f).
• Relative frequency in the form of percent with a percent sign and one decimal space (using add data
labels in Excel). (2 points)
• Chart title (select above chart, under chart tools, layout. To get to chart tools you need to click once on
graph). (2 points)
• Two columns with two different colors. (2 points)
• A legend (show legend at right option under chart tools, layout). (1 point)
• Labels for both the x and y axis with the appropriate label. (2 points)
• A source at the bottom of the chart that says Source: Student Questionnaire Data Set, 2012, Author’s
Tabulation. Use a smaller font than the rest of the words in your column chart for source. (1 point)
• Bivariate Analysis. a) Create a table (similar in format to table below on race and homeownership) in
Excel that shows the relationship between sex and level of busy (busy_2, more busy or less busy). Note
that source should be cited as Student Questionnaire Data Set, 2012. Provide SPSS output from crosstab
conducted (7 points)
b) Write three sentences that interpret percentages from the contingency table you created in Excel. (3
What Students Are Saying About Us.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."