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
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 […]