• Survey results help (2000)

    Author
    Topic
    #446662

    I have the results from an Service Importance survey I did. We surveyed end users and we did a self assesment of what we think they would answer to see how well we know our customers.
    The scale was 1 to 5 1=Critical, 2 Very Important, 3=Important, 4=Somewhat Important, 5 = Not Important.
    I now have 2 tables of results with 10 questions(CustomerID, Customer, Q1~Q10).
    I’m trying to figure out the best way to compare the results.
    If we said a particular question was a 3(Important) but the end user said it was a 1(Critical), what’s the best way to depict this.
    Looking for ideas,
    Scott

    Viewing 0 reply threads
    Author
    Replies
    • #1086722

      You could create a query based on the two tables joined on CustomerID.
      Add CustomerID from one of the tables to the table grid.
      Create a calculated column for each question, for example for Q1:

      Diff1: [Table1].[Q1]-[Table2].[Q1]

      and similar for the others. These columns will describe the difference between the customer’s answers and your’s – 0 means you gave the same answer, non-0 means that the answers were different, and the sign of the difference indicates who judged the item to be more important.

      If you want a more thorough analysis, import the data into a statistics program such as SPSS or SAS and use the many methods they provide to compare sets of data.

      • #1086725

        Hans,
        That makes some sense. I’ll see what it looks like.
        Thanks,
        Scott

    Viewing 0 reply threads
    Reply To: Survey results help (2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: