+ Reply to Thread
Results 1 to 2 of 2

Thread: Is it possible to create live anova table for excel

Hybrid View

  1. #1
    Points: 883, Level: 15
    Level completed: 83%, Points required for next Level: 17

    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Question Is it possible to create live anova table for excel

    Hi,
    I am chemist and running laboratory with more than 200 parameters.
    For all parameters, my team make 15*2 to 5(no of anayst) analysis to verify/validate methods.
    Therefore I need to use anova and t-test for their data sets.
    I have to update all data set at least once a year.
    I can make anova test or t-test from "data analysis" but it does not update when I update data sets.
    Is it possible to create live anova table, t-test table by using excel funtions. Which funtions are needed?

  2. #2
    Points: 1,974, Level: 26
    Level completed: 74%, Points required for next Level: 26

    Location
    New Zealand
    Posts
    227
    Thanks
    3
    Thanked 48 Times in 47 Posts

    Re: Is it possible to create live anova table for excel

    Yes. Which of the Excel anovas do you use?
    One way worth a try is to download the free add-in Real Statistics from http://www.real-statistics.com/free-download/ When this add-in does an anova the anova table uses Excel functions and the results change with the data.

+ Reply to Thread

           




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts






Advertise on Talk Stats