correlation between two data sets

  • Thread starter Thread starter SK08
  • Start date Start date
S

SK08

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 !
 
Hi,

One way would be to graph the two series against the dates.

The CORREL function which calculates the correlation between two sets of
data is another option but you wouldn't use it against 2 data points.
 

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

multiple correlations with one click? 6
Excluding Cells From Avg Cals Due to Info in different col 6
Correlation formula/function question. 1
Calculating from mutual share prices the correlation coeffiient of returns 5
I know this is obvious but .. 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
compare and return a value from another worksheet 3
Trying to match 1 value to multiple columns 10

Back
Top