Likert Scoring Help

[nhbartos]

Hi folks...

I have a simple evaluation.

4. Strongly Agree
3. Agree
2. Disagree
1. Strongly Disagree

Example:
I have 10 evaluations with each evaluation having 14 questions and 140 total potential selections.
The totals of my counts come to:

4. 100
3. 20
2. 10
1. 10

How can I crunch these so that my score works out to be in a decimal format like: 3.5

I initially averaged them and provided a percentage, but I was asked to come up with the 3.5 alternative as opposed to a percentage.

Make any sense?

 

[shg]

Since Likert scales are supposed to be symmetric and equally spaced about neutral, I'd do it like this:

Row\Col	A​	B​	C​	D​	E​	F​	G​
1​		Strongly Disagree​	Disagree​	Agree​	Strongly Agree​
2​	Weight​	-3​	-1​	1​	3​	Average​
3​	Count​	10​	10​	20​	100​	2​	F3: =SUMPRODUCT(B3:E3, B$2:E$2)/SUM(B3:E3)

If you want it your way,

Row\Col	A​	B​	C​	D​	E​	F​	G​
1​		Strongly Disagree​	Disagree​	Agree​	Strongly Agree​
2​	Weight​	1​	2​	3​	4​	Average​
3​	Count​	10​	10​	20​	100​	3.5​	F3: =SUMPRODUCT(B3:E3, B$2:E$2)/SUM(B3:E3)

 

[AhoyNC]

You may find this link of interest.
http://poincare.matf.bg.ac.rs/~kristina/topic-dane-likert.pdf