Instructions

There are five multiple-choice questions. You have 90 minutes to complete the following section.

Attached HERE

Download Attached HERE

are instructions for calculating 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

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

Group of answer choices

17

44.9

21.3

22.9

Flag question: Question 2

Question 2

0.4pts

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

(SELECT ALL THAT APPLY)

Group of answer choices

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

Flag question: Question 3

Question 3

0.4pts

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

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)

Group of answer choices

20 - 25%

26 - 30%

31 - 35%

36 - 40%

Flag question: Question 4

Question 4

0.4pts

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

Group of answer choices

17

22

22.9

23

Flag question: Question 5

Question 5

0.4pts

Followthese instructions (download)

Download these instructions (download)

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 ____.

Group of answer choices

1.9, 4.0

3.2, 0.6

2.0, 4.4

2.6, 3.8