How do you find correlation coefficients in Excel?

Article View: comp.apps.spreadsheets

Article #283

Back to comp.apps.spreadsheets Previous Next

#283

From: jaewon kwak
Date: Sat, 21 Nov 1992 22:10

15 lines
1010 bytes

Well, the question is in the subject.  How DO you find
the correlation coefficient of data points in excel or
is the spreadsheet's statistical capabilities limited
to just standard deviation and mean?  

Also, is there a way to find roe?  Roe is the covariance
divided by the product of the standard deviations (I think).

These statistical functions are needed to correlate
the returns for a serious of data points collected from
the Wall St. Journal.

Thank you in advance for any help you can give me.

Jae

Technical Details

Message-ID: <102789@bu.edu>

Path:

arc1-ca.pugleaf.net!sparky!uunet!spool.mu.edu!nigel.msen.com!sdd.hp.com!zaphod.mps.ohio-state.edu!sol.ctr.columbia.edu!destroyer!cs.ubc.ca!uw-beaver!micro-heart-of-gold.mit.edu!bu.edu!acs.bu.edu!danger

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!sparky!uunet!spool.mu.edu!nigel.msen.com!sdd.hp.com!zaphod.mps.ohio-state.edu!sol.ctr.columbia.edu!destroyer!cs.ubc.ca!uw-beaver!micro-heart-of-gold.mit.edu!bu.edu!acs.bu.edu!danger
From: danger@acs.bu.edu (jaewon kwak)
Newsgroups: comp.apps.spreadsheets
Subject: How do you find correlation coefficients in Excel?
Keywords: Excel
Message-ID: <102789@bu.edu>
Date: 21 Nov 92 22:10:15 GMT
Sender: news@bu.edu
Organization: Boston University, Boston, MA, USA
Lines: 16