Data Analysis Recalculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

running analysis tool pak, the t-Test: paired two-sample for means. if he
underlying data changes, i.e., you copy new date into older sheet and
re-name, since all the formulae etc are the same, but you have re-select the
data for analysis. can't this be "turned on" to re-calc like any other
formula?

Thanks
 
reno -

The results of the Analysis ToolPak tools are static.

However, there are formulas and equivalent worksheet functions (AVERAGE,
TDIST, TINV, etc.) that you could use to obtain dynamic results.

- Mike
http://www.mikemiddleton.com
 
Back
Top