Excel Downloads: Linear Correlation & Regression
The following Excel worksheets will perform the same analysis as is performed by the on-line page on this site entitled "Linear Correlation and Regression." However, the Excel sheets can comfortably handle sample sizes up to N=1000, and they will also draw a scatter plot along with the regression line. ~~ Both worksheets include Visual Basic macros. As they open within Microsoft Excel, you will need to click the option labeled "Enable Macros."
Download for Macintosh (188K)
Download for Windows (164K)
[If you are downloading the windows version, select the option "Save it to disk," then open the file from wherever you have saved it. The original name of this file is "corrWin.xls."]