Forum Discussion

Copper Contributor

Mar 31, 2019

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

excel

Formulas and Functions

Macros and VBA

JKPieterse
Apr 01, 2019
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

Silver Contributor

Apr 01, 2019

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

ronbonexcel
Copper Contributor
Apr 01, 2019
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?
- JKPieterse
  Silver Contributor
  Apr 01, 2019
  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.