I have very basic knowledge of Access and need to compute the Correlation coefficient between two sets of data. How can I do this in a query or using the build it function? Please help!
Novice
Windows 7 64bit 
Access 2010 64bit
I have very basic knowledge of Access and need to compute the Correlation coefficient between two sets of data. How can I do this in a query or using the build it function? Please help!
VIP
Windows XP Access 2010 32bit
Show sample data and formula.
Don't know how many of us here are experienced statisticians. I, for one, have no idea what a correlation coefficient is. Not even after Googling the topic.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 7 64bit Access 2000
Correlation Coefficients usually don't change much once you've accumulated a good amount of data, so I'm guessing this is a one-time shot? If so, there are a number of websites that have a tool to compute this simply by pasting your columns of data.
Moderator
Windows XP Access 2003
Posting Permissions
Reply With Quote