I want to see the closest match for a group of number sets to a particular set.
Set A [.2, .5632, -1.235, -.0655,....]
setArray(0[1.235, 3.32, .32, -.6....], 1[.256, .23, -.56, ......])
I want to see which set in the array is the closest match to Set A.
I looked it up on web search, and I found Student T-Test but got lost on the math. It said to take p-value, etc and calculates it on a calculator. I need each step so I can use it in a spreadsheet.
Can someone show me how I do this comparative study, in simple math. I am zero in math and the sigma, alpha signs I can't understand.
Thanks you for you time!
Edit;
What I am trying to do is find the closest stock beta to an index. I am taking the daily closePrice/previousClose -1 for Index and some stocks. I want to see over a period of time which stock moves most closely to the Index.