Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down on April 23, and its replacement, **statalist.org** is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
Vicki Livingstone <livingstonevicki@yahoo.co.uk> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: tabout for multiple likert-scale questions |

Date |
Mon, 27 Sep 2010 11:09:19 +0000 (GMT) |

Hi Eric, Many thanks for that - It works perfectly once none of the questions have a category where the frequency is zero. Suppose that there were only two questions and the data was as follows: Q1 Q2 1 2 2 5 4 1 1 1 5 1 3 3 When you run the syntax, you get the following output: question 1 1 2 2 3 3 4 4 5 5 Total Total Frequency Percent Frequency Percent Frequency Percent Frequency Percent Frequency Percent Frequency Percent Q1 2 33% 1 17% 1 17% 1 17% 1 17% 6 100% Q2 3 50% 1 17% 1 17% 1 17% 6 100% Is there a way to include categories with zero observed frequency using tabout? Thanks again, Vicki ----- Original Message ---- From: Eric Booth <ebooth@ppri.tamu.edu> To: "<statalist@hsphsun2.harvard.edu>" <statalist@hsphsun2.harvard.edu> Sent: Sat, 25 September, 2010 18:21:29 Subject: Re: st: tabout for multiple likert-scale questions <> **************************! clear set obs 200 forval n = 1/5 { g Q`n' = 1+int((7-1+1)*runiform()) } gen question="Q1" **Q1** tabout question Q1 using table1.xls, replace cell(freq row) format(0c 0p) /// clab(Frequency Percent) ptotal(none) h1(| Likert Scale Questions) drop question **Q2 - Q5** forval n = 2/5 { preserve keep Q`n' gen question="Q`n'" tabout question Q`n' using table1.xls, append cell(freq row) format(0c 0p) /// ptotal(none) h1(nil) h2(nil) h3(nil) restore } **************************! - Eric __ Eric A. Booth Public Policy Research Institute Texas A&M University ebooth@ppri.tamu.edu Office: +979.845.6754 On Sep 25, 2010, at 3:19 AM, Vicki Livingstone wrote: > Hi all, > > I am running descriptives for a questionnaire that has many questions measured > on the same Likert scale. What I would like to output is a table where > the rows correspond to each question and the columns are the n(%) for > each category of response within the question. > > Using the following commands, I can output the results for an individual > question. > gen new=1 > tabout new Q1 using table1.xls, replace cell(freq row) format(0 0) > clab(Frequency Percent) > > Is there a way of including all Likert questions in the output? > > Many thanks in advance, > Vicki Livingstone > > > > > > * > * 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/ * * 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/

**Follow-Ups**:**Re: st: tabout for multiple likert-scale questions***From:*Eric Booth <ebooth@ppri.tamu.edu>

- Prev by Date:
**Re: st: compare effect size between dummys and metrics variables in logistic regression** - Next by Date:
**st: Marginal effects after heckman** - Previous by thread:
**Re: st: tabout for multiple likert-scale questions** - Next by thread:
**Re: st: tabout for multiple likert-scale questions** - Index(es):