By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,378 Members | 1,373 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,378 IT Pros & Developers. It's quick & easy.

How to set certain value into field?

P: 93

If I have one field name q4 and I want to calculate the likert scale value like below , I need to set the value to number first for further statistic calculation.
How do I set say agree ->4, mid -> 3, Totally Agree->5 etc? and create a new column of the number value side by side?

Totally Agree
Totally Agree
agree 1

Thanks a mills for the helps

Jun 13 '08 #1
Share this Question
Share on Google+
3 Replies

Expert 2.5K+
P: 2,878
You might consider just creating a lookup/reference table for this one and just use JOIN.

-- CK
Jun 13 '08 #2

Expert 100+
P: 145
It might be worth your while to design a table that has both a value and text label for your likert values if your responses are not stored somewhere else in your DB.

Expand|Select|Wrap|Line Numbers
  1. Scale          Label                                       Total
  2. 1                 Strongly disagree                      12
  3. 2                 Disagree                                   38
  4. 3                 Neither agree nor disagree          77
  5. 4                 Agree                                       24
  6. 5                 Strongly agree                          18

If your responses are recorded somewhere in your DB, you can use a table like the one below to look up your likert values from a SELECT COUNT(*) WHERE query.

Expand|Select|Wrap|Line Numbers
  1. Scale          Label                                      
  2. 1                 Strongly disagree                    
  3. 2                 Disagree                                 
  4. 3                 Neither agree nor disagree        
  5. 4                 Agree                                      
  6. 5                 Strongly agree
Jun 16 '08 #3

P: 93
thanks a mills for giving me the ideas

it works now
Jun 17 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.