Data Analysis with Microsoft Excel: Updated for Office 2007

568 Table Statistics The StatPlus>Descriptive Statistics>Table Statistics command creates a ta- ble of descriptive statist ...

Excel Reference 569 Univariate Statistics The StatPlus>Descriptive Statistics>Univariate Statistics command cre- ates a ta ...

570 One Sample z test The StatPlus>One Sample Tests>1 Sample z test command performs a one sample z test and calculates a ...

Excel Reference 571 One Sample Sign test The StatPlus>One Sample Tests>1 Sample Sign test command performs a one-sample Si ...

572 Two Sample Tests Two Sample t-test The StatPlus>Two Sample Tests>2 Sample t-test command performs a two sample t-test ...

Excel Reference 573 Two Sample z test The StatPlus>Two Sample Tests>2 Sample z-test command performs a two sample z test f ...

574 Multivariate Analyses Correlation Matrix The StatPlus>Multivariate Analysis>Correlation Matrix command creates a corre ...

Excel Reference 575 separate columns or within a single column alongside a column of category levels. The output includes a matr ...

576 Exponential Smoothing The StatPlus>Time Series>Exponential Smoothing command calculates one-, two-, or three-parameter ...

Excel Reference 577 Seasonal Adjustment The StatPlus>Time Series>Seasonal Adjustment command creates a col- umn of seasona ...

578 General Utilities Resolve StatPlus Links The StatPlus>General Utilities>Resolve StatPlus Links command redirects all S ...

Excel Reference 579 View Hidden Data The StatPlus>General Utilities>View Hidden Data command unhides all of the hidden wor ...

580 Chart Commands Label Chart Points The StatPlus>Label Series points command can be run when a chart is the active object i ...

Excel Reference 581 The following functions are available in Excel when StatPlus™ is loaded: Descriptive Statistics for One Vari ...

582 Descriptive Statistics for Two or More Variables Function Name Description CORRELP CORRELP(range1, range2) returns the p val ...

Excel Reference 583 Mathematical Formulas Function Name Description IF2FUNC IF2FUNC(Fname, IFRange1, IFValue1, IFRange2, IFValue ...

584 RANDGAMMA RANDGAMMA(alpha, beta) returns a random number from the gamma distribution with parameters alpha and beta. RANDINT ...

Excel Reference 585 MannW MannW(range, range2, [median]) calculates the Mann-Whitney test statistic for data values in two colum ...

586 WILCOXON WILCOXON(range, [median]) calculates the Wilcoxon Signed Rank statistic for values in the data column range. The me ...

Excel Reference 587 Bibliography Bliss, C. I. (1964). Statistics in Biology. New York: McGraw-Hill. Booth, D. E. (1985). Regress ...