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 No comments
{count} votes

14 answers

Sort by: Most helpful
  1. Anonymous
    2023-07-18T22:37:39+00:00

    The only problem is I need to have all the values in the input because in the end I am looking for intraclass correlation to see if they are nested of not within each team. Is there any way to do that without running an ANOVA?

    0 comments No comments
  2. Anonymous
    2023-07-19T01:33:04+00:00

    It will not affect the result.

    0 comments No comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

  4. Anonymous
    2023-07-22T04:42:52+00:00

    Hi,

    The idea of adding 0 for missing data allows the tool to run, but it also could have a negative impact on the answers. So, unfortunately, I don't have any additional solutions.

    0 comments No comments