<p><br/>不知道有人发过没?这个是个和s-plus类似的挂在excel的统计分析工具,大家觉得好就顶</p><p></p><p><font color="#ff3300" size="5">不错的资源！！！奖励三个金币。</font></p><p><font color="#ff3300" size="5">版主：coral033</font></p><p></p><p>PHStat2 is Windows software that assists you in learning the concepts of statistics while using Microsoft Excel 97, Microsoft Excel 2000, or later. PHStat2 allows you to perform many common types of statistical analyses working with and using the familiar Microsoft Excel interface. PHStat2 is an enhanced version of the original PHStat statistical add-in system. </p><p>PHStat2 contains many enhancements and improvements to the original PHStat system. If you have been a user of the original version, you will discover the following changes:</p><p>General enhancements:</p><p>Complete Help system available through PHStat menu and procedure dialog boxes.</p><p>Dialog boxes redesigned to Microsoft Excel 97 &amp; later standard.</p><p>Enhanced user data entry checking.</p><p>Elimination of splash screen upon loading.</p><p>PHStat menu reorganized by topic.</p><p>Quicker execution of procedures.</p><p>Redesigned and reformatted worksheets with color-keyed ranges (For more information, see the PHStat2 help topic "How PHStat2 Presents Its Results.")</p><p>Enhanced statistical procedures:</p><p>Box-and-Whisker Plot: Plots appear horizontally and in better proportion of length to width.</p><p>One-Way Tables &amp; Charts: Accepts frequency tables as well as raw data sets as the data.</p><p>Tukey-Kramer Procedure: Generates the necessary sample statistics and MSW value automatically. Means comparisons tabulated in list.</p><p>Simple Linear and Multiple Regression Procedures: Generates corrected residual plots on separate chart sheets.</p><p>New statistical procedures:</p><p>Chi-Square Test for the Variance: Performs the Chi-Square test for the variance on a new worksheet.</p><p>Dot Scale Diagram: Generates a dot scale diagram as a chart object on a new worksheet that also contains the numerical data plotted and a summary table of statistics.</p><p>Estimate for the Population Variance: Calculates the confidence interval estimate for the population variance and standard deviation on a new worksheet.</p><p>Frequency Distribution: Generates a table that contains frequency counts and percentage frequency values on a new worksheet. When used with a multiple group option, the frequency tables of each group are placed on separate worksheets. (This procedure enhances the tables generated by the Data Analysis Histogram tool.)</p><p>Histogram &amp; Polygons: Generates a frequency table and a histogram (as a chart object) on new worksheet and optionally generates polygons on separate chart sheets. When used with a multiple group option, the frequency table and histogram for each group is placed on a separate worksheet and the multiple group data are plotted together on the same polygons. (This procedure enhances the frequency tables and histograms generated by the Data Analysis Histogram tool.)</p><p>Stepwise Regression: Generates a stepwise regression analysis on a new worksheet using either the general stepwise, forward selection, or backward elimination methods.</p><p>PHStat2 revisions through version 2.1.3</p><p>Hypergeometric Probability Distribution: Table values generated corrected to show X = 0 to sample size, not X = 0 to population size.</p><p>Kruskal-Wallis Rank Test: Problem that lead to incorrect results when groups were of unequal sample sizes corrected. </p><p>Poisson Probability Distribution: Problem that did not allow non-integer values to be entered into Average/Expected No. of Successes corrected.</p><p>-------------------------------------------------------------------</p><p>Check the PHStat website www.prenhall.com/phsat for the latest updates and enhancements to PHStat2.</p><p>&nbsp;</p>

[此贴子已经被coral033于2009-3-3 22:52:20编辑过]

<br>coral033
&nbsp;金币&nbsp;+3
&nbsp;奖励不错的EXCEL插件！！奖励3个金币。&nbsp;2009-3-3 21:52:38