Expand description
Analysis ToolPak (Data › Analysis › Data Analysis): statistical tools that compute a report from input ranges and write it as a static table (values, not formulas) to an output range or a new worksheet.
Every tool is one tool value of data.analysisToolPak. Distribution values (t, F) come
from the worksheet functions (T.DIST.2T, F.DIST.RT, T.INV.2T…), so the reports agree
with the formulas a user would write. Layouts follow Microsoft’s public description of the
tools (row labels and section titles); exact spacing is GridCraft’s reading of it.
Constants§
- OVERWRITE_
ERROR - Part of the error a programmatic call gets when the output range already holds data; the
dialog recognises it and asks before running again with
overwrite: true. - TOOLS
- (id, label) of every tool, in the order of Excel’s Analysis Tools list.