Correlation and simple regression in Excel

Correlation and simple regression in Excel - Correlation...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
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
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

Correlation and simple regression in Excel - Correlation...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online