How can I get descriptive statistics and the five number summary on one line?

How can I get descriptive statistics and the five number summary on one line?

One can obtain descriptive statistics and the five number summary on a single line by using a statistical software or tool that offers this feature. This allows for a quick and concise overview of the data, including measures such as the mean, median, mode, range, and quartiles. Additionally, this format makes it easier to compare and analyze multiple sets of data. By utilizing this method, individuals can efficiently obtain a comprehensive understanding of the data in a clear and organized manner.

How can I get descriptive statistics and the five number summary on one line? | Stata FAQ

Stata provides the summarize command
which allows you to see the mean and the standard deviation, but it does not provide the five number
summary (min, q25, median, q75, max).  You can use the detail
option, but then you get a page of output for every variable. If you
want to get the mean, standard deviation, and five number summary on one line, then you want
to get the univar command. The
univar command was written by John R. Gleason and appears in the
Stata
Technical Bulletin #51. You can download
univar from within Stata by typing search univar (see
How can I used the search command to search for programs and get additional
help? for more information about using search).

Let’s illustrate use of the
univar
command using the high school and beyond data file we use in our Stata Classes.

use https://stats.idre.ucla.edu/stat/stata/notes/hsb1, clear
(highschool and beyond (200 cases))

Here you see the output you get from summarize.

summarize read write math science socst

Variable |     Obs        Mean   Std. Dev.       Min        Max
---------+-----------------------------------------------------
    read |     200       52.23   10.25294         28         76  
   write |     200      52.775   9.478586         31         67  
    math |     200      52.645   9.368448         33         75  
 science |     195    51.66154   9.866026         26         74  
   socst |     200      52.405   10.73579         26         71  

Here is the output you can get from univar.

univar read write math science socst

                                        -------------- Quantiles --------------
Variable       n     Mean     S.D.      Min      .25      Mdn      .75      Max
-------------------------------------------------------------------------------
    read     200    52.23    10.25    28.00    44.00    50.00    60.00    76.00
   write     200    52.78     9.48    31.00    45.50    54.00    60.00    67.00
    math     200    52.64     9.37    33.00    45.00    52.00    59.00    75.00
 science     195    51.66     9.87    26.00    44.00    53.00    58.00    74.00
   socst     200    52.40    10.74    26.00    46.00    52.00    61.00    71.00
-------------------------------------------------------------------------------

If you include the vlabel
option, it also includes the variable labels in the table.

univar read write math science socst, vlabel

                                        -------------- Quantiles --------------
Variable       n     Mean     S.D.      Min      .25      Mdn      .75      Max
-------------------------------------------------------------------------------
    read  reading score
    read     200    52.23    10.25    28.00    44.00    50.00    60.00    76.00

   write  writing score
   write     200    52.78     9.48    31.00    45.50    54.00    60.00    67.00

    math  math score
    math     200    52.64     9.37    33.00    45.00    52.00    59.00    75.00

 science  science score
 science     195    51.66     9.87    26.00    44.00    53.00    58.00    74.00

   socst  social studies score
   socst     200    52.40    10.74    26.00    46.00    52.00    61.00    71.00
-------------------------------------------------------------------------------

The boxplot option displays
a mini boxplot above each variable.

univar read write math science socst, boxplot

                                        ----------:::::::::|:::::::::----------
Variable       n     Mean     S.D.      Min      .25      Mdn      .75      Max
-------------------------------------------------------------------------------
    read  -----------------------::::::::|::::::::::::::-----------------------
    read     200    52.23    10.25    28.00    44.00    50.00    60.00    76.00

   write  ---------------------------::::::::::::::::|::::::::::::-------------
   write     200    52.78     9.48    31.00    45.50    54.00    60.00    67.00

    math  -------------------::::::::::::|:::::::::::--------------------------
    math     200    52.64     9.37    33.00    45.00    52.00    59.00    75.00

 science  --------------------------::::::::::::|:::::::-----------------------
 science     195    51.66     9.87    26.00    44.00    53.00    58.00    74.00

   socst  ------------------------------:::::::::|::::::::::::::---------------
   socst     200    52.40    10.74    26.00    46.00    52.00    61.00    71.00
-------------------------------------------------------------------------------

Here we use the by(female) option
to display tables separately for males and females.

univar read write math science socst, by(female)

-> female=male 
                                        -------------- Quantiles --------------
Variable       n     Mean     S.D.      Min      .25      Mdn      .75      Max
-------------------------------------------------------------------------------
    read      91    52.82    10.51    31.00    44.00    52.00    63.00    76.00
   write      91    50.12    10.31    31.00    41.00    52.00    59.00    67.00
    math      91    52.95     9.66    35.00    45.00    52.00    60.00    75.00
 science      86    52.88    10.75    26.00    44.00    55.00    61.00    74.00
   socst      91    51.79    11.33    26.00    46.00    51.00    61.00    71.00
-------------------------------------------------------------------------------

-> female=female 
                                        -------------- Quantiles --------------
Variable       n     Mean     S.D.      Min      .25      Mdn      .75      Max
-------------------------------------------------------------------------------
    read     109    51.73    10.06    28.00    44.00    50.00    57.00    76.00
   write     109    54.99     8.13    35.00    50.00    57.00    62.00    67.00
    math     109    52.39     9.15    33.00    45.00    53.00    58.00    72.00
 science     109    50.70     9.04    29.00    44.00    50.00    58.00    69.00
   socst     109    52.92    10.23    26.00    46.00    56.00    61.00    71.00
-------------------------------------------------------------------------------

We can use the by(female)
and onehdr options to get a table with one header that can be a bit easier to read.

univar read write math science socst, by(female) onehdr

                                        -------------- Quantiles --------------
Variable       n     Mean     S.D.      Min      .25      Mdn      .75      Max
-------------------------------------------------------------------------------

-> female=male 
    read      91    52.82    10.51    31.00    44.00    52.00    63.00    76.00
   write      91    50.12    10.31    31.00    41.00    52.00    59.00    67.00
    math      91    52.95     9.66    35.00    45.00    52.00    60.00    75.00
 science      86    52.88    10.75    26.00    44.00    55.00    61.00    74.00
   socst      91    51.79    11.33    26.00    46.00    51.00    61.00    71.00

-> female=female 
    read     109    51.73    10.06    28.00    44.00    50.00    57.00    76.00
   write     109    54.99     8.13    35.00    50.00    57.00    62.00    67.00
    math     109    52.39     9.15    33.00    45.00    53.00    58.00    72.00
 science     109    50.70     9.04    29.00    44.00    50.00    58.00    69.00
   socst     109    52.92    10.23    26.00    46.00    56.00    61.00    71.00
-------------------------------------------------------------------------------

Here we ask for a boxplot
for the variable write and ask that the boxplots be plotted using the
same scale (via onescal) so we could meaningfully compare the boxplot
of the males and females. You can see that the median of the boxplot is
higher for the females. (If we had omitted the onescal option,
each boxplot would be on its own scale).

univar write  , by(female) onehdr boxplot onescal

                                        ----------:::::::::|:::::::::----------
Variable       n     Mean     S.D.      Min      .25      Mdn      .75      Max
-------------------------------------------------------------------------------

-> female=male 
   write  -------------------:::::::::::::::::::::|:::::::::::::---------------
   write      91    50.12    10.31    31.00    41.00    52.00    59.00    67.00

-> female=female 
   write          ----------------------------:::::::::::::|::::::::::---------
   write     109    54.99     8.13    35.00    50.00    57.00    62.00    67.00
-------------------------------------------------------------------------------

For More Information

For more information, see the help or reference manual about
summarize.

Cite this article

stats writer (2024). How can I get descriptive statistics and the five number summary on one line?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-get-descriptive-statistics-and-the-five-number-summary-on-one-line/

stats writer. "How can I get descriptive statistics and the five number summary on one line?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-get-descriptive-statistics-and-the-five-number-summary-on-one-line/.

stats writer. "How can I get descriptive statistics and the five number summary on one line?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-get-descriptive-statistics-and-the-five-number-summary-on-one-line/.

stats writer (2024) 'How can I get descriptive statistics and the five number summary on one line?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-get-descriptive-statistics-and-the-five-number-summary-on-one-line/.

[1] stats writer, "How can I get descriptive statistics and the five number summary on one line?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.

stats writer. How can I get descriptive statistics and the five number summary on one line?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.

Download Post (.PDF)
Slide Up
x
PDF
Scroll to Top