Q:

# What is ANOVA in Excel?

A:

Analysis of variance, or ANOVA, is a statistical test that can be computed in EXCEL. A one-way ANOVA test is intended to test whether the means of several sets of numbers are all the same.

## Keep Learning

In EXCEL, the means to be tested are input and the program returns an F value, an F critical value and a p value. If F is greater than F critical, it means that the differences in the means are large enough to not be due to random chance and therefore the means are not all the same. If only two means are input into the ANOVA test, it returns the same result as a standard t test.

Sources:

## Related Questions

• A: Tips for passing an Excel test include reviewing concepts and functions through the program's support page on Office.com, taking practice tests to learn ab... Full Answer >
Filed Under:
• A: Microsoft offers a free training center for Excel as of 2015. The database includes courses for Excel on Windows, Mac OS, Android, iOS and Windows Phone. A... Full Answer >
Filed Under:
• A: To subtract in Excel, enter the numbers in a cell using the formula =x-y, complete the same formula using the column and row headings of two different cell... Full Answer >
Filed Under:
• A: Add values in Microsoft Excel using the SUM function =SUM ( Number1, Number2, ... Number255 ), which adds up columns or rows of numbers. "Number" represent... Full Answer >
Filed Under:
PEOPLE SEARCH FOR