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
Saving mean and CI after "svy: mean" or a more efficient way to plot survey trends with CI's?Hello Statalist, I'm new to using the -svy- commands and I am trying to construct trend graphs with…
Remove blank space at the end of a graphHi Statalist! I am trying to get a plot of multiple time-series in one graph but I keep getting thi…
How to expand the panel data to pairsHi All, I am struggling to combine my long panel data to pairs and wonder if anyone can give me a h…
Interpretation of output from the 'churdle' commandHello, I am currently planning a study and started thinking about the proper econometric approach t…
How to combine char(40) and a stringI have a standard error saved in a local variable `se'. For instance, the s.e. is .89. I want it to …
Subscribe to:
Post Comments (Atom)
0 Response to Export descriptive statistics tables and charts to multiple worksheets within an Excel workbook
Post a Comment