ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I recode a likert scale (https://www.excelbanter.com/excel-discussion-misc-queries/47121-how-do-i-recode-likert-scale.html)

merlin

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

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




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

In article ,
says...
how do I recode the negatively coded questions on a likert scale?

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





merlin

Thank you Tushar :)

"merlin" wrote:

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

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




Tushar Mehta

You are welcome.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Thank you Tushar :)

{snip}


All times are GMT +1. The time now is 12:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com