This preview shows pages 1–2. Sign up to view the full content.
Correlation and simple regression in Excel
Correlations
Excel functions for covariance and correlation
The Excel worksheet functions are COVAR and CORREL, respectively.
They each take
two arguments: the array containing the first variable and the array containing the second
variable.
If you have a bunch of variables, then you may want to use functions within the analysis
toolpak to calculate all the covariances and correlations simultaneously.
First, rearrange
your data so that all the columns of numeric data are next to each other.
Then go to Tools
→ Data Analysis and pick Covariance or Correlation, as appropriate.
Select the input
range to include the data and the data labels, if you have them – don’t forget to check
“Labels in first row.”
Select the output range and hit OK.
Below is the example for the
data in Chlorophyll.csv:
The output is a table (see below for an example), where the entry in each cell is the
covariance (or correlation) between the variable heading that column and the variable
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview. Sign up
to
access the rest of the document.
 Spring '08
 KENDALL,BERKLEY
 Environmental Science

Click to edit the document details