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
Clean Data- Randomly select contents from one variable in list
- How to know the fractional polynomial used in twoway fpfitci
- Does a dofile have meta-data (like a word document) that says something about it's creator?
- Replacing missing values within a variable with true value based on an ID - Seeking efficient solution.
Subscribe to:
Post Comments (Atom)
0 Response to Export descriptive statistics tables and charts to multiple worksheets within an Excel workbook
Post a Comment