Product Design, Manufacturing & Innovation Resources
Lar » Ferramentas online » Tabelas estatísticas

Tabelas estatísticas

Provides all the statistical tables when MS Excel has no formula to compute it automatically. All these tables here are also downloadable for free as Excel files. Are here available:

  • Tabela de soma de postos de Wilcoxon
  • Tabela de Mann-Whitney
  • Tabela de postos sinalizados de Wilcoxon
  • Tabela de testes de execução
  • Tabelas de Shapiro-Wilk
  • Tabela de Kolmogorov-Smirnov de uma amostra
  • Tabela de Kolmogorov-Smirnov de duas amostras
  • Tabelas q de amplitude studentizada
  • Tabela Rho de Spearman
  • Kendall’s Tau table
  • Tabela de Durbin-Watson
  • Tabela Lilliefors
  • Tabela do teste de Anderson-Darling de uma amostra
  • Tabela do teste de Anderson-Darling para duas amostras
  • Tabela de correlação de Pearson
  • Mesa de Dunnett
  • Tabela Dickey-Fuller aumentada
  • Tabela de Engle-Granger

Quality and manufacturing engineers apply these tools to monitor process stability and validate product specifications through rigorous significance testing to:

  • Estabelecer limites de controle para statistical process control para detectar desvios de fabricação.
  • Conduta Análise de Variância Otimizar os parâmetros de produção e minimizar o desperdício.
  • Realize avaliações não paramétricas quando as distribuições de dados se desviarem da normalidade.
  • Validar resultados experimentais em pesquisas científicas para confirmar a importância das melhorias no desempenho dos materiais.
Disciplinas: Estatística, Engenharia da qualidade, Pesquisa científica, Bioestatística, Ciências sociais.
Alternativa gratuita ao Minitab, SPSS e Microsoft Excel.
Statistics Tables compared with Minitab, SPSS and Microsoft Excel
Tabelas estatísticasMinitabSPSSMicrosoft 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.
Licença e custo: 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.Licença e custo: 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.Licença e custo: 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.
Implantação: Excel is required. Comments on the download page mention builds for Excel 2010 through 365, with separate Windows and Macintosh downloads.Implantação: Minitab is offered for use on the desktop or in the cloud.

Tópicos abordados: Tabela de soma de postos de Wilcoxon, tabela de Mann-Whitney, tabela de postos com sinais de Wilcoxon, tabela de teste de sequências, tabelas de Shapiro-Wilk, tabela de Kolmogorov-Smirnov de uma amostra, tabela de Kolmogorov-Smirnov de duas amostras, tabelas de q de amplitude estudantil, tabela de Rho de Spearman, tabela de Tau de Kendall, tabela de Durbin-Watson, tabela de Lilliefors, tabela de teste de Anderson-Darling de uma amostra, tabela de teste de Anderson-Darling de duas amostras, tabela de correlação de Pearson, tabela de Dunnett, tabela de Dickey-Fuller aumentada e tabela de Engle-Granger.

Mais Cálculo, Análise e visualização de dados ferramentas

Sugira a melhor ferramenta online:

Você conhece um site melhor, complementar ou substituto para o listado acima?

> Sugira aqui <

10º ano aniversário

Imagens em tamanho real e downloads estão disponíveis apenas, 100% gratuitos, para membros registrados.