
Advanced Statistics Advanced Probability and Statistics Math Forum 
 LinkBack  Thread Tools  Display Modes 
March 30th, 2009, 01:23 PM  #1 
Newbie Joined: Mar 2009 Posts: 1 Thanks: 0  curve (data) similarity  load curve
Hi, I have to compare different load curves (electricity), eg. curves 220 with a curve 1. Every curve is represented as array of 24 values (hourly values), with no discontinuity (all values are above 0). I have to find which curve 220 is most similar to curve 1. I'm using Excel, but other tools are in as well (Matlab, Mathematica, pen & paper). As you can see, my knowledge of math is very limited. I've found two functions in Excel, CORREL (correlation ratio, I presume it is linear correlation ratio) and COVAR. I also tried my formula which is =ABS((B2C2)*(B3C3)*(B4C4)...(B25C25)), that is Product(xiyi), Vi<n Please tell me which is best formula to determine shape similarity (from my point of view, CORREL seems the best) and why. Also, if it isn't the same formula, which formula would be best to determine similarity overall (two curves of same shape don't have to overlap, e.g. if they same relative distance between all of the 24 values)? Thanks in advance, Marin 

Tags 
curve, data, load, similarity 
Search tags for this page 
Click on a term to search for related topics.

Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Similarity of time series data  Challenger85  Real Analysis  0  September 29th, 2013 11:11 PM 
Length of the Curve  pjlloyd100  Calculus  1  February 11th, 2013 11:14 PM 
What curve is this?  mboricgs  Algebra  8  May 26th, 2012 01:53 AM 
Egg Curve  clandarkfire  Algebra  2  November 22nd, 2011 05:27 PM 
Length of a curve  snopy  Calculus  2  January 7th, 2011 08:22 AM 