t-stat table difference by groups

Hello Statalisters,

I have the following dataset,

Code:

* Example generated by -dataex-. To install: ssc install dataex
clear
input str12 legor byte(cr1978 cr1983 cr1988 cr1993 cr1998 cr eng fren ger scan soc)
"French      " 0 0 0 0 0 0 0 1 0 0 0
"French      " 0 0 0 0 0 0 0 1 0 0 0
"French      " 0 0 0 0 0 0 0 1 0 0 0
"French      " 0 0 0 0 0 0 0 1 0 0 0
"French      " 0 0 0 0 0 0 0 1 0 0 0
"French      " 0 0 0 0 0 0 0 1 0 0 0
"French      " 0 0 0 0 0 0 0 1 0 0 0
"French      " 0 0 0 0 0 0 0 1 0 0 0
"English     " 0 0 0 0 0 0 1 0 0 0 0
"French      " 0 0 0 0 0 0 0 1 0 0 0
"French      " 0 0 0 0 0 0 0 1 0 0 0
"French      " 0 0 0 0 0 0 0 1 0 0 0
"French      " 0 0 0 0 0 0 0 1 0 0 0
"French      " 0 0 0 0 0 0 0 1 0 0 0
"French      " 0 0 0 0 0 0 0 1 0 0 0
"French      " 0 0 0 0 0 0 0 1 0 0 0
"French      " 0 0 0 0 0 0 0 1 0 0 0
"French      " 0 0 0 0 0 0 0 1 0 0 0
"French      " 0 0 0 0 0 0 0 1 0 0 0
"French      " 0 0 0 0 0 0 0 1 0 0 0
"French      " 1 1 1 1 1 1 0 1 0 0 0
"French      " 1 1 1 1 1 1 0 1 0 0 0
"French      " 1 1 1 1 1 1 0 1 0 0 0
"French      " 1 1 1 1 1 1 0 1 0 0 0
"French      " 1 1 1 1 1 1 0 1 0 0 0
"French      " 1 1 1 1 1 1 0 1 0 0 0
"English     " 1 1 1 1 1 1 1 0 0 0 0
"French      " 1 1 1 1 1 1 0 1 0 0 0
"English     " 1 1 1 1 1 1 1 0 0 0 0
"French      " 1 1 1 1 1 1 0 1 0 0 0
"French      " 1 1 1 1 1 1 0 1 0 0 0
"French      " 1 1 1 1 1 1 0 1 0 0 0
"French      " 1 1 1 1 1 1 0 1 0 0 0
"French      " 1 1 1 1 1 1 0 1 0 0 0
"French      " 1 1 1 1 1 1 0 1 0 0 0
"French      " 1 1 1 1 1 1 0 1 0 0 0
"French      " 1 1 1 1 1 1 0 1 0 0 0
"French      " 1 1 1 1 1 1 0 1 0 0 0
"English     " 1 1 1 1 1 1 1 0 0 0 0
"English     " 1 1 1 1 1 1 1 0 0 0 0
"English     " 1 1 1 1 1 1 1 0 0 0 0
"English     " 1 1 1 1 1 1 1 0 0 0 0
"German      " 1 1 1 1 1 1 0 0 1 0 0
"French      " 1 1 1 1 1 1 0 1 0 0 0
"English     " 2 2 2 1 1 1 1 0 0 0 0
"English     " 2 2 2 1 1 1 1 0 0 0 0
"French      " 2 2 2 2 0 0 0 1 0 0 0
"Scandinavian" 2 2 2 2 1 1 0 0 0 1 0
"German      " 2 2 2 2 2 2 0 0 1 0 0
"French      " 2 2 2 2 2 2 0 1 0 0 0
"English     " 2 2 2 2 2 2 1 0 0 0 0
"English     " 2 2 2 2 2 2 1 0 0 0 0
"English     " 2 2 2 2 2 2 1 0 0 0 0
"German      " 2 2 2 2 2 2 0 0 1 0 0
"French      " 2 2 2 2 2 2 0 1 0 0 0
"French      " 2 2 2 2 2 2 0 1 0 0 0
"English     " 2 2 2 2 2 2 1 0 0 0 0
"English     " 2 2 2 2 2 2 1 0 0 0 0
"Scandinavian" 2 2 2 2 2 2 0 0 0 1 0
"French      " 2 2 2 2 2 2 0 1 0 0 0
"French      " 2 2 2 2 2 2 0 1 0 0 0
"English     " 2 2 2 2 2 2 1 0 0 0 0
"English     " 2 2 2 2 2 2 1 0 0 0 0
"French      " 2 2 2 2 2 2 0 1 0 0 0
"French      " 2 2 2 2 2 2 0 1 0 0 0
"French      " 2 2 2 2 2 2 0 1 0 0 0
"English     " 2 2 2 2 2 2 1 0 0 0 0
"English     " 2 2 2 2 2 2 1 0 0 0 0
"English     " 2 2 2 2 2 2 1 0 0 0 0
"French      " 2 2 2 2 2 2 0 1 0 0 0
"French      " 2 2 2 2 2 2 0 1 0 0 0
"French      " 2 2 2 2 2 2 0 1 0 0 0
"French      " 2 2 2 2 2 2 0 1 0 0 0
"French      " 2 2 2 2 2 2 0 1 0 0 0
"French      " 2 2 2 2 2 3 0 1 0 0 0
"Scandinavian" 2 2 3 3 3 3 0 0 0 1 0
"Scandinavian" 3 3 3 1 1 1 0 0 0 1 0
"English     " 3 3 3 2 2 2 1 0 0 0 0
"French      " 3 3 3 3 2 2 0 1 0 0 0
"English     " 3 3 3 3 3 2 1 0 0 0 0
"English     " 3 3 3 3 3 2 1 0 0 0 0
"German      " 3 3 3 3 3 2 0 0 1 0 0
"German      " 3 3 3 3 3 3 0 0 1 0 0
"French      " 3 3 3 3 3 3 0 1 0 0 0
"English     " 3 3 3 3 3 3 1 0 0 0 0
"French      " 3 3 3 3 3 3 0 1 0 0 0
"English     " 3 3 3 3 3 3 1 0 0 0 0
"French      " 3 3 3 3 3 3 0 1 0 0 0
"English     " 3 3 3 3 3 3 1 0 0 0 0
"German      " 3 3 3 3 3 3 0 0 1 0 0
"French      " 3 3 3 3 3 3 0 1 0 0 0
"English     " 3 3 3 3 3 3 1 0 0 0 0
"French      " 3 3 3 3 3 3 0 1 0 0 0
"English     " 3 3 3 3 3 3 1 0 0 0 0
"German      " 3 3 3 3 3 3 0 0 1 0 0
"English     " 3 3 3 3 3 3 1 0 0 0 0
"English     " 3 3 3 3 3 3 1 0 0 0 0
"French      " 3 3 3 3 3 3 0 1 0 0 0
"English     " 3 3 4 4 4 4 1 0 0 0 0
"English     " 4 4 4 4 3 3 1 0 0 0 0
end

Then I create a table of means with this code

Code:

tabstat cr1978 cr1983 cr1988 cr1993 cr1998 cr, statistics( mean ) by(legor)

I would like to add to this table one more row (or create a new table) which would have t-tests on the differences between "English" and "French" for each variable (cr1978 cr1983 cr1988 cr1993 cr1998 cr), with notion of level of significance. Such that the final result would look something like:

	cr1978	cr1983	cr1988	cr1993	cr1998	cr
t-test, English vs French	4.6***	4.6***	4.3**	4.3**	4.1*	4.1*

Where ***, **, * stand for significance at 1%, 5%, and 10% respectively.

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / t-stat table difference by groups
t-stat table difference by groups

0 Response to t-stat table difference by groups

Post a Comment

Home / Data Cleaning / Data management / Data Processing / t-stat table difference by groups t-stat table difference by groups

0 Response to t-stat table difference by groups

Post a Comment

Home / Data Cleaning / Data management / Data Processing / t-stat table difference by groups
t-stat table difference by groups