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

    Converting Values (Access 2k)

    Don't know if this is an Appropriate place to ask but here goes.
    I have a survey where the answers for 8 questions range from 1 to 10.
    The survey has been around for a long time and it works great.
    Our company standard in Japan is a scale from 1 to 4.
    I'm looking for ideas on how to convert the 1 to 10 into 1 to 4 values
    and try to keep as close to the original relationship as possible.
    Thanks,
    Scott

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Converting Values (Access 2k)

    You haven't really provided enough detail to get any useful suggestions. I assume 1 through 10 represent a range of values, such as from Highly Satisfied to Highly Dissatisfied, right? Are you asking for help figuring out what the categories from 1 to 4 should be, how to adapt the existing survey to a different range of values, or what?
    Charlotte

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

    Re: Converting Values (Access 2k)

    Charlotte,
    I'm looking for a way to convert the existing survey results to a different range of values(1 to 4)
    The existing survey with the 1 to 10 values won't be changed since customers are familiar with it.
    Hope this helps explain what I want to do.
    Scott

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Converting Values (Access 2k)

    Are you trying to report on existing results in a different scale (ratio 2.5:1)? Is this for a report, a graph or what?
    Charlotte

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

    Re: Converting Values (Access 2k)

    Charlotte,
    The results are produced on a bar chart that has the values for 8 different questions.
    The results never go below a 5. (If they did the employee would probably be terminated)
    Scott

  6. #6
    Star Lounger
    Join Date
    Jun 2001
    Location
    Christchurch, New Zealand
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting Values (Access 2k)

    Hi,

    I've had to deal with this situation before... I just used a mapping table and then used this to group the results rather than the existing column. I made sure that all records defaulted to 0 in the first instance. Created the mapping table (example below) then join on the field in your data table to the ID filed in this table. Group on the descrip field and count the KeyID from your original table. The same theory applies to making age grouping etc..

    ID Descrip
    0 Non Response
    1 1
    2 1
    3 2
    4 2
    5 2
    6 3
    7 3
    8 3
    9 4
    10 4

    What you have to acknowledge is that you are changing the statistical signifigance of the outcome...4 doesn't go into 10 as such.

    Cheers
    Tony

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

    Re: Converting Values (Access 2k)

    You should consult a professional statistician for this. There are statistical methods of converting one response scale to another one with minimal loss of information.

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

    Re: Converting Values (Access 2k)

    Don't know if there is any interest but I brainstormed <img src=/S/argue.gif border=0 alt=argue width=50 height=25> with a co-worker and we came up with this.
    We divided 4 by 10 which is the highest value in both cases and got .4
    We then multiplied .4 by all the values in the 1 to 10 scale. This still gave us a linear scale that mirrors the original
    and keeps the same relationship.
    10---4
    9---3.6
    8---3.2
    7---2.8
    6---2.4
    5---2
    4---1.6
    3---1.2
    2---.8
    1---.4

Posting Permissions

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