# st: AW: How to plot frequencies of Likert scale over two groups (data shaping question)

 From "Martin Weiss" To Subject st: AW: How to plot frequencies of Likert scale over two groups (data shaping question) Date Thu, 12 Nov 2009 15:28:24 +0100

```<>

Is there a connection between the upper and lower example? Where do "24" and
"26" come from, for instance?

HTH
Martin

-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Philip Jones
Gesendet: Donnerstag, 12. November 2009 15:17
An: statalist@hsphsun2.harvard.edu
Betreff: st: How to plot frequencies of Likert scale over two groups (data
shaping question)

After substantial frustration at my inability to simply perform this task in
Stata, I am asking this group for help!

I know that it will be easy to answer, but I am unable to come up with the
correct way of shaping my data for the following need of graphing.

I have a Likert scale (1 to 5) that two groups of people answered. I would
like to create a bar graph with the x axis labelled 1, 2, 3, 4, 5 for each
Likert level. I would then simply like to plot frequencies of responses as
the bars, so that each level of the Likert scale would have one for each
group (i.e. two bars of frequencies for each of 1, 2, 3, 4, 5).

My attempt (which creates the look of the graph that I want):

clear *
input ease_level group1 group2
1 24 26
2 13 15
3 12 12
4 8 6
5 1 6
end

graph bar (asis) group1 group2, over(ease)

This works well, except my data are not in this format. Rather, they are in
the following format:

clear *
input group ease
1 1
1 1
1 2
1 3
1 5
2 1
2 2
2 3
2 4
2 5
end

I have searched the re-shaping commands, but cannot successfully convert my
data to this format.

Any help would be greatly appreciated! Thank you,

Phil Jones
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```