# Comparing 2 surveys

This question was posted the Assessment and Surveillance forum area and has 10 replies.

### Anonymous 402

Normal user

1 Aug 2012, 19:41

### Mark Myatt

Frequent user

2 Aug 2012, 08:52

### Tamsin

Forum Moderator, ENN

Forum moderator

2 Aug 2012, 15:12

*From Bradley Woodruff:*First of all, the sampling method influences only the precision. If done correctly, the sampling method does not change the actual point estimate. For example, let's say you do one survey of nutrition status in pre-school age children in a population using cluster sampling of households, and you include every eligible child in selected households. In another survey of the same population, you use simple random sampling of eligible children. If the prevalence of some nutrition outcome, for example, wasting, has not changed between the surveys, the 2 surveys should produce similar estimates of prevalence. The only thing different between the results will be the precision obtained. If the prevalence of wasting obtained by the 2 surveys was 10%, the first survey might have 95% confidence intervals of 6% and 14%, while the second survey might have 95% confidence intervals of 8% and 12%. This is because cluster sampling usually results in a loss of precision. But if your sampling is unbiased, the point estimates should be similar. The best way to compare the results of surveys is to put the data from both surveys into one dataset. Be sure each child is identified with a cluster number (in the case of non-cluster sampling, each child will have his/her own cluster number because the cluster size is 1). Also assign to each child some code to identify if the child is from survey #1 or survey #2. Then do crosstabulations of survey number by nutrition outcome. The computer, if you are using an appropriate computer program which can account for cluster sampling, should give you a p value for the difference between the results of the 2 surveys. Of course, often you do not have the raw data to put into the same dataset. In this case, many programs will allow you to enter for the 2 surveys the estimates of prevalence along with some measure of precision for each survey, such as standard error or confidence intervals. The program will then compute a p value or some other measure of the statistical significance of the difference between the 2 surveys. Do NOT just compare the confidence intervals of the 2 surveys. This is a very common mistake. Overlap of the confidence intervals from the 2 surveys does NOT mean that the difference is not statistically significant. However, lack of overlap does mean that the difference IS statistically significant. If you rule out statistical significance because confidence intervals overlap, you are underestimating the precision of your comparison. The statistical reason for this is that in calculating the p value for the difference between 2 survey results, you need to use the weighted pooled estimate of the variances for the 2 surveys because under the null hypothesis that there is no actual difference between the surveys, you assume that the variances for the 2 surveys is the same. Nonetheless, as a quick screen, you can compare the confidence intervals, but you must keep in mind that if they DO overlap, then you can make no conclusions about the statistical significance of the difference and you must calculate the specific p value for this difference, either by hand or by using a computer program.

### Mark Myatt

Frequent user

4 Aug 2012, 11:47

*conservative*(i.e. low power) test. This means that it has a tendency to not rejecting the null hypothesis when differences are not very large. The link I sent above takes the (more correct) approach outlined by Woody (above).

### Mark Myatt

Frequent user

2 Sep 2013, 08:40

### Tamsin

Forum Moderator, ENN

Forum moderator

3 Sep 2013, 09:27

*From Kevin:*Hi Mark- our IT group changed the address - the new address is: Web1.sph.emory.edu/cdckms

### Mark Myatt

Frequent user

3 Sep 2013, 10:37

### chandrashekhar T Sreeramareddy

International Medical University

Normal user

2 Apr 2023, 06:58

Dear All

Now i am contended with replying a reviewer comment about change in survey prevalence estimated between two years. I have cited the weblink on this post. The webcalculator is not working anymore. Can anyone help me provide the link that works.

Thank you in advance

Chanadrshekhar Sreeramareddy

### Mark Myatt

Frequent user

4 Apr 2023, 11:15

Hello,

I got in touch with Kevin Sullivan. He is, I think, no longer at Emory and cannot provide an working link. He sent me an Excel file that does teh calculations needed. I have put it here.

### chandrashekhar T Sreeramareddy

International Medical University

Normal user

4 Apr 2023, 23:52

Dear Moderator,

Many thanks for helping me get the excel sheet. It helps a lot.

Regards

Chandrashekhar

### Mark Myatt

Frequent user

5 Apr 2023, 10:03

Goob. I am happy to have neem able to help.

BTW ... I used to be a moderator here nut I am now just a member.

If you have any problem posting a response, please contact the moderator at post@en-net.org.