View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MarvInBoise MarvInBoise is offline
external usenet poster
 
Posts: 39
Default 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