Correlation formula/function question.

G

Guest

Can excel create a correlation formula? For instance, let's say I have 2
trend lines on price over time. I want to see if there is some correlation
between the 2. If price one moves $1, then you can expect price 2 to move $x
amount. Is there an excel function that will find that correlation?

Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function to Move Correl over one column at a time 7
CORREL formula with criteria 2
Correlation Matrix 5
How to determine the optimized correlation between 2 sets of data? 1
Automating Calculation of Lagged Cross Correlations between Variables 1
Calculating from mutual share prices the correlation coeffiient of returns 5
Using range names in functions 2
easy correlation computations with lags 1

Top