how do I recode a likert scale

G

Guest

how do I recode the negatively coded questions on a likert scale?

where 0=4, 1=3, 3=1, 4=0
 
T

Tushar Mehta

Use the formula =4-{cell containing original number}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a likert scale in excel 2
How can I display text and #s in a drop-down list, but insert only 4
How to get drop-down list to display text and #s but insert only # 1
recode variable 1
Not sure if Excel can do what i need 2
Convert likert scale numbers to percentages 2
How do I set-up a likert scale in Access? 2
Sliding scale for Mark Up 0

Top