Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Survey results help (2000)

    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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Survey results help (2000)

    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: <!t>[Table1].[Q1]-<!t>[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.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Survey results help (2000)

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •