This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
Hi Michael,
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?
Will this affect the value of the output? I don't want it to affect the overall output the blank cell really just represents an n/a.
To use Excel's Analysis ToolPak "Two-Factor ANOVA without Replication" you need an observed value for each combination of the two factors.
You have useful values only for the row effect Competition 1,2,3,4 and column effect Person 1,3,4,7,8,10, i.e., 4 rows by 6 columns.
If you rearrange your data and include labels, your input range will be five rows by seven columns (with an empty cell in the top left corner), e.g., A1:G5.
Add zero to blank cells. Then it will work.
For the first group I have excluded person 2 in the anova as they do not have an data points whatsoever.