Results 1 to 5 of 5

Thread: Need help to perform scheffe test in Excel

  1. #1
    Join Date
    Nov 2011
    Posts
    166

    Need help to perform scheffe test in Excel

    I am trying to do a scheffe's test in Excel and getting nowhere. Anyone know how.

  2. #2
    Join Date
    May 2011
    Posts
    523

    Re: Need help to perform scheffe test in Excel

    Try to read the link below. Try to read the link below.

    Ftest in Excel

  3. #3
    Join Date
    Aug 2011
    Posts
    695

    Re: Need help to perform scheffe test in Excel

    To check whether two independent random samples derived stem from a common, normally distributed population, the first equality or homogeneity of variances to be checked. The F-test for a possible test.

  4. #4
    Join Date
    Nov 2009
    Posts
    612

    Re: Need help to perform scheffe test in Excel

    The scheffe test is most of the time complained about being to conservative. You can also try out the Student-Newman-Kuels but it is also complained about in the literature and texts which is too liberal. Can you tell us if you are doing these calculations by hand calculator? You can try to get to SPSS and entext the data that you have and use Ryan procedure which is also called REGWQ test.

  5. #5
    Join Date
    Dec 2007
    Posts
    2,291

    Re: Need help to perform scheffe test in Excel

    The Scheffe' test is customarily used with unequal sample sizes, although it could be used with equal sample sizes. The critical value for the Scheffe' test is the degrees of freedom for the between variance times the critical value for the one-way ANOVA. This simplifies to be:
    CV = (k-1) F(k-1,N-k,alpha)

    The test statistic is a little bit harder to compute. Test Statistic for Scheffe'Pure mathematicians will argue that this shouldn't be called F because it doesn't have an F distribution (it's the degrees of freedom times an F), but we'll live it with it.

    More information can be found on this link.

Similar Threads

  1. Does Excel has Kruskal-Wallis Test
    By Kumar esan in forum MS Office Support
    Replies: 2
    Last Post: 17-02-2012, 04:32 PM
  2. How to pass Microsoft Excel test.
    By Shaina Na in forum Education Career and Job Discussions
    Replies: 2
    Last Post: 06-01-2012, 02:51 PM
  3. How to perform internet speed test with command line?
    By Ikshana in forum India BroadBand
    Replies: 5
    Last Post: 05-04-2011, 10:27 AM
  4. To perform test on ZFS RAID-Z with 4K sector drives
    By quentein in forum Hardware Peripherals
    Replies: 3
    Last Post: 21-11-2010, 12:18 AM
  5. How to perform calculations with conditions in Excel ?
    By Luis234 in forum Software Development
    Replies: 3
    Last Post: 06-02-2009, 12:44 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,708,631,730.61623 seconds with 17 queries