# ANCOVA Test in Excel

## What is ANCOVA?

Analysis of Covariance (ANCOVA) is used to compare means of an outcome variable between two or more groups taking into account (or to correct for) variability of other variables, called covariates (CV). ANCOVA allows to compare the adjusted means of two or more independent groups.

ANCOVA looks at the influence of two or more independent variables on a dependent variable, while removing the effect of the covariate factor.

## ANCOVA Step-by-Step Example

#### To perform a ANCOVA in Excel using QI Macros follow these steps:

- Click on the QI Macros menu > Stat Templates > ANOVA ANCOVA:
- Next, input the significance level you desire, found in cell C7. The default is 0.05 (95% confident):
- Finally, input your data, starting in cells B29:H29 and K29:Q29 - QI Macros will perform the calculations and analyze the results for you!

**Interprets the Results: **QI Macros performs the calculations AND tells you:

- If you can
__Reject Null Hypothesis__or__Cannot Reject Null Hypothesis__. - If the
__Means are Different__or the__Means are not different__.

*NOTE: The ANCOVA template is limited to 3-7 columns of data and 1,000 rows.*

### Why Choose QI Macros Statistical Software for Excel?

### Easy to Use

- Works Right in Excel
- Interprets p-values for You
- Accurate No-Worry Results
- Free Training Anytime

### Proven and Trusted

- 100,000 Users in 80 Countries
- Celebrating 20th Anniversary
- Five Star CNET Rating - Virus Free

### Affordable

- Only
**$349 USD**

Quantity Discounts Available - No annual fees
- Free Technical Support