ID Number Gender (0=Woman, 1=Man) Exam 1 Exam 2 Exam 3 Homework Lab Number Grade Letter Grade Z-Score 0 61 94 76 94 87 99 97 90 100 89 A W N H 64 76 69 88 87 77 82 86 98 94 70 89 81 93 97 67 62 65 60 90 87 83 81 85 68 74 88 65 49 90 91 97 87 81 94 94 87 77 90 67 10 47 72 54 59 63 81 64 78 84 73 90 81 93 80 87 96 100 84 97 84 80 76 90 85 85 15 69 74 78 64 51 16 70 86 84 77 75 98 95 98 80 93 83 84 88 83 90 19 52 46 62 70 59 20 83 85 98 97 83 80 74 90 83 65 86 81 72 85 97 23 88 99 91 94 98 70 80 83 70 71 25 95 81 93 88 83 26 83 70 75 81 76 55 60 60 71 49 28 82 77 82 78 67 29 87 91 95 95 100 30Calibri Bold (Body B U A.. A A X This account does not allow editing on your device. For an account with full access, contact your organization about your subscription plan. Sign in Questions (1 point each - please write your answers in blue): 1. Row vs. Column a. Are the data entered in row format or column format? b. What is one advantage of entering data in row format? 2. For the variables below, state whether they are independent, quasi-independent, or dependent variables in this situation. Briefly explain why. a. Gender b. Number Grade 3. For the following variables, state whether they are nominal, ordinal, interval, or ratio: a. Gender 2 b. Number Grade c. Letter Grade d. Z-score 4. Weighted Mean a. Did you have to calculate the Number Grade variable using the weighted mean? Why? b. When should you use the weighted mean instead of the regular mean? 5. Frequencies a. How many women were in the class? b. Paste the frequency table that shows this data below. 6. Percentages a. What percentage of the class identified as men? b. How is the Valid Percent column different from the Percent column? 7. Distribution Plots a. For the Number Grade variable, create a Distribution Plot and apply a density curve. Paste the graph below. b. Does this plot appear to be fairly normal? 8. Normality/Skewness a. What is the skewness value for the Number Grade variable? b. Does this mean the distribution of Number Grades is normal or skewed? Why? 9. Descriptive Statistics a. Give the mean, median, mode, standard deviation, minimum, and maximum for the Number Grades variable (round to two decimal places). b. Look at these same descriptive statistics for Exam 1, Exam 2, and Exam 3. On average, which exam did students score best on? 10. Descriptive Statistics by Group a. Give the mean, median, mode, and standard deviation for the Number Grades variable for men and for women separately. b. On average, did men or women do better in the course? Do you think this difference is significant?7:39 PM Mon Oct 'l'i