Instructions

Students must use Microsoft excel to calculate standard deviation in Excel.

Following is the codebook for the data set below.

Sex: What is your gender identity?

• Response options: M (male), F (female), NB (non binary)
• If missing = leave blank

Age: What is your age in years?

• Response options: Fill-in age in years

• If missing = leave blank

ID Sex GPA Age Age2

1 M 3.3 17

2 M 2.9 26

3 F 2.8 29

4 f 3.8 17

5 3.5 31

6 F 1.9 23

7 M 3.9 34

8 n 3.1 15

9 M 2.2 331

10 NB 2.7 19

11 M 3.6

12 n B 4.0 22

13 F 3.4 20

14 F 3.4 17

15 0 3.0 28

Assume that the response "331" is an error in Age and we remove that response. What is the mean age of this sample?

17

44.9

21.3

22.9

Question 2

Which of the following is NOT a good choice for cleaning this data?

(SELECT ALL THAT APPLY)

I replace every lower-case f with a capital F

I change 331 to 31

I assume that 0 is an error and I replace it with an M

I replace n B with NB

Question 3

You recode Age to a new variable called Age2 such that:

<18 >

18-24 = 2 (young adult)

>24 = 3 (adult)

What is the % of participants in the adult category?

(assume all cases with missing responses are removed from this analysis)

20 - 25%

26 - 30%

31 - 35%

36 - 40%

Question 4

Assuming that missing responses were removed, what is the MEDIAN age in this sample?

Group of answer choices

17

22

22.9

23

Question 5

Students need to calculate the mean and standard deviation using Excel.

1. Calculate the mean for GPA.

2. Calculate the standard deviation for GPA.

With this information, we could expect that 95% of participant GPAs fell between ____ and ____.

1.9, 4.0

3.2, 0.6

2.0, 4.4

2.6, 3.8