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
Model Specification - Generalized DiD or TWFE Model (Need Suggesstions)Hello everyone, I am estimating the effect of a law change on certain policies for the US states. T…
Generating date variables based on ID and yearDear Statalist community, I am working with a panel data set on armed conflict (UCDP/PRIO Armed Con…
Import and reshape data while capturing variable label from ExcelHello, I have 115 worksheets (each of them has about 100 variables) from excel to work with and the…
Importing problem BRFSS SAS file post 2014I'm working with BRFSS data 2010-2015. Before 2014, I could open it by clicking the import option an…
How to calculate annual event rates for use in Kaplan-Meier graphHi Stata-users I would like to depict a Kaplan-Meier failure estimate graph with annual event rates…
Subscribe to:
Post Comments (Atom)
0 Response to Export descriptive statistics tables and charts to multiple worksheets within an Excel workbook
Post a Comment