Data Analysis Recalculation

[reno]

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

 

[Mike Middleton]

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