+ Reply to Thread
Results 1 to 2 of 2

Weird message when trying to run a two way ANOVA

  1. #1
    Registered User
    Join Date
    07-11-2014
    Location
    Moscow, ID
    MS-Off Ver
    2013
    Posts
    6

    Weird message when trying to run a two way ANOVA

    I am trying to run a two-way ANOVA with repeated measures. Tried running it in excel but keep getting a message "Anova: Two-Factor With Replication - Each sample must contain the same number of rows". The problem is that they already have the same number of rows. I created a video with the steps that I take and the message that I get. This is driving me crazy and makes not sense. I am sure I must be missing something. Any help would be appreciated.

    https://youtu.be/KIxbDT8rq1A

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Weird message when trying to run a two way ANOVA

    Just looking at the difference between your video and the video from StatisticShowTo.com it looks as if yours needs:
    1) a column header for column A
    2) the size of the output range to match the size of the input range. So that if the Input range became A1:C29 (perhaps without the sub headings in row 2) the output range should possibly be D1:F29
    If these changes don't help I would suggest uploading the workbook from the video by clicking on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. weird error message -
    By zazzz in forum Excel General
    Replies: 5
    Last Post: 01-06-2016, 10:52 AM
  2. ANoVA Help!
    By filippobarde in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-10-2013, 12:24 PM
  3. Two-Way Anova Analysis,Add-ins
    By Ganivada in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-24-2009, 05:35 PM
  4. two-way ANOVA
    By Andy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2006, 11:35 PM
  5. unbalanced data in ANOVA
    By The student in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  6. [SOLVED] ANOVA
    By Angel in forum Excel General
    Replies: 1
    Last Post: 08-31-2005, 04: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