+ Reply to Thread
Results 1 to 3 of 3

anova keeps saying I have non-numeric data

  1. #1
    Forum Contributor
    Join Date
    02-28-2013
    Location
    NY, USA
    MS-Off Ver
    Excel 2019
    Posts
    101

    anova keeps saying I have non-numeric data

    Need help in performing ANOVA analysis, as it was clear that I was doing something wrong because I kept receiving the error "input ranges contain non-numeric data".

    I have six groups of samples and am trying to compare the mean among the six groups.
    I select the samples (A1: F220) and use Data Analysis add-on in EXCEL to do ANOVA.
    The same error of "input ranges contain non-numeric data" keeps showing up.

    Where did I make a mistake in my performing the ANOVA analysis ?

    Please see attachment for the data.

    ps. I was able to perform ANOVA if I omit the headings and select only (A2:F220). From youtube videos, I thought it's okay to include the heading. Any idea why including the heading would give me the error message ?
    Attached Files Attached Files
    Last edited by seraphin; 01-22-2019 at 06:30 PM. Reason: attachment is needed

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: anova keeps saying I have non-numeric data

    I think you may have forgotten to check the "Labels in First Row" check box.

    It ran fine for me with the headers include and the check box checked.
    HTH
    Regards, Jeff

  3. #3
    Forum Contributor
    Join Date
    02-28-2013
    Location
    NY, USA
    MS-Off Ver
    Excel 2019
    Posts
    101

    Re: anova keeps saying I have non-numeric data


    My apologies for missing the check box.

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

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