Cross-Tabs
Chi Squares
ANOVA
Correlation
Regression
100

Level of measurement for the DV in a mean comparison table

Interval

100
Frequencies that would be in each cell if the null hypothesis were true

Expected frequencies

100

What USS stands for in an ANOVA model

Unexplained sum of squares
100

Represented by each dot on a scatterplot

One observation of the data

100

Best way to present regression results visually

Table
200

Appropriate way to interpret a cross-tab

Read across the rows

200

Part of a cross-tab used to calculate expected frequencies

Row and column marginals

200

How to calculate R-squared from Excel output of an ANOVA model

Between groups sum of squares (ESS) divided by total sum of squares (TSS)

200

Range of the correlation coefficient (r)

-1 to +1

200

Number of dummy variables needed for an IV with six categories

Five
300

Location of independent variable in a mean comparison table

In the rows

300

Degrees of freedom for a chi square analysis of a 3 by 4 table

6
300

Test of significance for an ANOVA model, based on critical values

F-test

300

Level of measurement required for a correlation model

Interval for both variables
300

Column of Excel output to use for determining regression equation

Coefficients

400

Information needed for each cell in a cross tab

Frequency and percentage

400

Level of measurement needed for the dependent variable in a chi square model

Categorical (nominal or ordinal)

400

Interpretation of an R-squared of 0.56

IV explains 56% of variation in the DV

400

Functions used to calculate correlation coefficient in Excel

CORREL or PEARSON

400

Interpretation of the coefficient of x in:
y = 3.84 - 1.95x + e

One-unit increase in x is associated with a 1.95-unit decrease in y
500

Tool used in Excel to create cross-tabs and mean comparison tables

Pivot table

500

Determination of significance if chi square is 4.62 and critical value is 5.991

Not statistically significant

500

ToolPak option used for a basic ANOVA model in Excel

ANOVA: single factor

500

Strength and direction of relationship with a correlation coefficient of -0.67

Moderate to strong negative relationship
500

Variable that goes into the "Input Y Range" in Excel regression model

Dependent variable

M
e
n
u