Likert-scale

**molly78** · 01-22-2005, 06:48 PM

Hello everyone,

I have a problem that I couldnt figure out.

For example, the values (5- Likert scale) I have in the first column:

strongly agree
agree
undecided
disagree
strongly disagree
disagree
disagree
agree
undecided
agree
.
.
.
.
.
etc.

And each value has a rep. number.

strongly agree=1
agree=2
undecided=3
disagree=4
strongly disagree=5

What I want to do is, for example

if the first cell is "agree", in the next colum it should be seen as "2";

in the second cell, if the value is "strongly disagree", it should be "5".

Is there a formula to do this? I really appreciate any help.

Molly.

**duane** · 01-22-2005, 07:10 PM

set up a table like this somewhere - maybe on sheet 2 cells a1:b5

strongly agree 1
agree 2
undecided 3
disagree 4
strongly disagree 5

assuming your orginal column of responses is column a (starting in a1)
in cell b1 put the following

=vlookup(a1, sheet2!$a$1:$b$5,2,false)

and copy down column b

**molly78** · 01-22-2005, 07:48 PM

It still does't work, probably iam still doing something wrong.

Thanks for your reply tho.

**duane** · 01-22-2005, 07:52 PM

it should work fine....note there are no spaces in the vlookup function....what error are you getting?

**molly78** · 01-22-2005, 07:59 PM

i took a snapshot, maybe you can see better what I am doing wrong

thanks

**duane** · 01-22-2005, 08:01 PM

I am sorry but I won't open an unknown file...if you can describe how your sheet is laid out - you can copy formulas out of excel and past to this forum.

**molly78** · 01-22-2005, 08:06 PM

Oh sorry.

Well, like you suggested, I opened sheet 2.
I put the data from A1 to A5

strongly agree
agree
undecided
disagree
strongly disagree

B1 to B5

1
2
3
4
5

I clicked on B1 cell

Copy/pasted =vlookup(a1, sheet2!$a$1:$b$5,2,false) into B1

hit the enter, then it gives notice saying that The formula you typed contains an error.

**AlfD** · 01-22-2005, 08:24 PM

Hi!

Nothing wrong with the formula.

Which B1 did you put the formula in? It needs to be on sheet1.

Alf

**duane** · 01-22-2005, 08:24 PM

=vlookup(a1,sheet2!$a$1:$b$5,2,false)

note I removed a space

I am also assuming this formula is placed on some sheet other than sheet2

**molly78** · 01-22-2005, 08:39 PM

in sheet 1, I have the data of the respondents (A1 to A50)

Sheet 1

A B
1 strongly agree =vlookup(a1,sheet2!$a$1:$b$5,2,false)
2 undecided
3 agree
4 disagree
5 agree
6 strongly agree
.
.
.
.
50

when I enter the formula, it says formula contains en error (still)
---------------------------------

Sheet 2

A B

1 Strongly agree 1
2 Agree 2
3 Undecided 3
4 Disagree 4
5 Strongly disagree 5

Edit: now I look what I posted, the text looks a bit weird. I tried to make what I see on excel.

**AlfD** · 01-22-2005, 08:44 PM

Hi!

Swap your columns A and B on sheet 1.

(If you look back, that's the way Duane suggested it eons ago...)

Alf

**molly78** · 01-22-2005, 09:01 PM

I am sorry ... it still doesnt work

Maybe one of you can take a screenshot and send it to me.
if it is possible that is.

Sorry for the headache I am giving.

**AlfD** · 01-22-2005, 09:07 PM

Hi!

Send me a snippet to adsort-forum@yahoo.co.uk.

Alf

**molly78** · 01-22-2005, 09:24 PM

Sent.

Thanks for your help again.

**stkarthik** · 08-11-2014, 03:54 AM

I had a similar issue , then i improvised the a bar chart to look like a likert scale
download.png
here is step by step guide link

Likert-scale

LinkBack

Thread Tools

Rate This Thread

Display

Likert-scale

Re: Likert-scale

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions