Title

exceloutput -- Output several results to specified cell in putexcel file

Syntax

exceloutput
[, options]

Menu

Description

exceloutput can be invoked after an estimation takes place and takes as an argument an excel cell. It will then place regression coefficients in the selected cell and standard error in the cell
beneath along with stars for p-values. Helps make cleaner do files and removes multiple lines of putexcel code that would be required. A decent alternative to estout and custum putexcel commands if quick output is required.

The command has options to choose the number of coefficients and S.E.'s to output, the desired number of decimal places, and an option to add summary statistics
such as number of observations, R^2, and the mean of the dependent variable.

Options

Options

betas(#) Number of coeffcients and S.E. to output. Will begin with first specified in estimation and go down. Default is 1.

title(string) Create bold title in first specified cell and coeffcients and S.E. come under

b_decimal(#) Number of decimal places for coeffcients

se_decimal(#) Number of decimal places for standard errors

detail Include dependent varible mean, R2, and Number of observations underneath coeffcients and S.E.

mean_decimal(#) Number of decimal places for mean

r2_decimal(#) Number of decimal places for R^2

Examples

Setup

. sysuse auto

. putexcel set exceloutput_example.xlsx, replace

. reg mpg price rep78

Place mpg coeffcient and s.e in Cell A2 of exceloutput_example.xlsx

. exceloutput A2

Place mpg and price coeffcients and s.e's in Cell B2 of exceloutput_example.xlsx

. exceloutput B2, be(2)

Place mpg and price coeffcients and s.e's in Cell C2 of exceloutput_example.xlsx, give it title of "Example", show y-mean, R2 and number of obs

. exceloutput C2, be(2) ti("Example") d