#1   Report Post  
rajeev
 
Posts: n/a
Default CHI SQUARE TEST

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

  #2   Report Post  
Gary's Student
 
Posts: n/a
Default

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


  #3   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I use excell to draw a rectangle and come up with square feet Paul Excel Worksheet Functions 6 May 13th 05 02:18 AM
Statistic: Problem with two one sided t-test Rosario Excel Discussion (Misc queries) 4 May 5th 05 05:23 PM
Excel competency test jonesr2 Excel Discussion (Misc queries) 2 March 14th 05 09:37 PM
=IF logical test to search only part of a cell Robbie in Houston Excel Worksheet Functions 2 March 5th 05 05:09 AM
test..where are my messages..test HT New Users to Excel 0 January 23rd 05 06:23 PM


All times are GMT +1. The time now is 12:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"