Data Analysis Recalculation

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Regression function in 2007, Analysis Tool Pak 2
Can't get DATA ANALYSIS to show up 1
Recalculation of formulae disabled 2
Compute multiple data analyses at once 2
Data: select a cell x rows below the current, where x is designate 1
Analysis of 2 groups? 1
Full compliance with Code Analysis still possible when using LINQ? 1
Excel Excel 2003 Data Analysis Tool 1

Top