I am using Excel 2007
How I can use Chitest in Excel 2007 to test association of one variable with the other. For example:
Contracted disease Not contracted disease
Treated 40 60 100
Not treated 80 20 100
Total 120 80 200
How do I test to see if treated cases and not- contracted disease are associated?
Last edited by Dr.Appalayya; 09-15-2009 at 07:05 AM.
Hi,
=CHITEST(data1,data2) where data1 and data2 don't include totals.
The returned test statistic approaches 1 as the data sets become less independent.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
But the instructions say that actual and expected score should be given; do mean to say that the expected score is data 2?
Yes, that's correct - I'm unsure as to why excel's help describes it as expected score.
The chi-square test helps you determine if two discrete variables are associated:
If two variables are associated, the distribution of observations for one variable differs depending on the category of the second variable.
If two variables are independent, the distribution of observations for one variable is similar for all categories of the second variable.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks