Step 4: Perform a one-way ANOVA on Exam Scores and Current Grade separately. Note: Cells B21:E28 display the formulas used to obtain the values in cells B13:E19.

Next, we will calculate the slopes of the regression lines of the exam scores for each studying technique. Step 3: Calculate the slopes of the regression lines. Next, calculate the mean and variance for each column: Step 2: Calculate the mean and variance for each column. Use the following steps to perform an ANCOVA on this dataset:įirst, input the data in the following format: The following table shows the dataset for the 15 students that were recruited to participate in the study: She will perform an ANCOVA using the following variables: Example: ANCOVA in ExcelĪ teacher wants to know if three different studying techniques have an impact on exam scores, but she wants to account for the current grade that the student already has in the class. This tutorial explains how to perform an ANCOVA in Excel. An ANCOVA (“analysis of covariance”) is used to determine whether or not there is a statistically significant difference between the means of three or more independent groups, after controlling for one or more covariates.

How to do an anova in excel 2007