1 Reply Latest reply on Sep 30, 2018 11:34 AM by Don Wise

    The best way to see a correlation

    Cosmin Costeab

      Hello guys,

       

      I am fairly new to Tableau and I need some help to visualize a correlation.

      Very briefly:

      1. We give a test to 40 subjects to test some knowledge. The answers were noted from a range from 1 to 5

      2. After a while, we had interviews with the same subjects testing the same knowledge with very similar questions. The notation was done with a scale from 1 to 9

      3. There is a correlation between the two meaning that usually the guys who obtained big scores to the first test obtained high scores in interviews

       

      Now we want to create a graph in order to see the correlations.

      What we have is something like this:

      Student 1  Test1  Interview1

      Name          5         9

      Name2        3         4

      Name3        4         6

       

      Thank you

        • 1. Re: The best way to see a correlation
          Don Wise

          Hello Cosmin,

          There are multiple methods.  You'l know which is best simply by trying some of the chart options.  Below are three graphs which help with the process. But without real/sample data, it's difficult to tell what will be meaningful for your needs.  For example, if more data were supplied, you could also use the Analytics Tools and the Clustering option. 

           

          If this response answers your question, please mark it as correct so that others may find it useful in the future. Thx, Don

           

          Screen Shot 2018-09-30 at 11.30.26 AM.png

          Screen Shot 2018-09-30 at 11.30.32 AM.png

          Screen Shot 2018-09-30 at 11.30.42 AM.png