# How to Do Repeated Measures ANOVA in Excel (With Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will do repeated measures ANOVA in Excel. We can perform different types of data analysis with the help of Microsoft Excel. ANOVA stands for Analysis of Variance. In repeated measures ANOVA, we compare the means across one or more variables based on repeated observations. It determines the significant difference among the means of three or more groups. Today, we will show step-by-step procedures. Using these steps, you can efficiently perform repeated measures ANOVA in Excel.

## How to Do Repeated Measures ANOVA in Excel: Easy Steps

To explain the steps, we will use a dataset that contains information about the reaction time of 3 medicines in 5 patients. Here, the reaction time for medicines was measured 3 times for each patient. So, we will apply repeated measures ANOVA to check if the mean reaction time differs among drugs. Unfortunately, there is no default option or function to do the repeated measures ANOVA. But we can use the â€˜Anova: Two-Factor Without Replicationâ€™ option to get the repeated measures ANOVA.

### STEP 1: Open Data Analysis ToolPak

• In the first place, we need to open the Data Analysis ToolPak.
• To do that, go to the Data tab and select the Data Analysis option. It will open the Data Analysis dialog box.

• In the Data Analysis dialog box, select â€˜Anova: Two-Factor Without Replicationâ€™ and click OK to proceed.
• It will open the Anova: Two-Factor Without Replication dialog box. You need to insert the Input Range and Output Range in that box.

### STEP 2: Select Input Range

• Secondly, we will select the input range.
• For that purpose, click on the Input Range box and make sure the cursor is blinking.

• After that, select the desired input range with the headers. Here, we have selected the range B5:E10.

• Also, check the Labels.

### STEP 3: Choose Output Range

• Thirdly, you need to choose the output range. Itâ€™s the range where the results will appear.
• Now, select Output Range and click on the box of the Output Range.
• Make sure the cursor is blinking.

• In the following step, select the cell from where you want to start showing the results.
• We have selected Cell G3Â here.
• Similarly, you can also display them on a new sheet by selecting the â€˜New Worksheet Plyâ€™ option.
• Click OK to move forward.

### STEP 4: Review Summary Table

• After clicking OK, the summary table will appear on the sheet.
• You can see each patient and medicineâ€™s sum, average, and variance separately.

### STEP 5: Evaluate Repeated Measures ANOVA

• After watching the summary table, if you scroll down you can see the ANOVA table also.
• Here, you will find the value of SS, df, MS, F, P-value, and F crit for rows and columns.

### STEP 6: Analyze Results

• In our case, we will look for the F test-statistic value and the corresponding Pâ€“value for Columns.
• Because the value of the columns will tell us if the reaction time of the medicines differs.
• From the table, we can say that the F test-statistic value is 17.20633 which is less than the F critical value of 4.45897.
• Also, the corresponding Pâ€“value is 0.001266.
• The Pâ€“value is less than 0.05. Thatâ€™s why we can reject the null hypothesis.
• In conclusion, we can say that there is a significant difference in the reaction time of the medicines.

Read More: How to Interpret ANOVA Results in Excel

## Related Articles

<< Go Back to Anova in Excel | Excel for StatisticsÂ |Â Learn Excel

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mursalin Ibne Salehin

Mursalin Ibne Salehin holds a BSc in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. Over the past 2 years, he has actively contributed to the ExcelDemy project, where he authored over 150 articles. He has also led a team with content development works. Currently, he is working as a Reviewer in the ExcelDemy Project. He likes using and learning about Microsoft Office, especially Excel. He is interested in data analysis with Excel, machine learning,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF