View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SK08 SK08 is offline
external usenet poster
 
Posts: 15
Default correlation between two data sets

The answers I've found in similar posts haven't worked for mine.

Basically I have historical prices of coal and electricity and want to
determine how they correlate to each other, comparing the two
different prices on the same date.

In col C is the difference in price between days 1 and 2 for coal. In
col G is the difference in price between days 1 and 2 for
electricity.

So for each date, I want to find how the values in Col C and Col G
Correlate to each other.

Thank you !