Module 5 Worksheet

What is your favorite TV show right now?

Anime and K-Drama greatly accepted!

What is an alternative to clicking the “Select All Button”?

• CTRL+A

• CTRL+C

• CTRL+SHIFT+A

• CTRL+V

What does “Sort A to Z” do to a dataset when applied to a numerical variable?

• Sort the values from largest to smallest

• Sort the values from smallest to largest

• Values are numerical so they do not get sorted

• It sorts based on the categorical value they are associated with

When do we use COUNTBLANK? COUNTIF?

• COUNTBLANK counts the number of empty cells, while COUNTIF counts the number of cells that meet a specific condition.

• COUNTBLANK counts the number of cells that contain any value, while COUNTIF counts the number of cells that are completely empty.

• COUNTBLANK counts the number of cells with missing values, while COUNTIF counts the number of cells with non-missing values.

• None of the above.

CTRL+SHIFT+↓ Extend the selection to the last cell down.

• True

• False

Match the following

• Unimodal

  Skewed Right

• 
• Bimodal,

  Skewed Left

• 
• Uniform

• 
• Unimodal

  Symmetrical

• 
• Unimodal

  Skewed Left

• 

Match the following

• Median = Mean

• Skewed Right

• Median > Mean

• Symmetric

• Median < Mean

• Skewed Left

Match the following

Note : Sample size = 96

• BMI

• Y-axis

• Frequency

• X-axis

• 9

• Range

• 26

• 26

• Median

• Mode

Is the data unimodal?

• Yes

• No

Match the following

• 25

• Median

• -3

• Upper Outlier(s)

• 7

• Lower Boundary

• 5

• Mean

• 6

• IQR