InstallHelp.txt
Data Analysis Plus v9 in VBA *NOTE: For best installation results, disable 'Data Analysis' (File>Options>Add-Ins> Disable 'Analysis ToolPack') before installing DAP. (then re-enable 'Data Analysis' after installing DAP) Supported on the following versions of Excel: > Microsoft Excel 97 - 2013 on Windows OS > Office 2001 for Mac OS > Office 2004 for Mac OS Data Analysis Plus v9 in VBA: Installation Steps for Excel 2007: 1. Copy 'Stats_2007-2013_v9b.xls' to the XLSTART folder. (i.e. x86 - 'C:\Program Files (x86)\Microsoft Office\Office12\XLSTART\Stats_2007-2013_v9b.xls') (i.e. x64 - 'C:\Program Files\Microsoft Office\Office12\XLSTART\Stats_2007-2013_v9b.xls') 2. Copy ' Stats_2007-2013_v9b.chm' to one folder above the XLSTART folder. (i.e. x86 - 'C:\Program Files (x86)\Microsoft Office\Office12\ Stats_2007-2013_v9b.chm') (i.e. x64 - 'C:\Program Files\Microsoft Office\Office12\ Stats_2007-2013_v9b.chm') OR Data Analysis Plus v9 in VBA: Installation Steps for Excel 2010: 1. Copy 'Stats_2007-2013_v9b.xls' to the XLSTART folder. (i.e. x86 - 'C:\Program Files (x86)\Microsoft Office\Office14\XLSTART\Stats_2007-2013_v9b.xls') (i.e. x64 - 'C:\Program Files\Microsoft Office\Office14\XLSTART\Stats_2007-2013_v9b.xls') 2. Copy 'Stats_2007-2013_v9b.chm' to one folder above the XLSTART folder. (i.e. x86 - 'C:\Program Files (x86)\Microsoft Office\Office14\Stats_2007-2013_v9b.chm') (i.e. x64 - 'C:\Program Files\Microsoft Office\Office14\Stats_2007-2013_v9b.chm') OR Data Analysis Plus v9 in VBA: Installation Steps for Excel 2013: 1. Copy 'Stats_2007-2013_v9b.xls' to the XLSTART folder. (i.e. x86 - 'C:\Program Files (x86)\Microsoft Office\Office15\XLSTART\Stats_2007-2013_v9b.xls') (i.e. x64 - 'C:\Program Files\Microsoft Office\Office15\XLSTART\Stats_2007-2013_v9b.xls') 2. Copy 'Stats_2007-2013_v9b.chm' to one folder above the XLSTART folder. (i.e. x86 - 'C:\Program Files (x86)\Microsoft Office\Office15\Stats_2007-2013_v9b.chm') (i.e. x64 - 'C:\Program Files\Microsoft Office\Office15\Stats_2007-2013_v9b.chm') *NOTE: With Excel 2013, the 'Data Analysis' macros must be disabled to run the 'Data Analysis Plus' macros !! OR Data Analysis Plus v9 in VBA: Installation Steps for Excel 2016: 1. Copy 'Stats_2007-2013_v9b.xls' to the XLSTART folder. (i.e. x86 - 'C:\Program Files (x86)\Microsoft Office\root\Office16\XLSTART\Stats_2007-2013_v9b.xls') (i.e. x64 - 'C:\Program Files\Microsoft Office\root\Office16\XLSTART\Stats_2007-2013_v9b.xls') 2. Copy 'Stats_2007-2013_v9b.chm' to one folder above the XLSTART folder. (i.e. x86 - 'C:\Program Files (x86)\Microsoft Office\Office16\Stats_2007-2013_v9b.chm') (i.e. x64 - 'C:\Program Files\Microsoft Office\Office16\Stats_2007-2013_v9b.chm') *NOTE: With Excel 2016, the 'Data Analysis' macros must be disabled to run the 'Data Analysis Plus' macros !! For additional help and support, visit www.KellerStatistics.com.
Stats_2007-2010_v9b.chm
» Bartlett's Test
Input Range: Specify 2 or more adjacent columns of numbers.
Labels: Click the box if the input range’s first rows contain the names of the variables.
Alpha: Alpha must be greater than 0 and less than 1.
© Copyright KellerStatistics.com 2010 - All Rights Reserved
» Box Plot
Input Range: Specify one column of numbers.
Labels: Click the box if the input range’s first row contains the name of the variable.
© Copyright KellerStatistics.com 2010 - All Rights Reserved
» Chi-Squared Test and Estimate: Variance