Hello all
I am doing some time series stuff (using R to do interrupted time series analysis - long story) but i have a rate for each year as follows:
year denominator Numerator rate
2004 1117648 18869 16.88277
2005 1135836 19209 16.91177
2006 1149597 18915 16.45359
2007 1153828 18610 16.12892
2008 1164451 17741 15.23551
2009 1156125 16008 13.84625
2010 1127019 13940 12.36891
2011 1111166 12502 11.25124
2012 1070343 10439 9.752949
2013 973473 8364 8.591918
rate = numerator/denominator *1000
I want to calculate the rate and 95% CI for each year. I know to use ci command:
. cii proportions 1117648 18869
-- Binomial Exact --
Variable | Obs Proportion Std. Err. [95% Conf. Interval]
-------------+---------------------------------------------------------------
| 1,117,648 .0168828 .0001219 .0166447 .0171233
but I want to know how to do it for each year 2004 to 2013 without having to enter this for every year. Is there a command that can summarise it? I have a few tables i need rate and CI for!
Thanks
Richard
Related Posts with Calculating rate and confidence interval for a series of data.
Splitting stringsI have a string variable containing licence plates, names and dates separated by / . As in 122000200…
Likelihood ratio interpretation Accelerated Failure Time Survival AnalysisHi there, In my research on the survival of strategies within private equity I'm using an accelerat…
questions about gologit2 command*and related modelsHi, I want to ask some questions about gologit2 command and partial proportional odds model. Here's…
When trimming variables are feasible?Hello everybody, this is my first publication so if i'm writing in the wrong area, i'm sorry. i'm d…
comparing multiple variables from two datasets without IDDear Stata friends, Following Scenario: I have to Datasets with four variables each: Schoolname, Ad…
Subscribe to:
Post Comments (Atom)
0 Response to Calculating rate and confidence interval for a series of data.
Post a Comment