Rubric for Assignment 4
Problem 2 (18 points)
- Crosstabs: 2 points (Note: you have to do this table using Excel’s COUNTIFS function! You will redo this table with the PIVOT TABLE function in the last problem. You will not get credit if you do not do it with COUNTIFS).
Column chart: 2 points. Remember that the crosstab is a table whereas the column chart is a graph. They are not the same thing. It is very important that the percentages for either gender add to 100%.
Do the two genders differ in their opinions? 2 points.
b. Same as part a) but know you are looking at the relationship between Age and Opinion (6 points distributed as in part a)
- Same as part a) but know you are looking at the relationship between recoded salary and Opinion (6 points distributed as in part a).
Problem 8 (18 points)
Use Tables in Excel and then filter accordingly and obtain the required measures from the summary statistics of the filtered data.
a) Gender recoding (2 points). Mean of Males (1 point), mean of females (1 point), median of males (1 point), median of females (1 points), std. dev of males (1 points) std. dev. of females (1 points).
b) Education recoding (2 points). 1 point for getting the mean, median and std. dev. of new Education level 1. 1 point for getting the mean, median and std. dev. of new Education level 2. 1 point for getting the mean, median and std. dev. of new Education level 3.
c) Age recoding (2 points). 1 point for getting the mean, median and std. dev. of Young. 1 point for getting the mean, median and std. dev. of Middle-Aged. 1 point for getting the mean, median and std. dev. of Older.
Problem 21 (16 points
- Table of correlations (4 points)
Which one is most highly correlated with salary? (1 point)
b. Create scatterplots (6 points, 2 points each scatterplot). Do not forget to label the axis.
- Include a linear trend and equation in the scatterplot of the most highly correlated variable from part a)(3 points)
Interpret the equation, specifically what happens with Salary if the most highly correlated variable increases by 1? (2 points)
Problem 34: (18 points)
Here you need to provide three crosstabs and three column charts constructed with PIVOT TABLES and with the sum of the row percentages being equal to 100% (6 points). Interpret the results in terms of how the variables are related (3 point).
Then you need to provide another three crosstabs and three column charts constructed with PIVOT TABLES and with the sum of the column percentages being equal to 100% (6 points). Interpret the results in terms of how the variables are related (3 points).
Total points: 70
