Re: Significance testing of Dependent proportions



On 15 Sep 2005 10:42:41 -0700, "Hari" <excel_hari@xxxxxxxxx> wrote:

> Hi,
>
> I want to do a test in MS Excel which can do significance testing of 2
> dependent proportions. I pursued some of the web-sites like (Statsoft)
> but didint get anything which i wanted.
>
> (Some time back I got a link from this group for doing significant
> testing of independent proportions
> http://www.gseis.ucla.edu/courses/ed230a2/notes3/portion.html )
>

I think you want McNemar's test for changes, if it is
a 2x2 table. I have nothing to say about Excel.

There are generalizations of McNemar's, for larger tables,
considering "improvements" or "any changes".

--
Rich Ulrich, wpilib@xxxxxxxx
http://www.pitt.edu/~wpilib/index.html
.



Relevant Pages

  • Significance testing of Dependent proportions
    ... I want to do a test in MS Excel which can do significance testing of 2 ... dependent proportions. ... I pursued some of the web-sites like (Statsoft) ...
    (sci.stat.consult)
  • Re: Significance testing of Dependent proportions
    ... > wanted to do significance testing of Independent proportions ( ... >>Are you asking how to partition the overall chi-square into orthogonal components? ... I'm with Bruce, ... The use of the term "dependent proportions" has come ...
    (sci.stat.consult)