很不错的一个Excel插件,用Excel做统计分析推荐这个插件,完美兼容Excel 2007和2010版
PHStat2 is Windows software that assists you in learning the concepts of statistics while using Microsoft Excel. PHStat2 allows you to perform many common types of statistical analyses working with and using the familiar Microsoft Excel interface.
What's New in PHStat2?
PHStat2 is continually being enhanced. This is PHStat2 version 3.01.
Changes in version 3.0 since version 2.8.1
Elimination of the use of the Excel Data Analysis ToolPak add-ins.
Scatter Plot Procedure added.
Division of the Two-Sample Test submenu into Unsummarized Data and Summarized Data submenus.
Paired t Test Procedure added.
Pooled-Variance t Test Procedure for unsummarized data added
Separate-Variance t Test Procedure for unsummarized data added.
Two-Way ANOVA with replication Procedure added. (This procedure includes a Cell Means Plot output option.)
User-specified level of significance added to One-Way ANOVA Procedure.
Frequency Distribution, Histogram & Polygons, One-Way ANOVA, Two-Way ANOVA, Simple Linear Regression, Multiple Regression Procedures revised to create live worksheets.
Worksheet formatting enhanced and minor errors corrected.
(Version 3.0 breaks compatibility with Excel versions earlier than Excel 2003.)
Changes in version 2.8.1 since version 2.7
Box-and-Whisker Plot Procedure renamed Boxplot.
c Chart Procedure added.
F Test for Differences in Two Variances modified to eliminate the need for a Lower-Tail Test option.
Pareto Diagram output option of One-Way Tables & Charts renamed Pareto Chart. Pareto chart reformatted to start cumulative percentage graph at top of first bar (ASQ standard).
Separate-Variance t Test Procedure added.
t Test for Differences in Two Means Procedure renamed Pooled-Variance t Test.
Tukey-Kramer Procedure replaced by a new One-Way ANOVA Procedure with a Tukey-Kramer Procedure output option.
Relabeling of data values in Binomial, Hypergeometric, and Poisson Probability Distribution dialog boxes and worksheets.
Scatter Diagram output option of Simple Linear Regression procedure renamed Scatter Plot.
------------------------------------------------------------------------------------------------------------------------------------------
Check the PHStat website
www.prenhall.com/phstat for the latest updates and enhancements to PHStat2 or to seek technical support.