I'm looking for a solution where I can export descriptive statistics tables and charts to multiple worksheets within an Excel workbook. For example, I would like to have one descriptive table (N, p50, mean, sd, min, max, skewness, kurtosis) of my 5 dependent variables exported to an Excel sheet "Sheet-DepVar", and have the same table for my 5 independent variables to the same workbook but in a separate Excel sheet "Sheet-IndVar". Ideally, I would also like to export a histogram of each variable to the same workbook (I'm currently using "hist"), with each chart put into its own sheet so that when I'm done in this example, I'll have one Excel file that has 2 worksheets, each with its own descriptive table and 10 worksheets each with its own chart.
Related Posts with Export descriptive statistics tables and charts to multiple worksheets within an Excel workbook
Staggered Difference in Difference: How to properly regressHey everyone, ok so I'm completely new to Stata and I have no clue how to run my Staggered Differenc…
Add legend using grqregHi, I want to add legend after running grqreg. the codes are . webuse auto, clear . sqreg price wei…
spread one number within a groupI have a data set looking like this, when fic is not USA, local_markup is missing value. For the mis…
estimating percentiles of gamma distributionHi, I'm a new stata user and currently I'm trying to fit a gamma distribution to my data and compute…
generate variable that can change every yearHi guys, I wanna thank you first, cause I have received so much help here. This is such a great foru…
Subscribe to:
Post Comments (Atom)
0 Response to Export descriptive statistics tables and charts to multiple worksheets within an Excel workbook
Post a Comment