2 Replies Latest reply on Apr 17, 2018 7:30 AM by nicole castanon

    Help with scatterplot of 10 attributes

    nicole castanon

      Hi!  I am trying to get 10 attributes plotted on a scale where the x axis is rating and the y axis is importance.  Right now each attribute is in 2 columns - this is because the survey question data has a column for each attribute and tracks the responses within on a 1 to 10 scale.  For the life of me, I cannot figure out how to get the average rating and average importance for each lined up so that I can plot them as 1 point for each attribute.  Raw data file example attached. 

       

      If I can get step 1 = plot each attribute as 1 point where the x value is rating and the y value is importance - the next would be to have different colors or something for each quarter to see where they moved from vs. the previous quarter.  Definitely a lower priority though.

       

      THANK YOU!!