Data analysis plus excel 2016 download

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

Input Range: Specify one column of numbers.
Hypothesized Variance: The specified value must be greater than 0.
Labels: Click the box if the input range’s first row contains the name of the variable.
Alpha: Alpha must be greater than 0 and less than 1.

© Copyright KellerStatistics.com 2010 - All Rights Reserved

» Chi-Squared Test of Normality

Input Range: Specify one column of numbers.
Labels: Click the box if the input range’s first row contains the name of the variable.
Alpha: Alpha must be greater than 0 and less than 1.

© Copyright KellerStatistics.com 2010 - All Rights Reserved

» Contingency Table

Input Range: Specify two or more equal-length columns of integers.
Labels: Click the box if the input range’s first columns and rows contain the names of the categories.
Alpha: Alpha must be greater than 0 and less than 1.

© Copyright KellerStatistics.com 2010 - All Rights Reserved

» Contingency Table (Raw Data)

Input Range: Specify two adjacent equal-length columns of integers greater than 0.
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

» Correlation

Input Range: Specify two adjacent equal-length 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

» Durbin Watson Statistic

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

» F-Estimate: Two Variances

Input Range1: Specify one column of numbers.
Input Range2: Specify one column of numbers.
Labels: Click the box if the input range’s first row contains the name of the variable.
Alpha: Alpha must be greater than 0 and less than 1.

© Copyright KellerStatistics.com 2010 - All Rights Reserved

» Friedman Test

Input Range: Specify two or more adjacent equal-length 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

» Kruskal-Wallis Test

Input Range: Specify two 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

Data Analysis Plus v9.0

This help file has been compiled to assist users of the Data Analysis Plus v9.0 macros for Microsoft Excel. Use the table of contents or index functions to locate a help information for a specific macro.