Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Convert likert scale numbers to percentages
201 views
Skip to first unread message
Frank Kabel
Feb 3, 2004, 5:48:07 PM2/3/04
to
Hi
try
=1-((A1-1)/4)
where A1 stores your scale number. Format the resulting cell as
percentage
Frank
try
=1-((A1-1)/4)
where A1 stores your scale number. Format the resulting cell as
percentage
Frank
BW@Intuit wrote:
> Is there a formula that will convert my likert scale numbers to
> percentages? For example, 1=100%, 2=75%, 3=50%, 4=25%, and 5=0%. So,
> if I have a 2.5, what % is that?
0 new messages