*Using the Correlate Function*

The CORRELATE
function in EZAnalyze allows you to see how two or more variables are
related to each other. A *correlation coefficient *(glossary),
simply put, is a number between -1 and +1 that describes the direction
and degree of relationship between two variables. The direction of the
relationship is indicated by the sign (positive or negative, + or -),
while the degree of the relationship is indicated by the number itself,
which is usually a decimal between 0 and 1. The higher the number, the
stronger the relationship is between two variables - 0 would indicate
that there is no relationship, while 1 would indicate that there is a
perfect relationship. For example, if you obtained a correlation coefficient
of .41 between the number of years of schooling and gross income, that
would indicate that there was a positive relationship between the number
years of schooling and gross income. Alternatively, if the correlation
coefficient was -.41, that would indicate that there was a negative relationship.
For more information on interpreting correlation coefficients, see the
associated help file topic HERE for interpreting
CORRELATE results reports.

To obtain correlation coefficients with your data, select "Advanced" from the EZAnalyze menu in Excel, and then choose "Correlation".

When the "Correlate" dialogue box appears, you will be presented with two lists of the variables in your data sheet.

OPTIONS:

**Correlate two variables and create a scatterplot**- Choose this option if you would like to obtain a single correlation coefficient which displays a graph of the results in addition to the coefficient and related statistics. Select the variables you would like to correlate from the 'Variable 1' and 'Variable 2' lists.- Show trendline on scatterplot - select this if you would like a 'line of best fit' displayed on the graph

**Correlate more than two variables to create a correlation matrix**- Choose this option if you want to conduct all possible correlations between two or more variables. Select your variables from the list provided.

A NOTE ON SELECTING VARIABLES. While EZAnalyze will let you choose any two numeric variables to correlate, variables that are categorical, such as gender, ethnicity, or learning disability status, are not appropriate to conduct correlation analyses with in EZAnalyze. Examples of common correlations of interest to educators are the number of days absent with GPA, standardized test scores and GPA, and the number of disciplinary referrals with standardized test scores.

When
you click OK, a results report will be printed
on a separate sheet for your review. *(click on "results report" for
information on how to interpret this analysis)*