Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Analysis Recalculation
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Analysis Recalculation
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 "reno" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
data analysis option not visible | Excel Worksheet Functions | |||
Recalculating a Regression Output in Data Analysis | Excel Worksheet Functions | |||
statistics - data analysis tool | Excel Worksheet Functions | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |