Question: how to do anova single factor in excel?
Answer: Click Data Analysis on the Data tab., From the Data Analysis popup, choose Anova: Single Factor., Under Input, select the ranges for all columns of data., In Grouped By, choose Columns., Check the Labels checkbox if you have meaningful variables labels in row 1.