ExcelBanter - CHI SQUARE TEST

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - CHI SQUARE TEST (https://www.excelbanter.com/excel-worksheet-functions/31641-chi-square-test.html)

Hi,
I have a data of patients on which i have to apply Chi square test.
The data is in the following format:-

S NO. NO. OF DAYS ON INCIDENCE OF
PATIENT IS ON VENTILATION INFECTION
1. 9 INFECTED
2. 11 INFECTED
3. 4 NOT INFECTED
4. 8 INFECTED
5. 6 NOT INFECTED
6. 13 INFECTED
7. 12 INFECTED
8. 4 NOT INFECTED

The probability is higher in case of patient being on ventilation for a
longer period of time.
I want to apply Chi square test on the above data.If some body
can help me out.
Thanks in advance

Regards
Rajeev

Check out the following from U Mass:

http://www-unix.oit.umass.edu/~evagold/excel.html

It gives an example of thorough data analysis on a small sample of data
--
Gary's Student

"rajeev" wrote:

Hi,
I have a data of patients on which i have to apply Chi square test.
The data is in the following format:-

S NO. NO. OF DAYS ON INCIDENCE OF
PATIENT IS ON VENTILATION INFECTION
1. 9 INFECTED
2. 11 INFECTED
3. 4 NOT INFECTED
4. 8 INFECTED
5. 6 NOT INFECTED
6. 13 INFECTED
7. 12 INFECTED
8. 4 NOT INFECTED

The probability is higher in case of patient being on ventilation for a
longer period of time.
I want to apply Chi square test on the above data.If some body
can help me out.
Thanks in advance

Regards
Rajeev

If you are trying to test whether infection rate is independent of time
on ventilation, one way would be to set this up as a 2x2 contigency table
infected not infected
shorter ventilation 3 0
longer ventilation 0 5

You could then do either a chi-square (approximate) analysis of the
contingency table, or do Fisher's exact test.

Jerry

rajeev wrote:

Hi,
I have a data of patients on which i have to apply Chi square test.
The data is in the following format:-

S NO. NO. OF DAYS ON INCIDENCE OF
PATIENT IS ON VENTILATION INFECTION
1. 9 INFECTED
2. 11 INFECTED
3. 4 NOT INFECTED
4. 8 INFECTED
5. 6 NOT INFECTED
6. 13 INFECTED
7. 12 INFECTED
8. 4 NOT INFECTED

The probability is higher in case of patient being on ventilation for a
longer period of time.
I want to apply Chi square test on the above data.If some body
can help me out.
Thanks in advance

Regards
Rajeev