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
Import Matlab dataset to StataHi, Is there any way Stata can import MATLAB Data (.mat)? I cannot seem to be able to upload the da…
Display Median for Paired t testHello folks I have a data set with several observations at different times for companies. However, …
graph like this?Dear All, I was asked how to draw a graph like this. Array Unfortunately, no data is available at …
Regression with WeightDear STATA users, I am trying to replicate a paper. The authors investigate the relationship betwee…
Does the drive Stata is installed on matter?Hi all, I'm trying to optimise my simulation study and was wondering if the location of the Stata in…
Subscribe to:
Post Comments (Atom)
0 Response to Export descriptive statistics tables and charts to multiple worksheets within an Excel workbook
Post a Comment