Tags: applicable, calculation, excel, following, frequency, item1, likert, microsoft, mins, msdn, scale, secs, software, survey, table

Likert scale calculation

On Microsoft » Microsoft Excel

1,730 words with 1 Comments; publish: Thu, 22 May 2008 07:14:00 GMT; (306281.25, « »)

I have used the following table in my survey:

Frequency of use - check which on is applicable:

every few hours every few

mins every few secs

item1

item2

item3

.

.

.

item10

so the sample data looks like this:

id item1 item 2 .......... item10

1 hours hrs ............. mins

2 secs hrs ............. mins

3 mins hrs ............. mins

I want to add up the hours secs mins for each item..for example (from

the above sample):

every few hours every few

mins every few secs

item1 1

1 1

item2 3

0 0

...

.

.

item10 0

3 0

How can I do this using pivot tables?

Since I would later on like to see the break-up based on demographics

etc.

Thanks,

Oliver

All Comments

Leave a comment...

  • 1 Comments
    • uff the formatting was messed up - here it goes again

      > I have used the following table in my survey:

      > Frequency of use - check which on is applicable:

      > every few hours every few mins every few secs

      > item1

      > item2

      > item3

      > .

      > .

      > .

      > item10

      > so the sample data looks like this:

      > id item1 item 2 .......... item10

      > 1 hours hrs ............. mins

      > 2 secs hrs ............. mins

      > 3 mins hrs ............. mins

      > I want to add up the hours secs mins for each item..for example (from

      > the above sample):

      > every few hours every few mins every few secs

      > item1 1 1 1

      > item2 3 0 0

      > ...

      > .

      > .

      > item10 0 3 0

      > How can I do this using pivot tables?

      > Since I would later on like to see the break-up based on demographics

      > etc.

      > Thanks,

      > Oliver

      #1; Thu, 22 May 2008 07:15:00 GMT