SOCS
Explanatory and Response Variables
Excel Review Week 1
Correlations
Excel Review Week 2
100
This is the acronym that defines how we interpret a histogram (tell me what each letter of the acronym stands for).
What is SOCS (shape, outliers, center, and spread)?
100

This variable represents the outcome of the response. 

What is a response variable?

100

# Of credit hours          frequency          

1 to 3                            2 

4 to 6                            6 

7 to 9                           10 

10 to 12                        27 

13 to 15                        41 

16 to 18                        14 

19 to 21                         2

The percentage of students who take at least 13 credit hours is (round to 0 decimal places) ...

What is 56%?

100

r will always fall in between these two numbers.  

What are -1 and 1?

100

This is the Excel function used to solve for the minimum value.

What is "=MIN ()"?

300

The median is resistant to outliers and the mean ___ resistant to outliers.

What is "is not" resistant outliers?

300

This variable can also be referred to as an independent variable.

What is an explanatory variable?

300

# of cups of coffee per day              frequency 

0                                                     13 

1                                                     45 

2                                                     25 

3                                                     15 

4                                                      4

The median number of cups of coffee drank is (round 2 decimal places and use Excel) ...


What is 1.53 cups of coffee (=SUMPRODUCT (x-values, y-values)/SUM(y-values)? 

300

r = ___ when there is a perfect linear relationship.

What is r = 1 or r = -1?

300

This is the Excel function that helps us find the sample variance.

What is "=Var.S ()"?

500

Distribution: 5,5,5,7,8,2,1,0,3

The mean is... (you need to tell me what Excel function to use to get credit).

What is 4 (use the function, =AVERAGE ())?

500

These are the 3 potential direction relationships in a scatterplot.

What is a positive, negative, or neither positive nor negative relationship?

500

Find the mean, median, and mode of the distribution: 7, 8, 2, 3, 1, 9, 6, 4, 2, 1


What is 4.3 (mean), 3.5 (median), and 1&2 (mode)?
500

This is the Excel function used to calculate the correlation of a data set.

What is "=CORREL (DATA x, DATA y)"?

500

This is the step-by-step process to find the IQR in Excel (you need to solve for 3 Excel functions):

What is Q1 (quartile.INC (data array, 1), Q3 (=quartile.INC (data array, 3), and IQR (=quartile.INC (data array, 3) - quartile.INC (data array, 1))?

M
e
n
u