Calculate Likert 5 scale average

[Dominik Rinderer]

Hallo,

I am very new to Stata and using it for my master thesis.

In my discrete choice experiment I used 11 questions to collect the opinion of the participants regarding two topic ones wine (5 questions) and sustainability (6 questions).
I already transformed the answers into values from 1-5.
Now my question is how could I sum up the indiviual values per question in order to receive the total score per topic for each participant? I want to know where in the range of 5-25 or 6-30 each participant is?
My second question how I could divide this score by the number of questions, to get for both topics a final score between 1 and 5.

Thanks in advance.

[wbuchanan]

I would suggest looking at either -gsem-, -irt pcm-, or -irt grm- instead of doing what you currently have planned. See https://ojs.library.carleton.ca/inde...view/1613/1456 for additional information regarding Likert scaling/scoring and the assumptions, which are never tenable, that must be satisfied for the procedure you would like to use to yield valid results.

[Dominik Rinderer]

Thanks for your help
Sorry, I don't know what to do with this commands..

I copied 3 participants to excel to show you what i want to do. I am not sure if it is important but I converted my data to the long format. And i have these likert scale answers 24 times per participant

Var	winei1	winei2	winei3	winei4	winei5	Sum	Mean	envi1	envi2	envi3	envi4	envi5	envi6	Sum	Mean
ID1	1	1	1	1	1	5	1	4	1	2	2	1	3	13	2,1666667
ID2	4	5	5	4	3	21	4,2	3	1	2	1	1	3	11	1,8333333
ID3	2	3	2	1	3	11	2,2	3	1	3	4	2	2	15	2,5

[Dominik Rinderer]

I got it, thanks.
I used: gen total = var1 + var2 +...