hello there,
would appreciate help and advice to help me.
i have six columns of data. the first column is a string variable, the
second and third columns are numerical variables (year, population size n).
these first three columns would be my y-axis on the left. if it would help
make it easier, then i can combine these three columns into one column (e.g.
arthur 1999 30,000) . the fourth, fifth and sixth columns are lower limit of
the point estimate's 95% confidence interval, point estimates itself and the
upper limit of 95% confidence interval (e.g. 0.32(0.51)0.73). these last
columns' values would be my x-axis e.g. 0 - 0.8.
i would like to be able to produce line chart where the point estimate is
represented by e.g. a dot with a horizontal line running through it and where
the horizontal line represents the 95% confidence interval limit. ideally too
i would like the dot to be able to be 'weighted' e.g. corresponding
proportionately to the size of the population.
i tried using chart wizard and custom but somehow could not even get
anywhere near the results that i wanted. so any help, advice and suggestion
would be appreciated.
when i searched the knowledge base, the nearest post that comes to my
requirement was entitled 'forest plots' but it did not contain suggestions
that i might be able to use. i have also tried excellent jon peltier sites
but did not find pointers there as well that i could use.
i am using w98se with office97 but push come to shove, i can find wxp pro
sp2 and office xp.
again thank you for help, advice and suggestions that would help me.
kind regards,
josh
Bookmarks