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 ! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
correlation between two data sets
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. -- If this helps, please click the Yes button Cheers, Shane Devenshire "SK08" wrote: 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 ! |
Reply |
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 |