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

In this article, we will do repeated measures ANOVA in Excel. Microsoft Excel is a powerful tool and makes complicated calculations easy. We can perform different types of data analysis with the help of this application. 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.


Download Practice Book

You can download the practice book from here.


Step-by-Step Procedures to Do Repeated Measures ANOVA in Excel

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-by-Step Procedures to Do Repeated Measures ANOVA in Excel


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.

Step-by-Step Procedures to Do Repeated Measures ANOVA in Excel

  • 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-by-Step Procedures to Do Repeated Measures ANOVA in Excel

Read More: How to Do Two Way ANOVA in Excel (With Easy Steps)


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.

Step-by-Step Procedures to Do Repeated Measures ANOVA in Excel

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

Step-by-Step Procedures to Do Repeated Measures ANOVA in Excel

  • Also, check the Labels.

Step-by-Step Procedures to Do Repeated Measures ANOVA in Excel


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.

Step-by-Step Procedures to Do Repeated Measures ANOVA in Excel

  • 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.


Similar Readings


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 Pvalue 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 Pvalue is 0.001266.
  • The Pvalue 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 (3 Ways)


Conclusion

In this article, we have discussed step-by-step procedures to Do Repeated Measures ANOVA in Excel. I hope this article will help you to perform your tasks efficiently. Furthermore, we have also added the practice book at the beginning of the article. To test your skills, you can download it to exercise. Also, you can visit the ExcelDemy website for more articles like this. Lastly, if you have any suggestions or queries, feel free to ask in the comment section below.


Related Articles

Mursalin

Mursalin

Hi there! This is Mursalin. I am an Excel and VBA content developer at ExcelDemy. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I am currently working and doing research on Microsoft Excel. Here I will be posting articles related to Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo