Hello everyone,
I use the command below in Stata 17 to calculate the total income and total tax paid in each quintile (Q) and each group (Status). How can I add a column to this table calculating the tax column divided by the income column? In other words, how can I calculate the share of total tax in total income for each quintile and group?
table (Q Status)(), statistic(frequency) statistic (sum income) statistic (sum tax) statistic (percent tax) nformat(%12.0fc total) nformat(%12.2fc percent) sformat("%s%%" percent )
Thanks.
Related Posts with Dividing a column by another
Weighted Sum of Regression CoefficientsHi, I have conducted 6 different regressions. The resulting coefficients for the variables Pre4, Pr…
Variances and Covariances in the panel dataHi everyone, I just started using STATA and I am wondering how can I compute covariances and varianc…
Displaying sigma_u and rho for xtologit using esttabHello there, The standard esttab command does not include an option to display the value, standard …
OT: Analyzing ordinal data with metric modelsRonán Conroy alerted me to this article in another discussion forum. Some members of this group may …
Remove variable labels from all variable at onceHow to remove variable labels from all variable at once? Or duplicate variable names to variable lab…
Subscribe to:
Post Comments (Atom)
0 Response to Dividing a column by another
Post a Comment