*	STATA Training 1 *

* objective 1 - STATA layout *

* objective 2 - Load data sets *

	* first type - STATA .dta *
	use "Q:\My Drive\HEAL_LAB\STATA Training\Training 1\data sets\wages2.dta", clear
	
	* second type - csv file .csv *
	insheet using "Q:\My Drive\HEAL_LAB\STATA Training\Training 1\data sets\ACS_major.csv", clear
	
	* third type - excel .xlsx *
	import excel "Q:\My Drive\HEAL_LAB\STATA Training\Training 1\data sets\wages.xlsx", clear first sh("Sheet1")
	
* objective 3 - summary statistics *
	* load a data set *
	use "Q:\My Drive\HEAL_LAB\STATA Training\Training 1\data sets\wages2.dta", clear
	
	** sum - look at means and standard deviations **
	sum wage 
	sum wage hours educ exper tenure
	
	sum married
	
	** tab - look at distributions **
	tab educ
	
	tab educ married
	tab educ married, row nofreq

	
*objective 4 - inference testing *
	* conduct test if education = 13 years *
	ttest educ=13
	
	* conduct test if education = 13.5 *
	ttest educ=13.5
	
	** test between two sample means - if wages are different by marital status **
	ttest wage, by(married)