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

 From Philip Jones To statalist@hsphsun2.harvard.edu Subject st: AW: How to plot frequencies of Likert scale over two groups (data shaping question) Date Thu, 12 Nov 2009 16:30:20 -0500

```They are just examples. They could have just as easily been 36 and 22.

My issue seems to be one of trying to avoid re-entering data that I have in Stata in one form (long, non-counted) to another form, as found below, where the counts of each of the Likert levels of each of the two groups are input as one number that can then be (trivially) graphed. I can't seem to figure out how to tell Stata to do that.

Thanks for responding,

Phil

> <>
>
> 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,

*
*   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/
```