Hi,
I have to compare different sets of values (continuos curves), each curve is a range of 24 values (hours in a day). Eg. A is in range B2:B25, curve B in C2:C25, C in D2:D25. What formula can be used to determine which curve is most similar to curve A (either by shape and by overall)?
So far I tried:
a) CORREL
b) COVAR
c) =ABS((B2-C2)*(B3-C3)*(B4-C4)...(B25-C25))
I'm using a) for the similarity by shape and c) for similarity by both shape and value but something tells me there is a batter solution (than my lousy math).
Thank you in advance,
Marin
ps: Excel is MS Excel 2007
I have to compare different sets of values (continuos curves), each curve is a range of 24 values (hours in a day). Eg. A is in range B2:B25, curve B in C2:C25, C in D2:D25. What formula can be used to determine which curve is most similar to curve A (either by shape and by overall)?
So far I tried:
a) CORREL
b) COVAR
c) =ABS((B2-C2)*(B3-C3)*(B4-C4)...(B25-C25))
I'm using a) for the similarity by shape and c) for similarity by both shape and value but something tells me there is a batter solution (than my lousy math).
Thank you in advance,
Marin
ps: Excel is MS Excel 2007
