Forum Discussion
ronbonexcel
Apr 01, 2019Copper Contributor
Update ANOVA calculation with new values
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!
3 Replies
Sort By
- JKPieterseSilver ContributorMaybe this helps? https://www.youtube.com/watch?v=Ke9ttUj7AQc
Also, please upvote this suggestion:
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10770396-formulas-for-analysis-toolpak-regression-tool-si- ronbonexcelCopper Contributor
JKPieterse 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?
- JKPieterseSilver ContributorNo, the Analisys Toolpak add-in only spits out static results. Hence the referral to the Uservoice link, it is high time they update that tool so it delivers formula based results.