need help examining two variables and relating them to another (beginner help)

[Gabor Stevens]

I'm looking to examine both weekly earnings and the unemployment rate and then relate that to level of education and draw a conclusion. I'm having difficulty putting all of the information together.

If anyone can assist me that would be appreciated.

* Example generated by -dataex-. To install: ssc install dataex
clear
input byte unemployed float wklyearn byte(lessthanhs highschool somepost diploma bach)
0   2188.4 0 0 0 0 1
0   881.25 0 0 0 1 0
0  1109.25 0 0 0 0 1
0 2107.875 0 0 0 0 1
0      880 0 0 0 1 0
0     1298 0 0 0 0 1
0   2692.4 0 0 0 1 0
0   6317.4 0 0 0 0 1
0      880 0 0 0 0 1
0     1250 0 0 1 0 0
0  980.625 0 0 0 0 1
0     1440 0 0 0 1 0
0  1876.25 0 0 0 0 0
1        . 0 0 0 0 0
0 1268.995 0 0 0 0 1
0  3173.25 0 0 0 0 1
0      720 0 1 0 0 0
0   768.24 0 1 0 0 0
0      910 0 0 0 0 1
0     1827 0 0 0 0 1
0     1900 0 0 0 1 0
1        . 0 0 0 0 1
0     1400 0 1 0 0 0
0   900.55 0 0 0 0 1
0 1653.882 0 0 0 0 1
0      990 0 0 0 1 0
0     1240 0 1 0 0 0
0     1120 0 0 1 0 0
0    826.8 0 1 0 0 0
0     1470 0 0 0 0 1
0   2330.5 0 1 0 0 0
0   1507.2 0 1 0 0 0
0   1461.6 0 0 0 1 0
0   2221.2 0 0 0 0 0
0      875 0 0 0 0 1
0    461.6 0 0 0 1 0
0     1066 0 0 0 0 1
0   2692.4 0 0 0 0 0
0   1442.4 0 0 0 0 1
0     1750 0 0 0 0 0
0      600 1 0 0 0 0
0   1762.5 0 0 0 0 1
0   2884.8 0 0 0 0 0
0     1654 0 0 0 0 1
0   1125.2 0 0 1 0 0
0    172.2 1 0 0 0 0
0     1923 0 0 0 1 0
0    609.2 0 0 0 1 0
0      480 0 1 0 0 0
0     1923 0 0 0 0 1
0 1730.625 0 0 0 0 1
0      400 0 0 1 0 0
0     2500 0 0 0 0 1
1        . 0 0 0 1 0
0     1320 0 1 0 0 0
0     1425 0 0 0 0 1
0     1904 0 0 0 0 1
0   2884.8 0 0 0 1 0
0   1769.2 0 0 0 0 0
0  1326.85 0 0 0 1 0
0     1950 0 0 0 0 0
0      712 0 0 0 1 0
0      800 0 1 0 0 0
0   2884.5 0 1 0 0 0
0      304 0 1 0 0 0
0     1040 0 0 0 1 0
0      720 0 0 0 1 0
0   1087.5 0 0 0 1 0
0  1346.25 0 0 0 0 1
0   1091.6 0 0 0 1 0
0     1480 0 0 0 1 0
0      510 0 0 0 0 1
1        . 0 0 0 0 1
0      720 0 0 0 0 1
0   855.54 0 0 0 1 0
0      630 0 0 0 0 1
0      920 0 0 0 0 0
0    849.2 0 1 0 0 0
0     1310 0 0 0 0 1
0      960 0 0 0 1 0
0  1923.25 0 0 0 0 0
0    696.6 0 0 0 0 0
0     1520 0 0 0 1 0
0  615.375 1 0 0 0 0
0  1650.09 0 0 0 1 0
0  1153.95 0 0 0 0 1
0     1472 0 0 0 1 0
0  2307.75 0 1 0 0 0
0   1299.9 0 0 0 1 0
0     1596 0 0 0 0 1
0   3461.5 0 0 0 0 1
0      800 0 1 0 0 0
0      810 0 0 0 0 1
0   2875.2 0 0 0 0 1
0  1472.25 0 0 0 1 0
0      320 0 1 0 0 0
0      840 0 0 1 0 0
0  2307.75 0 0 0 0 0
0     1800 0 0 0 0 1
0      136 1 0 0 0 0
end

------------------ copy up to and including the previous line ------------------

Listed 100 out of 6031 observations
Use the count() option to list more

[Nick Cox]

Is this for an assignment? Please check out #4 at https://www.statalist.org/forums/help#adviceextras

[Gabor Stevens]

Is this for an assignment? Please check out #4 at https://www.statalist.org/forums/help#adviceextras

Nope just doing it for myself but perhaps I could have worded it better.

I can figure out the mean weekly earnings for level of education and I have found the unemployment rates by percentage per level of education, but I am just wondering if I can correlate these two values together, or if it would be possible to do it in a single command. So far I have just been typing

if highschool ==1
if grad ==1

but the variable educ contains information on all levels of education ranging from 1-6

Would it be possible to include this variable to make the code shorter or how would I go about incorporating it.

Thanks

[Nick Cox]

As I understand it, these are data for individuals, and unemployed and the various education variables are all (0, 1) indicators.

I would start with

poisson wklyearn unemployed less-bach , vce(robust)

bearing in mind arguments at https://blog.stata.com/2011/08/22/us...tell-a-friend/ and in say Jeff Wooldridge's texts.