Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Performing Statistical analysis (kolmogorov smirnov test/related) using R or Matlab or Excel

Avatar of haravallabhan
haravallabhanFlag for India asked on
Programming Languages-OtherMath / ScienceProgramming Theory
7 Comments1 Solution3007 ViewsLast Modified:
I have two excel files one containing
a set of values of a markers with their positions (MARKERID-KS.xls) and
another with a set of values of regions with their positions on a map (MAPID-KS.xls), along with their color intensity.
Please see the attached excel files.

I want to do a statistical test to this to determine if the relationship of the distributions of these two datasets are significant or not ie Marker to Map(this in relation to the color intensity as given in the map). I want to do a Kolmogorov smirnov test, KS-Test (or please advice me if there is any other test that I need could use) on this sample to determine the D Value and to find if there is significance between the two datasets. Can someone here please advice me on to how I can perfom this. If, there a straight forward way to perform this test with the data test using R or Matlab (I havent used Matlab but could try).

Thanks

Cheers

Sample of the data
DATA1 : MARKERID
MarkerID      Marker      Beginposition      EndPosition
MARK1      IC      6135      6046
MARK2      IC      22428      22440
MARK3      IC      23665      23684
MARK4      IC      30394      30402
MARK5      IC      30961      30964
MARK6      IC      33439      33455
MARK7      IC      36905      36906
MARK8      IC      42219      42234


DATA2:MAPID
MAPID      REGION      BEGIN      END      COLOR INTENSITY
COLID1      IC      60639      63226      5.89
COLID2      IC      42039      42259      5.47
COLID3      IC      42626      43386      5.2
COLID4      IC      63200      63369      4.52
COLID5      IC      30699      32083      3.97
COLID6      IC      66360      66555      3.9

MARKERID-KS.xls
MAPID-KS.xls
ASKER CERTIFIED SOLUTION
Avatar of harfang
harfangFlag of Switzerland image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answers