ExcelBanter - Correlation formula/function question.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Correlation formula/function question. (https://www.excelbanter.com/excel-worksheet-functions/98103-correlation-formula-function-question.html)

MarvInBoise

Correlation formula/function question.

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!
--
Marv Lusk
Boise Corporation

Tom Hutchins

Correlation formula/function question.

See the Excel help for the CORREL function.

Hutch

"MarvInBoise" wrote:

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!
--
Marv Lusk
Boise Corporation

All times are GMT +1. The time now is 02:12 PM.