chi square using microsoft excel for outbreak investigation

Chi square using excel


Perform Chi square using Microsoft excel for outbreak investigation

What is Chi-Square Analysis? Chi-Square is a non-parametric analysis that enables the researcher to test the hypothesis about the data distribution for nominal or categorical data. How you can be performed this analysis of data for chi-square analysis using the excel. As you know some of the data analyst or researcher probably did not have the commercial software to compute the analysis of the chi-square.

This article, we are going to discuss the step by step analysis of chi-square in the ms excel. The importance of this analysis was to investigate the associated/ influential factors of the exposure to the status of health for the respondents. The chi-square analysis that is used will be the chi-square testing for the independence. To learn more and straightforward explanation, please refer to the videos as provided.

The data used for this exercise can be download here. The hypothesis steps for this analysis can be described as follows:

  1. State your null and alternative hypothesis
  2. State/ set your alpha values
  3. Run/ calculate (in this case, we are going to use the excel)
  4. Decision making (reject or fail to reject the null hypothesis)
  5. Making conclusion

Step 1:

Making your null and alternative hypothesis:

  1. Null: There is no significant association between the status of exposure with the status of health (between control and case)
  2. Alternative: There is a significant association between the status of exposure with the status of health (between control and case)

chi square using microsoft excel for outbreak investigation

Figure 1. Null and Alternative hypothesis

Step 2:

Setting up your alpha. Usually, the researcher is going to set the alpha will be 0.05


Step 3:

Run or calculate the chi-square values

Figure 2. Analysis steps of the chi-square

Step 4:

Making decision. In this example, we are going to reject our null hypothesis due to the fact that the p-value less than our alpha sets in step 2. Besides, we also will look into the value of the chi-square 4.13865 which is more than the levels of the alpha sets under the area under the curve (3.8415). Therefore we finally reject the null.


Step 5:

Making conclusion. Therefore, we are going to state that there is a significant association between the status of exposure with the status of health (between control and case). In this case, the orange drink was the probably factors that will influence the disease distribution of the outbreak.

Chi-Square Application in Disease Outbreak Investigation

The application of this analysis can be further checked or be calculated also using the Epi Info software. By doing this analysis, epidemiologist, public health officer or environmental health professionals, can further take actions towards the control of the spreading of disease or further investigate the process of making the food/ preparation of the drinks. To learn more about the data analysis using the chi-square statistics for outbreak investigation, please refer to this link.

If you got anything to discuss or comment on this article, feel free to contact us. We officer professional online courses for the SPSS and free statistical software. If you interested, please refer to this platform. We provide the video and online learning platform for you to learn about the data analysis for your research, professionals works, and business applications. Enjoy learning.

  1. admin

Leave a Reply

Your email address will not be published.