My Math Forum  

Go Back   My Math Forum > College Math Forum > Advanced Statistics

Advanced Statistics Advanced Probability and Statistics Math Forum

LinkBack Thread Tools Display Modes
March 30th, 2009, 01:23 PM   #1
Joined: Mar 2009

Posts: 1
Thanks: 0

curve (data) similarity - load curve

I have to compare different load curves (electricity), eg. curves 2-20 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
2-20 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((B2-C2)*(B3-C3)*(B4-C4)...(B25-C25)), that is |Product(xi-yi)|, 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 is offline  

  My Math Forum > College Math Forum > Advanced Statistics

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

Copyright © 2019 My Math Forum. All rights reserved.