Re: questions about chi square and g test

On Apr 16, 7:54 am, Ryan <Ryan.Andrew.Bl...@xxxxxxxxx> wrote:
On Apr 15, 8:54 pm, ouyang....@xxxxxxxxx wrote:



On Apr 15, 7:33 pm, Richard Ulrich <Rich.Ulr...@xxxxxxxxxxx> wrote:

On Tue, 15 Apr 2008 11:28:19 -0700 (PDT), ouyang....@xxxxxxxxx wrote:
Hi,
I am new to statistics. I got couple questions about chi square and g
independence test. For chi square test, how do I handle all zero
columns in cross tables? Should those columns be included in the
table? all zero columns will give zero expectation for cells in those
columns and cause divided by zero errors.. For g test, what to do if
some cells have zero observations? That will cause log of zero error.

For the ordinary contingency table, you drop
any rows or columns that total zero.

--
Rich Ulrich

http://www.pitt.edu/~wpilib/index.html

Thank you. How about zero cells in G test?- Hide quoted text -

- Show quoted text -

Same issue b/c: G=2?[O×ln(O/E)]

The only option I can think of would be to drop the cells.

Ryan

Or put a very small # in the cells I guess.
.

Relevant Pages

  • Re: Complex if
    ... all of the conditions are either empty, have text, or have the numerical value zero. ... it suggests that those cells that meet the conditions contain zero -- assuming that #2 and #3 return exactly zero. ... IF('Enroll I'!$K$2:$K$2921>0, Enroll I'!$L$2:$L$2921))))))) ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Find same value in continuous Cells
    ... I double checked my cells. ... The first zero value in this sheet occurs at E81 ... Dim Lastrow As Integer 'Last Row of Printing Range ...
    (microsoft.public.excel.programming)
  • RE: carry down total
    ... Now how do I get it not to reset to total to zero but be able to carry it to ... cruchnin numbers ... "Joel" wrote: ... tow cells inside the ANDare cells that contain the TRUE ...
    (microsoft.public.excel.misc)
  • RE: Find same value in continuous Cells
    ... I;ve been stepping through it and it looks like it is counting the cells ... with values other that zero but I don't know how to reverse it. ... Dim Lastrow As Integer 'Last Row of Printing Range ...
    (microsoft.public.excel.programming)
  • Re: Conditional Formatting Help
    ... There are only either these zero cells, ... "Bob I" wrote: ... for blank and set no formatting. ...
    (microsoft.public.excel.misc)
Loading