Product Design, Manufacturing & Innovation Resources
家 » 在线工具 » 统计表

统计表

当 MS Excel 没有公式可以自动计算统计信息时,本软件提供所有统计表格。所有这些表格均可免费下载为 Excel 文件。具体如下:

  • 威尔科克森秩和表
  • 曼-惠特尼表
  • Wilcoxon符号秩表
  • 运行测试表
  • Shapiro-Wilk 表
  • 单样本 Kolmogorov-Smirnov 表
  • 双样本 Kolmogorov-Smirnov 表
  • 学生化范围 q 表
  • 斯皮尔曼 Rho 表
  • Kendall’s 是的 table
  • 德宾-沃森表
  • 利利福斯桌
  • 单样本安德森-达林检验表
  • 双样本安德森-达林检验表
  • 皮尔逊相关系数表
  • 邓内特的桌子
  • 增强型迪基-富勒表
  • 恩格尔-格兰杰表

质量和制造工程师运用这些工具,通过严格的显著性测试来监控工艺稳定性并验证产品规格,具体包括:

  • 建立控制限值 统计过程控制 用于检测制造偏差。
  • 执行 方差分析 优化生产参数,减少浪费。
  • 当数据分布偏离正态分布时,进行非参数评估。
  • 验证科学研究中的实验结果,以确认材料性能改进的重要性。
学科: 统计学、质量工程、科学研究、生物统计学、社会科学。
Minitab、SPSS、Microsoft Excel 的免费替代品。
Statistics Tables compared with Minitab, SPSS and Microsoft Excel
统计表MinitabSPSSMicrosoft Excel
Tests and methods: The page lists 18 tables, including Wilcoxon rank-sum, Mann-Whitney, Shapiro-Wilk, Kolmogorov-Smirnov, Anderson-Darling, Durbin-Watson, Dunnett, studentized range q, Augmented Dickey-Fuller and Engle-Granger. They cover tests for which Excel has no built-in function.Tests and methods: Minitab lists t tests, proportion tests, normality tests, chi-square and equivalence tests, regression, control charts, measurement systems analysis, capability analysis, design of experiments, and reliability and life data analysis. It computes the results, whereas the tables only supply critical values.Tests and methods: SPSS Statistics lists inferential testing, regression including GLMs and mixed models, forecasting, decision trees, neural networks, bootstrapping and custom tables. Its scope is much broader than a set of lookup tables.Tests and methods: The Data Analysis ToolPak add-in provides 19 tools, among them single and two-factor ANOVA, correlation, descriptive statistics, histogram, regression, F-test, and t-tests and z-test for two samples. The tools work on one worksheet at a time.
Extension and integration: The tables are used with the Real Statistics Resource Pack, which adds worksheet functions such as LCRIT, QCRIT, DCRIT and ADCRIT to look up table values, usually with interpolation. The pack also adds data analysis tools not provided by Excel.Extension and integration: Minitab states that it can integrate with the open-source languages R and Python. Industry modules such as Healthcare, Supply Chain and Reliability are also offered.Extension and integration: IBM links a product article on using SPSS Statistics with R and Python. The page gives no technical detail on how the integration works.Extension and integration: The ToolPak is an add-in loaded into Excel, the same host application that the Real Statistics pack extends.
许可证和费用: The Real Statistics Resource Pack is offered as a free download. The author, Charles Zaiontz, also sells a book on the method, and no price for the pack is stated.许可证和费用: A free trial of select products is offered, and pricing is given on request. No price or licence term is listed on the product page.许可证和费用: IBM lists a base subscription per authorized user, with add-ons available separately. Pricing may vary by country. Perpetual, campus and student licences are also listed.
部署: Excel is required. Comments on the download page mention builds for Excel 2010 through 365, with separate Windows and Macintosh downloads.部署: Minitab is offered for use on the desktop or in the cloud.

涵盖的主题: Wilcoxon秩和检验表、Mann-Whitney检验表、Wilcoxon符号秩检验表、游程检验表、Shapiro-Wilk检验表、单样本Kolmogorov-Smirnov检验表、双样本Kolmogorov-Smirnov检验表、学生化极差q检验表、Spearman秩相关系数表、Kendall Tau相关系数表、Durbin-Watson检验表、Lilliefors检验表、单样本Anderson-Darling检验表、双样本Anderson-Darling检验表、Pearson相关系数表、Dunnett相关系数表、增广Dickey-Fuller相关系数表和Engle-Granger相关系数表。

更多的 计算, 数据分析与可视化 工具

请推荐您最喜欢的在线工具:

您是否知道有比上面列出的网站更好、更互补或可以替代的网站?

> 在此处提出建议 <

第十年 周年纪念日

只有注册会员才能免费获得 100% 的全尺寸图片和下载。.

> 登录 <