Share via

ANOVA with Two-Factor Without Replication - Contains non-numeric data

Anonymous
2023-07-17T18:24:54+00:00

Hello,

I am trying to run a ANOVA with two-factor without replication, however, I keep getting this alert that my input contains non-numeric data. I have tried to format it as a number and by using the text to column function but nothing seems to work. I do have data missing in my table but there is at least one values in each row (so I should be okay). I looking to find the ICC therefore I need the ANOVA information to do so. Please help.

Microsoft 365 and Office | Excel | For education | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

14 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-07-18T03:26:13+00:00

    Hi,

    Here are two possible reasons you are getting that error message:

    1. Your range has titles at the top which are being included but Labels in unchecked.

    1. Your data looks like numbers but the cells into which they were entered were formatted as Text. The easiest way to take care of this problem is to select a blank cell and copy it. Then select all your data cells (not the titles) and choose Paste, Paste Special, Add, OK.

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-07-18T20:22:53+00:00

    The ANOVA "rows sum of squares" calculation involves matrix multiplication and for this it requires data in all cells. Here is a formula equivalent calculation:

    =SUMSQ(MMULT(E4:H11,ROW(1:4)^0))/COUNT(E4:H4)-SUM(E4:H11)^2/COUNT(E4:H11)

    The problem lies in the MMULT(E4:H11,ROW(1:4)^0) portion which evaluates to #VALUE!

    This is interesting because you can calculate the internal components and MMULT will make a calculation and the whole formula will return a result. However,

    Microsoft say: MMULT returns the #VALUE! error when:

    • Any cells are empty or contain text
    • ....

    hence our ANOVA calculation fails.

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2023-07-18T03:10:04+00:00

    Could you share a screenshot of your data and issue? It will help to reproduce your issue and find the cause.

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2023-07-18T18:55:57+00:00

    Hi Shane,

    Yes the label box is checked when I try to run the ANOVA. Additionally, I tried the copy and paste but still no good.

    0 comments
  5. Anonymous
    2023-07-18T18:53:41+00:00

    Hello,

    Here is a screenshot of what my data looks like. I have a feeling it is due to the blank cells but I cannot fill or remove the the blank cells. Not all participants completed during competition but I need to have the data for the ones that do. I don't know if that makes sense. I am ultimately looking for the ICCs for each individual grouping (I.e., they are different teams). However, I still keep getting the non-numeric input alert.

    Please let me know if you have more questions.

    0 comments