+ Reply to Thread
Results 1 to 2 of 2

Any way to compute 2-way unbalanced ANOVA in Excel?

  1. #1
    Registered User
    Join Date
    06-10-2016
    Location
    france
    MS-Off Ver
    2013
    Posts
    1

    Any way to compute 2-way unbalanced ANOVA in Excel?

    Hi everyone!

    I've been using the Excel Analysis Toolpak to perform 2-way ANOVAs. Problem is the feature does not allow for unbalanced data, which I often have.
    Does anybody have any hint on how to solve the problem?

    Cheers

  2. #2
    Registered User
    Join Date
    12-08-2014
    Location
    Paris
    MS-Off Ver
    2013
    Posts
    3

    Re: Any way to compute 2-way unbalanced ANOVA in Excel?

    Hi Mr. Nicolas
    I know the trick. The free version of XLSTAT allows to run anova on unbalanced designs and to include 2 way interactions. If you do not know the tool, you can get it at http://www.xlstat.com
    Cheers
    Camille

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] unbalanced data in ANOVA
    By Jerry W. Lewis in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-06-2005, 09:05 PM
  2. unbalanced data in ANOVA
    By The student in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  3. [SOLVED] unbalanced data in ANOVA
    By The student in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  4. unbalanced data in ANOVA
    By Jerry W. Lewis in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 05:05 AM
  5. [SOLVED] unbalanced data in ANOVA
    By The student in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  6. [SOLVED] unbalanced data in ANOVA
    By The student in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. unbalanced data in ANOVA
    By The student in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  8. unbalanced data in ANOVA
    By The student in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1