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:

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][td]

G​

[/td][/tr][tr][td]

1​

[/td][td][/td][td]

Strongly Disagree​

[/td][td]

Disagree​

[/td][td]

Agree​

[/td][td]

Strongly Agree​

[/td][td][/td][td][/td][/tr]
[tr][td]

2​

[/td][td]

Weight​

[/td][td]

-3​

[/td][td]

-1​

[/td][td]

1​

[/td][td]

3​

[/td][td]

Average​

[/td][td][/td][/tr]
[tr][td]

3​

[/td][td]

Count​

[/td][td]

10​

[/td][td]

10​

[/td][td]

20​

[/td][td]

100​

[/td][td]

2​

[/td][td]F3: =SUMPRODUCT(B3:E3, B$2:E$2)/SUM(B3:E3)[/td][/tr]
[/table]

If you want it your way,

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][td]

G​

[/td][/tr][tr][td]

1​

[/td][td][/td][td]

Strongly Disagree​

[/td][td]

Disagree​

[/td][td]

Agree​

[/td][td]

Strongly Agree​

[/td][td][/td][td][/td][/tr]
[tr][td]

2​

[/td][td]

Weight​

[/td][td]

1​

[/td][td]

2​

[/td][td]

3​

[/td][td]

4​

[/td][td]

Average​

[/td][td][/td][/tr]
[tr][td]

3​

[/td][td]

Count​

[/td][td]

10​

[/td][td]

10​

[/td][td]

20​

[/td][td]

100​

[/td][td]

3.5​

[/td][td]F3: =SUMPRODUCT(B3:E3, B$2:E$2)/SUM(B3:E3)[/td][/tr]
[/table]

 

[AhoyNC]

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