Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel graph 3 sets of data. 2 sets as lines 1 as column? | Charts and Charting in Excel | |||
show 3 sets of data per data point in a scatter plot | Charts and Charting in Excel | |||
How to determine the optimized correlation between 2 sets of data? | Excel Discussion (Misc queries) | |||
Correlation of data | Excel Discussion (Misc queries) | |||
How do i find a correlation between 2 data point or sets? | Excel Worksheet Functions |