comparing many cols of data to one col
I have many sets of percentages (can over 20) for six month periods that I
analyzed. When I get a new set of percentages, I want to compare it to the
old sets and see which old set it is most similar to. I have been doing this
by lines graph but is there an easier way because I have alot of old sets.
See below
MON DATA 1 DATA 2 DATA 3 €¦DATA 20 NEW DATA
6 7.16% 5.94% 11.89% 8.08%
5 11.86% 7.52% 11.36% 11.56%
4 20.15% 13.27% 14.91% 25.01%
3 25.89% 23.25% 21.03% 26.73%
2 6.59% 24.01% 8.70% 13.41%
1 28.34% 26.03% 32.12% 15.21%
|