Hi,(adsbygoogle = window.adsbygoogle || []).push({});

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 relativedistance between all of the 24 values)?

Thanks to you all

**Physics Forums | Science Articles, Homework Help, Discussion**

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Q: Load curves: similarity check-up

Can you offer guidance or do you also need help?

Draft saved
Draft deleted

Loading...

Similar Threads for Load curves similarity |
---|

A PDF of random motion - similar to Browninan motion |

**Physics Forums | Science Articles, Homework Help, Discussion**