Number	Gender	Exam 1	Exam 2	Exam 3	Homework	Lab	Number grade	Letter grade	Z-score	Absolute z-score
1	0	61	94	76	94	87	82.4	B	0.18	0.18
2	0	99	97	90	100	89	95	A	1.38	1.38
3	0	64	76	69	88	87	76.8	C	-0.36	0.36
4	0	77	82	86	98	94	87.4	B	0.66	0.66
5	0	70	89	81	93	97	86	B	0.52	0.52
6	0	67	62	65	60	90	68.8	D	-1.13	1.13
7	0	87	83	81	85	68	80.8	B	0.02	0.02
8	0	74	88	65	49	90	73.2	C	-0.71	0.71
9	0	91	97	87	81	94	90	A	0.90	0.90
10	0	94	87	77	90	67	83	B	0.23	0.23
11	0	47	72	54	59	63	59	F	-2.07	2.07
12	0	81	64	78	84	73	76	C	-0.44	0.44
13	0	87	90	81	93	80	86.2	B	0.54	0.54
14	0	96	100	84	97	84	92.2	A	1.12	1.12
15	0	80	76	90	85	85	83.2	B	0.25	0.25
16	0	64	51	69	74	78	67.2	D	-1.28	1.28
17	0	70	86	84	77	75	78.4	C	-0.21	0.21
18	0	80	93	98	95	98	92.8	A	1.17	1.17
19	0	88	83	83	90	84	85.6	B	0.48	0.48
20	0	52	46	62	70	59	57.8	F	-2.19	2.19
21	0	97	83	83	85	98	89.2	B	0.83	0.83
22	1	80	74	90	83	65	78.4	C	-0.21	0.21
23	1	86	81	72	85	97	84.2	B	0.35	0.35
24	1	88	99	91	94	98	94	A	1.29	1.29
25	1	70	70	71	80	83	74.8	C	-0.55	0.55
26	1	81	93	88	83	95	88	B	0.71	0.71
27	1	83	70	75	81	76	77	C	-0.34	0.34
28	1	49	55	60	60	71	59	F	-2.07	2.07
29	1	77	82	78	67	82	77.2	C	-0.32	0.32
30	1	95	87	100	91	95	93.6	A	1.25	1.25

Questions (1 point each - please write your answers in blue):

1. Row vs. Column
   1. Are the data entered in row format or column format?
   2. 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.
   1. Gender
   2. Number Grade
3. For the following variables, state whether they are nominal, ordinal, interval, or ratio:
   1. Gender
   2. Number Grade
   3. Letter Grade
   4. Z-scor
4. Weighted Mean
   1. Did you have to calculate the Number Gradevariable using the weighted mean? Why?
   2. When should you use the weighted mean instead of the regular mean?
5. Frequencies
   1. How many women were in the class?
   2. Paste the frequency table that shows this data below.
6. Percentages
   1. What percentage of the class identified as men?
   2. How is the Valid Percentcolumn different from the Percentcolumn?
7. Distribution Plots
   1. For the Number Gradevariable, create a Distribution Plot and apply a density curve. Paste the graph below.
   2. Does this plot appear to be fairly normal?
8. Normality/Skewness
   1. What is the skewness value for the Number Gradevariable?
   2. Does this mean the distribution of Number Gradesis normal or skewed? Why?
9. Descriptive Statistics
   1. Give the mean, median, mode, standard deviation, minimum, and maximum for the Number Gradesvariable (round to two decimal places).
   2. 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
    1. Give the mean, median, mode, and standard deviation for the Number Gradesvariable for men and for women separately.
    2. On average, did men or women do better in the course? Do you think this difference is significant?
11. Boxplots
    1. Create boxplots for Number Gradeseparately for men and for women; make sure to label outliers. Paste your boxplots below.
    2. Is there more variability in the distribution for men or for women? How can you tell?
12. Outliers
    1. In the boxplot you created for the questions above, how many outliers are there?
    2. What do the numbers next to each outlier dot stand for?
13. Percentiles
    1. When looking at the whole sample, what value corresponds to the 70^th percentile for the Homeworkvariable?
    2. What does scoring in the 70^th percentile mean?
14. Z-Scores
    1. How many Number Gradeshave an absolute Z-score of 2 or higher?
    2. What Letter Gradecoincides with having a Z-score of -2 or lower?
15. Transforming Numerical Data to Categorical Data
    1. How many A's did students receive in your class? What percentage of the class received B's?
    2. Paste the frequency table you used to answer the above question below.
16. Extra Credit: Transforming Numerical Data to Categorical Data using =IF()
    1. Paste the =IF() formula you used to assign Letter Gradesbased on the Number Gradevariable below.