Hi,
I have data on deaths. I need to calculate the mean &
CI of females in proportion to all population. Im
trying first to create a variable for each month then
take the total number of female per month and then
divide by total number of deaths per month.
This is my data.
.list count month year female male sex_unknown
+-------------------------------------------------+
count month year female male sex_un~n
-------------------------------------------------
1. 1 3 2003 0 0 1
2. 2 3 2003 0 1 0
3. 3 3 2003 0 1 0
4. 4 3 2003 0 1 0
5. 5 4 2003 1 0 0
-------------------------------------------------
6. 6 4 2003 0 0 1
7. 7 5 2003 0 0 1
8. 8 5 2003 0 0 1
9. 9 6 2003 0 0 1
10. 10 7 2003 0 0 1
-------------------------------------------------
11. 11 8 2003 0 0 1
12. 12 8 2003 0 0 1
13. 13 9 2003 0 0 1
14. 14 10 2003 0 0 1
15. 15 11 2003 0 0 1
-------------------------------------------------
16. 16 12 2003 0 0 1
17. 17 3 2004 0 0 1
18. 18 3 2004 0 0 1
19. 19 3 2004 0 0 1
20. 20 3 2004 0 0 1
-------------------------------------------------
21. 21 5 2004 0 0 1
22. 22 5 2004 0 0 1
23. 23 6 2004 0 0 1
24. 24 7 2004 0 0 1
25. 25 9 2004 0 0 1
Im somehow lost, since my data is per individula.
should I create a different dataset with montly deaths
only or can I calculate means and confidence intervals
in this same dataset.
Any help or suggestions are very much appreciated.
thanks,
Gaby
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
