none
Correlation matrix?

    Question

  • Hello everybody;

     

    One of my friend showed me a correlation matrix rendered from STATISTICA. This matrix represents correlations between the questions of an exam that has 24 questions. Teacher asked them to discover the relationships between each question that both answered true or false.. Can we make a graph or something like that in AS?

     

    Here is the screenshot extracted from Word.

    http://www.imageturk.com/goster.php?res=1ee9826a924e7c51a44er.jpg
    Tuesday, January 29, 2008 3:07 PM

Answers

All replies

  • You can get the correlation matrix by using a server side stored procedure. An example is available here (computing both correlation and covariance matrix)

    http://www.sqlserverdatamining.com/ssdm/Default.aspx?tabid=102&Id=12

    Tuesday, January 29, 2008 5:52 PM
  •  

    Well, thanks Mr. Crivat. It's a really good advise. But before appliying it, i wonder something. It says that correlation matrix for continious attributes. In my case there is an association rules model and have two tables. I've listed the student's true questions like (Q1,Q2,Q6,Q11 etc) in the second table. Domain is [Q1...Q24]. Those columns are all text variables not continuous. I need a matrix from Q1 to Q24 in both rows and columns and relationships between them as in the jpg file above. Does this strored proc work for my purpose?
    Thursday, January 31, 2008 11:32 AM