---------------------------------------------------------------------------------------- name: log: C:\Users\Tim Gindling\Documents\Econ611\testing.log log type: text opened on: 14 Sep 2017, 17:51:19 . list +-----------------------------------------+ | family person salary hours tall | |-----------------------------------------| 1. | 1 1 10 5 4 | 2. | 1 2 20 5 5 | 3. | 2 1 30 6 5.5 | 4. | 2 2 30 7 5 | +-----------------------------------------+ . list salary +--------+ | salary | |--------| 1. | 10 | 2. | 20 | 3. | 30 | 4. | 30 | +--------+ . describe Contains data from C:\Users\Tim Gindling\Documents\Econ611\data2.dta obs: 4 vars: 5 9 Sep 2015 17:53 size: 80 ---------------------------------------------------------------------------------------- storage display value variable name type format label variable label ---------------------------------------------------------------------------------------- family float %9.0g person float %9.0g salary float %9.0g hours float %9.0g tall float %9.0g ---------------------------------------------------------------------------------------- Sorted by: . summarize Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- family | 4 1.5 .5773503 1 2 person | 4 1.5 .5773503 1 2 salary | 4 22.5 9.574271 10 30 hours | 4 5.75 .9574271 5 7 tall | 4 4.875 .6291529 4 5.5 . sum Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- family | 4 1.5 .5773503 1 2 person | 4 1.5 .5773503 1 2 salary | 4 22.5 9.574271 10 30 hours | 4 5.75 .9574271 5 7 tall | 4 4.875 .6291529 4 5.5 . l +-----------------------------------------+ | family person salary hours tall | |-----------------------------------------| 1. | 1 1 10 5 4 | 2. | 1 2 20 5 5 | 3. | 2 1 30 6 5.5 | 4. | 2 2 30 7 5 | +-----------------------------------------+ . sum salary Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- salary | 4 22.5 9.574271 10 30 . sum salary family Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- salary | 4 22.5 9.574271 10 30 family | 4 1.5 .5773503 1 2 . tabulate family family | Freq. Percent Cum. ------------+----------------------------------- 1 | 2 50.00 50.00 2 | 2 50.00 100.00 ------------+----------------------------------- Total | 4 100.00 . histogram salary, discrete (start=10, width=10) . twoway (scatter salary hours, sort) . plot salary hours 30 + | * * | | | | | s | a | l | a | r | * y | | | | | | | | 10 + * +----------------------------------------------------------------+ 5 hours 7 . twoway (line salary hours, sort) . gen logsal=log(salary) . l logsal salary +-------------------+ | logsal salary | |-------------------| 1. | 2.302585 10 | 2. | 2.995732 20 | 3. | 3.401197 30 | 4. | 3.401197 30 | +-------------------+ . summariz logsal salary Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- logsal | 4 3.025178 .5182627 2.302585 3.401197 salary | 4 22.5 9.574271 10 30 . gen wage=salary/hours . l salary hours wage +---------------------------+ | salary hours wage | |---------------------------| 1. | 10 5 2 | 2. | 20 5 4 | 3. | 30 6 5 | 4. | 30 7 4.285714 | +---------------------------+ . l +---------------------------------------------------------------+ | family person salary hours tall logsal wage | |---------------------------------------------------------------| 1. | 1 1 10 5 4 2.302585 2 | 2. | 1 2 20 5 5 2.995732 4 | 3. | 2 1 30 6 5.5 3.401197 5 | 4. | 2 2 30 7 5 3.401197 4.285714 | +---------------------------------------------------------------+ . gen big=0 . l +---------------------------------------------------------------------+ | family person salary hours tall logsal wage big | |---------------------------------------------------------------------| 1. | 1 1 10 5 4 2.302585 2 0 | 2. | 1 2 20 5 5 2.995732 4 0 | 3. | 2 1 30 6 5.5 3.401197 5 0 | 4. | 2 2 30 7 5 3.401197 4.285714 0 | +---------------------------------------------------------------------+ . gen big=1 big already defined r(110); . replace big=1 if tall>4 (3 real changes made) . l +---------------------------------------------------------------------+ | family person salary hours tall logsal wage big | |---------------------------------------------------------------------| 1. | 1 1 10 5 4 2.302585 2 0 | 2. | 1 2 20 5 5 2.995732 4 1 | 3. | 2 1 30 6 5.5 3.401197 5 1 | 4. | 2 2 30 7 5 3.401197 4.285714 1 | +---------------------------------------------------------------------+ . drop big . l +---------------------------------------------------------------+ | family person salary hours tall logsal wage | |---------------------------------------------------------------| 1. | 1 1 10 5 4 2.302585 2 | 2. | 1 2 20 5 5 2.995732 4 | 3. | 2 1 30 6 5.5 3.401197 5 | 4. | 2 2 30 7 5 3.401197 4.285714 | +---------------------------------------------------------------+ . keep family salary person hours tall . l +-----------------------------------------+ | family person salary hours tall | |-----------------------------------------| 1. | 1 1 10 5 4 | 2. | 1 2 20 5 5 | 3. | 2 1 30 6 5.5 | 4. | 2 2 30 7 5 | +-----------------------------------------+ . egen meansal=mean(salary) . l +---------------------------------------------------+ | family person salary hours tall meansal | |---------------------------------------------------| 1. | 1 1 10 5 4 22.5 | 2. | 1 2 20 5 5 22.5 | 3. | 2 1 30 6 5.5 22.5 | 4. | 2 2 30 7 5 22.5 | +---------------------------------------------------+ . by family: sum salary not sorted r(5); . sort family . by family: sum salary ---------------------------------------------------------------------------------------- -> family = 1 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- salary | 2 15 7.071068 10 20 ---------------------------------------------------------------------------------------- -> family = 2 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- salary | 2 30 0 30 30 . sum salary Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- salary | 4 22.5 9.574271 10 30 . egen msal=mean(salary), by(family) . l +----------------------------------------------------------+ | family person salary hours tall meansal msal | |----------------------------------------------------------| 1. | 1 1 10 5 4 22.5 15 | 2. | 1 2 20 5 5 22.5 15 | 3. | 2 1 30 6 5.5 22.5 30 | 4. | 2 2 30 7 5 22.5 30 | +----------------------------------------------------------+ . replace tall=3 if tall==4 (1 real change made) . l +----------------------------------------------------------+ | family person salary hours tall meansal msal | |----------------------------------------------------------| 1. | 1 1 10 5 3 22.5 15 | 2. | 1 2 20 5 5 22.5 15 | 3. | 2 1 30 6 5.5 22.5 30 | 4. | 2 2 30 7 5 22.5 30 | +----------------------------------------------------------+ . drop if tall>5 (1 observation deleted) . l +----------------------------------------------------------+ | family person salary hours tall meansal msal | |----------------------------------------------------------| 1. | 1 1 10 5 3 22.5 15 | 2. | 1 2 20 5 5 22.5 15 | 3. | 2 2 30 7 5 22.5 30 | +----------------------------------------------------------+ . drop if tall>=5 (2 observations deleted) . l +----------------------------------------------------------+ | family person salary hours tall meansal msal | |----------------------------------------------------------| 1. | 1 1 10 5 3 22.5 15 | +----------------------------------------------------------+ . log close name: log: C:\Users\Tim Gindling\Documents\Econ611\testing.log log type: text closed on: 14 Sep 2017, 18:23:31 ----------------------------------------------------------------------------------------