Forum Discussion
Solved
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 aut...
- Maybe 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
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?
No, 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.