Summarize stata. Nov 16, 2022 · To obtain the 10th percentile, we must find the first index i such that W (i) > 1217. 2973 5. foreach i in 0 1 {. When you combine eststo and estpost, you can save named collections of summary statistics. This table should have a column for "mode" in addition to columns for other statistics (e. summarize后可以跟具体变量的名称，如果不跟变量名称，则默认对全部变量进行描述性分析，两种结果如下： （1）输入命令：summarize，得到全部变量的描述性统计结果。 Apr 6, 2016 · I have updated asdoc to support factor variables with the sum command. We can then estimate the total number of persons who have had heart attacks for each sex in the population represented by the data we collected. The new version of asdoc can be installed from my site. baselinetable: A command for creating one- and two-way tables of summary statistics. 975005 Nov 16, 2022 · Treatment-effects estimators reweight the observational data in hopes of achieving experimental-like balanced data results. com Remarks are presented under the following headings: Introduction Avoid single-line if and else with ++ and -- macro expansion Introduction The if command is intended for use inside programs and do-files; see [U] 18. You can do this in two ways: 1. You can also create a table complete with a title, notes, and more, and then export it to a variety of file types. My command is this: bysort round_year ( firm_id_new) : gen ind_patsubgrp_total = sum ( expgrp_total) I was expecting in the 4th column to have the total value 75 for all 1978 rows, and Summary. Mar 22, 2016 · I can't seem to find a command to export summary statistics from stata to word. Commands that I use are: Code: summ lpcincome dukeenergy gulfpower municipal solarresource pyamd4 lpopden age ///. I got it, thanks Nick Cox . Most Stata commands can be followed by if, for example. summarize resid, detail list ‘1’ ‘2’ resid if resid< r(p5) | resid> r(p95) drop resid end Although the program will work, it will also fill the screen with the regression output, any notes that predict feels obligated to mention, and the detailed output from summarize. That varlist contains two variables: market and origin. click Help, Stata Command, then type summarize. As you can see in my code below, I know how to control the decimals for a summary statistic as a whole (e. 4. Search or browse by subject, title, or source. These are completely separate from the percentiles. g. Jun 23, 2023 · Exporting Results Struggle | Summary Statistics Directly from Stata to LaTeX:In this video I talk about how to send summary statistics from Stata directly to In Stata, the summarize or sum command is typically used to generate a table of summary statistics. S. Scales of variable (s) Continuous or categorical (ordinal) Information. If you want to get the mean, standard deviation, and five number summary on one line the subsample over which it is to be defined. gen `s' = r(`s') in 1. Obs>. A lot can be achieved by pushing the results to matrices and then exporting the whole thing. First, let’s summarize our reaction time variables and see how Stata handles the missing values. Stata calls these returned results. believe, so you might get your matrix into mata and compute the sum. Also see table is a flexible command for creating tables of many types—tabulations, tables of summary statistics, tables of regression results, and more. You can use the detail option, but then you get a page of output for every variable. What you posted under "stata help copy" suggests that r (p66) is not defined (-sum, detail- returns r (p75) and r (p90), but no other percentile between these two). Statistics > Summaries, tables, and tests > Other tables > Compact table of summary statistics Description tabstat displays summary statistics for a series of numeric variables in one table, possibly broken down on (conditioned by) another variable. This option outputs a table with additional statistics. You can create files containing the following: formatted paragraphs. You can also summarize by variable. The example is built the same way the tabulate example was. Re: st: How to export a summary statistics table? Date. st: RE: Using weight in summarize command. I want to use weight in summarize command. After making the change, Stata indicates that our dataset is “Sorted by:” nothing. For example, if you want to mean center a variable, you can use summarize to calculate the mean, then use the value of the mean calculated by summarize to center the variable. Tue, 9 Apr 2013 08:49:03 -0400. This FAQ is likely only of interest to users of previous versions of Stata. And the value of an option is always wrapped in parentheses. Simply type summarize into the "Command" window. The summarize() table normally includes the mean, standard deviation, frequency, and, if the data are weighted, number of observations. A better version of this program might read program myprog summarize resid, detail list ‘1’ ‘2’ resid if resid< r(p5) | resid> r(p95) drop resid end Although the program will work, it will also fill the screen with the regression output, any notes that predict feels obligated to mention, and the detailed output from summarize. docx) files more easily. a, . If no varlist is specified, summary statistics are calculated for all the variables in the Title stata. Remarks are presented under the following headings: One-way tables Two-way tables Nov 16, 2022 · Logic of summarize’s formula. 4 Macros and expressions for examples of its use. It reports individual effect sizes and the overall effect 2tebalance summarize— Covariate-balance summary statistics Syntax tebalance summarize varlist, baseline varlist may contain factor variables; see [U] 11. However, outreg2 exports all the variables on the list. mean— Estimate means 5 Example 3: standardized means Suppose that we collected the blood pressure data fromexample 2of[R] dstdize, and we wish toobtain standardized high blood pressure rates for each city in 1990 and 1992, using, as the standard, To. If the reweighting is successful, then the weighted distribution of each covariate should be the same across treatment groups. summarize if foreign == 1. 47205 95% 34 35 Skewness . The manual entry for [R] summarize tells us that to calculate medians we need to specify the detail option and that the median is left behind in memory in r(p50). The summarize command returns mean, standard deviation, minimum, maximum and frequency. Apr 14, 2019 · The syntax of the summarize command is as follows: command [varlist] [if] [in] [weight] [, options] For instance we can get summary statistics of wage for southern residents: summarize wage if south==1. I used this command for example "tabstat hmembers18 yearschoolI, statistics ( mean median )" to get the means and medians. 3. 2) esttab, cells ("mean sd min max") nomtitle nonumber noobs. Calculations are based on all non-missing values of varname. Quick facts. the mean is displayed with no decimals): Subject. It is easy enough to generate these as two separate tables with estpost, summarize, and ttest, and combine manually, but I would like to automate the whole process. For regression output, I have been using eststo and esttab which works well. Reference Donath, S. . I would also like to add further statistics like ttests and ranksum tests to each group. by rep78: gen cumfreq = _N if _n == 1. Written by: Ylva B Almquist. Let’s put the dataset back as it was:. I was asked to combine the summary statistics and the correlation matrix in one Jun 12, 2019 · However, I want to specify the number of decimals displayed per variable as opposed to the default which is per summary statistic. May 29, 2016 · I also want to export summary statistics to word/excel and I manage to get the following steps to work: 1) estpost summarize Length DefaultStart DefaultEnd GDPgidy AvGDPgipd etc. edu. Min Max x 0 [U] 24 Working with strings3 Stata can store strings Ado-file writers will find this useful for fast calls. You can create documents with. local statistics N mean sd min max p1 p5 p10 p25 p50 p75 p90 p95 p99. summarize mpg, detail Mileage (mpg) Percentiles Smallest 1% 12 12 5% 14 12 10% 14 14 Obs 74 25% 18 14 Sum of wgt. that way, and then return the result as a scalar to stata. When index i =1, we can see W (1) = 2640, which is greater than 1217. As you can see, it tells us the number of observations in the file, the number of variables, the names of the variables, and more. For the case mui = mu, the variance of xbar = (sum wi xi)/ (sum wi) is sigma2/W. help summarize . to save the results of a regression of y on x1 and x2. Option Main baseline specifies that tebalance summarize report means and variances by treatment level. 0g z float %9 Nov 16, 2022 · Stata's putpdf command allows you to automate the production of PDF files. gen un_p5 = r(p5) Note that you need summarize, detail for this to be useful. Summarize – A GUIDE TO APPLIED STATISTICS WITH STATA. sysuse auto. Oh sorry. Oct 25, 2018 · I have been outreg2 to export summary statistics table until now. Easily update datasets containing dozens, or even hundreds, of series. For example, typing. Other summary command don't support formatting as far as I know and 'format= (%9. summarize if rep78 == 2 . com meta summarize — Summarize meta-analysis data DescriptionQuick startMenuSyntax OptionsRemarks and examplesStored resultsMethods and formulas ReferencesAlso see Description meta summarize summarizes meta data. with Stata/SE, or 2,048 variables with Stata/BE; these are the maximum allowed in the dataset. You need to read it in columns, not rows. Mar 24, 2018 · The mean, sd and count are under each other in rows, instead of a wide format, like it is displayed in Stata. I know about "outreg2" for regression but not sure for summary statistics. , . We can report these extra statistics through the outreg2 command by typing detail in the parenthesis of the sum () option used above: outreg2 using results, word replace sum May 8, 2020 · 1. Date. Remarks and examples stata. 3) esttab using Table1, main (mean) label replace. Dev. ・,detailをつけずにsummarize （変数A）だけにすると、平均や標準偏差は表示されますが、中央値などが表示されません（Stataでは May 12, 2023 · Hi! As indicated in the title, I wonder how I can create a table to display a variable's summary stats by year and status. summarize wage [aw=weight] [email protected] I am new to stata user list. 1f)' leads to N having a decimal. Now there was a logic behind the use of summarize ’s formula for aweight s: s 2 = {n/[W(n - 1)]} sum w i (x i - xbar) 2. Put series on a common periodicity. So what I want is that there are four columns in total, "importer" "mean" "sd" "observations". 3 Factor variables. Title stata. meta is a new suite of commands available in Stata 16 to perform MA. Wu --. collect is allowed; see [U] 11. values Min Max age 3 122 5 17 21 female 3 122 2 0 1 dept 9 116 4 1 4 Stata provides 27 different missing values, namely, . I tried adding "wide" etc. whatever if foreign == `i'. Code: svyset [pweight=d1ca1weight] (a combined design and a poststratification weight) Now I wanted to use tabstat to see my descriptive statistics as follows: Code: svy: sum allg_lz erw job kohorte partner ost gesund loghheinknett_z migstat Apr 16, 2016 · The first time around the loop, i is set to 1, and Stata summarizes the response using weight for observations with values of group equal to 1. As we discussed above, the estpost command makes the summary statistics produced by commands like summarize, ttest, and tabulate look like regression results to Stata. Sep 13, 2022 · The smallest 4 values (not 5) and largest 4 (ditto) values are shown in the second column. 785503 12 41. st: Format summary table numbers with maximum of one decimal. One clue to by: being useful here is the structure of a grouping of the variable x into several distinct values. The mata function sum() adds up everything in an arbitrary matrix, I. Here we will use the auto data file. En este módulo vemos cómo realizar los Feb 27, 2015 · Stata command to summarize data by "mode". Re: st: how to summarize a big matrix. tabulate category, summarize(myvar) means standard This page shows an example of getting descriptive statistics using the summarize command with footnotes explaining the output. The dtable command allows you to easily create a table of descriptive (summary) statistics, commonly known as “Table 1”. I need to create a table to summarize my data. , mean, median). 2973 Largest Std. docx files. eststo reg1: reg y x1 x2. 74 50% 20 Mean 21. Min Max x 0 If this happens to you, type describe to confirm that x is stored as a string:. summarize , detail . We can also estimate the median from survey data by using summarize with aweight s. Algebraic and string expressions are specified in a natural way using the standard rules of hierarchy. Summarize if rep78 equals 2. You can do the above by using by: , which is one of the most versatile features of Stata. . Sun, 4 Dec 2011 04:53:36 +0800. , is often called system missing. 1. These are very general rules in Stata and you cannot violate them. But my problem is I want only selected variables to be exported in the table. When combined with the by prefix, it can produce n-way tables as well. So far, I have figured out how they work and my results look quite appealing. First we look at the summary statistics for the whole sample, and then we look at the statistics for subsamples (each province). （1） 单独用summarize： 不 Re: st: how to save the result of percentile using summarize. program define my_summarize. For instance, if you’re working with the auto dataset, you would type: sysuse auto sum To export the output from the sum command to a Word document, you can use the asdoc command. In such cases, we say that the treatment model "balanced" the covariates. We recommend that you read summarize, detail calculates standard percentiles. Is there a utility out there that can help? I know I can convert them all to Julian dates, but those will be barely more intelligible, and YYYYMMDD format will give distorted summary values. Nov 16, 2022 · The solution. Quick start Two-way tabulation of a1 and a2 table a1 a2 Jul 13, 2016 · Summary Statistics for One Quantitative Variable over One Categorical Variable. 1 We would like to show you a description here but the site won’t allow us. summarize followed by option(s). embedded Stata graphs (or any PNG, JPEG, EMF, or TIFF files) And you can control page size, page breaks, and document orientation, and you can even append . foreach— Loop over items 5 produces the same results as typing foreach file in ‘flist’ {:::} except that foreach file of local flist is faster, uses less memory, and allows the list to be May 9, 2019 · Hello Stata experts, I try to export my summary statistics, the correlation table and my regressions with the esttabs functions. dev. At the moment, asdoc supports factor variables only in the simple summary statistics. I want to calculate statistics using Sep 30, 2020 · I want to sum up all values in the third column 'expgrp_total' by year and create a new variable filled with the summed value for that same year across the rows. 25. If no options have been specified for the variables, it displays the number of observations, mean, standard deviation, minimum and maximum values. and international economic and financial time series. Copy and paste the following line in Stata and press enter. embedded output from Stata in paragraphs and tables. xml from Excel to get the Excel output. Number of variables. com Example 1 Suppose that we collected data on incidence of heart attacks. 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). Once you know how to start you can Feb 6, 2018 · The pattern you are seeking is. summarize returns a variety of univariate summary statistics. summarize if rep78 > 2 Jun 15, 2015 · 03 Dec 2017, 14:08. return list scalars: r(N) = 74 Descriptive statistics in Stata Acknowledgments The tabstat command was written by Jeroen Weesie and Vincent Buskens both of the Department of Sociology at Utrecht University, The Netherlands. xlsx saved The formatted Excel table looks like this: Nov 14, 2019 · I have produced summary statistics using asdoc by Attaullah Shah, however I wanted to get summary statistics that would show proportions of a category variable. summarize mpg Variable Obs Mean Std. This variable is coded 1 if the student was female, and 0 otherwise. 1 Converting continuous variables to indicator variables Stata treats logical expressions as taking on the values true or false, which it identifies with the numbers 1 and 0; see [U] 13 Functions and expressions #stata#statistics#researchhttps://www. describe Contains data obs: 10 vars: 3 size: 160 storage display value variable name type format label variable label x str4 %9s y float %9. summarize if foreign == 1 & mpg > 30. logout, save (result) excel word replace: summarize Openning the result. com cmsummarize — Summarize variables by chosen alternatives cmsummarize— Summarize variables by chosen alternatives 5 Example 2: Panel choice data I would like to use esttab (ssc install estout) to generate summary statistics by group with columns for the mean difference and significance. table can also include results from other Stata commands. Specifically, the variable of interest is city, and staus takes 4 values, 0, 1, 2, and 3. Case 1: Identifying duplicates based on a subset of variables. summarize x Variable Obs Mean Std. table can calculate summary statistics to display in the table. One common pattern is to cycle through all values of a classifying variable. com summarize — Summary statistics DescriptionQuick startMenuSyntax OptionsRemarks and examplesStored resultsMethods and formulas ReferencesAlso see Description summarize calculates and displays a variety of univariate summary statistics. Sep 21, 2023 · summarize是stata里最常见的描述性统计命令，下面用案例对summarize进行讲解：. Apr 4, 2015 · sumdist estimates distributional summary statistics commonly used by income distribution analysts, complementing those available via pctile, xtile, and summarize, detail. summarize if rep78 >= 2 . This can be estimated by u2/W, where u2 is the estimate of sigma2 we had before. Nov 16, 2022 · Logic of summarize’s formula. May 23, 2014 · I have the following data and would like to produce some summary statistics in a three-way crosstabulation. Nov 16, 2022 · The percent() option was added to contract to Stata 8 on 1 July 2004. Thanks Stata can convert continuous variables to categorical and indicator variables and categorical variables to indicator variables. summarize （変数A）, detail. I weighted my data with. sysuse auto . harvard. misstable summarize Example 1 misstable summarize reports counts of missing values:. mpg are 34, 35, 35 and 41. A better version of this program might read program myprog Jun 26, 2023 · Before Stata 18, if we wanted to generate a table of descriptive statistics (to be included in a publication later), we might have used summarize to obtain summary statistics for continuous variables and tabulate to report the frequencies, proportions, or percentages for categorical variables. Nov 16, 2022 · putdocx lets you create Word (. tables. putexcel B2:F6, bold file putexcel2. (With summarize alone, the above statement is legal, but will just store numeric missing in every observation. instagram. Returned results can be very useful when you want to use information produced by a Stata command to do something else in Stata. In short, the summarize command performed the computations on all the available data. For example, Title stata. Summarize if rep78 greater than 2. 本案例中，我们只需要用到price（汽车价格）、mpg（里程）、rep78（维修次数）这几个变量就行哈（以后我们会经常用它做案例，可以稍微熟悉一下这个数据~）. 785503 75% 25 34 90% 29 35 Variance 33. Sep 6, 2022 · 06 Sep 2022, 09:55. 10 Prefix commands. For instance, if we had data on automobiles and wished to obtain means according to market category (market) broken down by manufacturer (origin), we could type by market origin: summarize. You need to master the basic Stata syntax that applies to the vast majority of Stata commands. z. statalist@hsphsun2. 5. If you want other types of percentages and need to calculate them directly, the best way is through an application of by . How about the command below. At least one. Summarize if rep78 is greater than or equal to 2. Nov 16, 2022 · Starting with Stata 8, the duplicates command provides a way to report on, give examples of, list, browse, tag, or drop duplicate observations. When there are study-level covariates, also known as moderators, that may explain some of the between-study variability, heterogeneity can be explored further via subgroup analysis and, more generally, via Mar 25, 2020 · Rohen Shah explains how to summarize and generate variables, including a 5-number summary. The default is separator (5), meaning that With the summarize command, which is typically used to return summary statistics, Stata allows an option of detail . For example if I wanted to get the summary statistics of say proportion of people belonging to a certain category, where the category could be as follows: Subject: Re: st: Interpreting summarize, detail. When running the detail option for the summarize syntax for the numeric variable "Sheet2", I have the results below The sysuse command loads a specified Stata-format dataset that was shipped with Stata. sort mpg Technical note Stata is limited in how it tracks changes in the sort order and will sometimes decide that a dataset is not sorted when, in fact, it is. Stata online help. Your example syntax doesn't really work - and you display information from the helpfile that suggests so. Statistics >Summaries, tables, and tests >Summary and descriptive statistics >Standard deviation CI calculator ci— Confidence intervals for means, proportions, and variances 3 Syntax Feb 23, 2015 · As a matter of fact, the use of summarize/regress and putexcel was covered in The Stata Daily, there is also very good article in The Stata Blog on that. To give a high-level overview for all eligible variables in the dataset, run: summarize. The first of those, . separator (#) specifies how often to insert separation lines into the output. ・変数Aについて、平均、標準偏差、中央値（四分位範囲）、最小値、最大値などを計算できます。. To generate descriptive statistics for your variables, you can use the summary command (or sum, for short). All we need to do is tag the first occurrence of each distinct value, and then count those first occurrences in sequence. I am trying to create a summary with N, mean and sd showing no decimal for = the integer (N) and exactly one decimal for mean and sd in Stata 13 and I a= m not succeeding. The asdoc command sends Stata output to Word documents. The variable heartatk indicates whether a person ever had a heart attack (1 means yes; 0 means no). summarize with complex if specifying records to summarize. 1. Let us illustrate with a simple example from the auto dataset. sum weight. Basically my question is this: Here is I have wage and weight for each observation. Easy-to-use interface for searching and browsing. format requests that the summary statistics be displayed using the display formats associated with the variables rather than the default g display format; see [D] format. Individual elements of the table may be included or suppressed by the [no]means, [no]standard, [no]freq, and [no]obs options. The describe command shows you basic information about a Stata data file. embedded Stata graphs (or any PNG or JPEG files) And you can control page size, page breaks, and document orientation. , summarize), you can use the Stata help to get a quick summary of the command and its syntax. b, :::, . Obs<. Notice that the default file format is "Stata Data" We are going to use the summarize command to get basic information about our data. Thus, with the auto data, we could cycle through all the values of foreign or rep78 . com/k_dodo29/A short video about how to export summary statistics to word. foreach s of local statistics {. summarize compare means and variances in raw and balanced data overid overidentification test density kernel density plots for raw and balanced data box box plots for each treatment level for balanced data Remarks and examples stata. replace mpg=12 in 1 (1 real change made). As you see in the output below, summarize computed means using 4 observations for trial1 and trial2 and 6 observations for trial3. So the smallest 4 values for mpg are 12, 12, 14 and 14; the largest 4 values for. Unique Variable Obs=. There are 3 columns of results -. Jun 9, 2019 · I'm doing a cross-sectional analysis with one wave of a german Panel study. ) But why you are putting 8 constants in 8 variables is unclear. Stata的操作演示如下： 第一种方法，输入stata命令： summarize. First, we sort by the variable of interest and get the frequencies: . Optionally, you can add p-values from test statistics comparing groups on summary statistics. Download directly into Stata. but I cant get it to work. by rep78, sort: gen freq = _N. Various estimation methods are supported including DerSimonian–Laird and Mantel–Haenszel. Stata outputs the selected stats in rows, rather than in columns. (Type summarize dog, detail to get more detailed information about the variable "dog". Or we can look at wage levels if total work life experience is less than five years, like so: summarize wage if ttl_exp < 5. Jan 24, 2017 · Finally, I display the numbers in cells B2:F1 using a bold font to make the table look similar to the output of summarize. Thus the 10th percentile price [10] is equal to price (1); that is, the price [10] = 3799. It presents summary statistics such as mean, median, standard deviation, etc. com tabulate with the summarize() option produces one- and two-way tables of summary statistics. Stata Journal 18: 327–344. misstable summarize Obs<. formatted paragraphs. However, there are too minor things, I would like to do. So, putting it all together, the general syntax of the summarize command can be described as: [by varlist:] summarize [varlist] [in range] [if exp] , [options] Nov 16, 2022 · meta summarize and meta forestplot report basic heterogeneity measures and the homogeneity test to assess the presence of heterogeneity. summ return_on_invested_capital, detail. 9487176 99% 41 41 Kurtosis 3. Then we get the cumulative frequencies: . Without the by() option, tabstat is a useful alternative to summarize (see[R] summarize) Title stata. summarize trial1 trial2 trial3 . sysuse auto, clear. -if- and -in- clauses precede the comma, and options follow the comma. It should work as you wanted. Use if if you wish to exclude values less than or equal to zero. As you have 10710 values, the 99th percentile 1123875 is smaller than each of the largest 4 values listed. com This entry provides an overview of the commands in tebalance. percentiles, smallest and largest 4 values, and other stats. 2. Another is[R] summarize: summarize varlist if in The optional expression restricts the sample over which summary statistics are calculated. The command is to be used for continuous variables, such as income, age, total vaccinations, etc. The lazy option would involve using logout (SSC) and simply passing the whole output to Excel. What I'd like to do is something like the above but get mean, median etc displayed as formatted dates. Quick start Nov 16, 2022 · foreach offers a way of repeating one or more Stata commands; see also [P] foreach. type help summarize in the command window, or. Min Max mpg 74 21. Wed, 5 Dec 2007 22:16:10 -0000. ) Yet, when you attempt to obtain summary statistics on x,. Here is what help summarize looks like. Subject. One way to do it is: Code: capture program drop my_summarize. The detailed summary statistics with factor variables is on the to-do list. Using Hola ! En esta ocasión les comparto el cuarto módulo de un curso introductorio a STATA, destinado a agentes estatales. com stored results . 2018. This information can be found on our STATA FAQ page: How can I draw a random sample of my data? Summary. summarize. Three MA models are supported: random-effects (default, random), common-effect (aka “fixed-effect”, common), and fixed-effects (fixed). Nov 16, 2022 · Over 566,000 U. In the first example, we get the descriptive statistics for a 0/1 (dummy) variable called female. com estat summarize — Summarize estimation sample DescriptionQuick startMenu for estatSyntax OptionsRemarks and examplesStored resultsAlso see Description estat summarize summarizes the variables used by the command and automatically restricts tabulate, summarize()— One- and two-way tables of summary statistics 3 Remarks and examples stata. If you start with a tab command and then add the sum () option, with the name of a continuous variable in the parentheses, Stata will add summary statistics for that variable to each cell of the table: tab class, sum (edu) Gives: SUBJECTIVE |. When you know the name of the command you want to use (e. Nov 16, 2022 · Stata Journal readers can also find a tutorial on by (Cox 2002). which will output the number of non-missing observations, mean, standard Mar 6, 2017 · If you want to directly copy results from the Stata results' window, and want the results to show in MS Word as they apear in Stata, copy the results, paste in MS Word, and then format the text as following Font : Courier New Font size : 9 statalist@hsphsun2. You wish to create a new variable named dup Yet, when you attempt to obtain summary statistics on x,. gq ay sf km gp sp af pv li ki