Mar 31 2019 08:01 PM
Hi everyone,
I am trying to run Anova single factor calculation for three different groups. I want to see how the anova values change when I edit the group values. Is there a way for excel to auto-update the anova calculation when I make changes to values? I tried searching online and found a Reddit post(https://www.reddit.com/r/excel/comments/4x9al9/is_there_a_way_to_make_an_anova_calculation/). They mention VBA macros as a possible solution but didn't elaborate. Can someone help write one for me or direct me to a site that can quickly show me how? Thanks!
Apr 01 2019 02:28 AM
SolutionApr 01 2019 10:47 AM - edited Apr 01 2019 10:47 AM
@Jan Karel Pieterse Thanks for the suggestion! I might end up just writing out the formulas, but I was wondering if there was any way to accomplish this using the built-in ANOVA data analysis tool?
Apr 01 2019 10:51 PM
Apr 01 2019 02:28 AM
Solution