Product Design, Manufacturing & Innovation Resources
Casa » Strumenti online » Statistics Tables

Statistics Tables

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:

  • Wilcoxon Rank-Sum table
  • Mann-Whitney table
  • Wilcoxon Signed-Ranks table
  • Runs Test table
  • Shapiro-Wilk tables
  • One-Sample Kolmogorov-Smirnov table
  • Two-Sample Kolmogorov-Smirnov table
  • Studentized Range q tables
  • Spearman’s Rho table
  • Kendall’s SÌ table
  • Durbin-Watson table
  • Lilliefors table
  • One-Sample Anderson-Darling Test table
  • Two-Sample Anderson-Darling Test table
  • Pearson’s Correlation table
  • Dunnett’s table
  • Augmented Dickey-Fuller table
  • Engle-Granger table

Gli ingegneri addetti alla qualità e alla produzione applicano questi strumenti per monitorare la stabilità del processo e convalidare le specifiche del prodotto attraverso rigorosi test di significatività per:

  • Stabilire limiti di controllo per controllo statistico di processo per rilevare le deviazioni di fabbricazione.
  • Condotta Analisi della varianza per ottimizzare i parametri di produzione e ridurre al minimo gli sprechi.
  • Eseguire valutazioni non parametriche quando le distribuzioni dei dati si discostano dalla normalità.
  • Convalidare i risultati sperimentali nella ricerca scientifica per confermare l'importanza dei miglioramenti delle prestazioni dei materiali.
Discipline: Statistica, Ingegneria della qualità, Ricerca scientifica, Biostatistica, Scienze sociali.
Alternativa gratuita a Minitab, SPSS e Microsoft Excel.
Statistics Tables compared with Minitab, SPSS and Microsoft Excel
Statistics TablesMinitabSPSSMicrosoft 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.
Licence and cost: 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.Licence and cost: 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.Licence and cost: 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.
Implementazione: Excel is required. Comments on the download page mention builds for Excel 2010 through 365, with separate Windows and Macintosh downloads.Implementazione: Minitab is offered for use on the desktop or in the cloud.

Argomenti trattati: Tabella di Wilcoxon Rank-Sum, tabella di Mann-Whitney, tabella di Wilcoxon Signed-Ranks, tabella del test Runs, tabelle di Shapiro-Wilk, tabella di Kolmogorov-Smirnov a un campione, tabella di Kolmogorov-Smirnov a due campioni, tabelle di q di intervallo studentizzato, tabella di Rho di Spearman, tabella di Tau di Kendall, tabella di Durbin-Watson, tabella di Lilliefors, tabella del test di Anderson-Darling a un campione, tabella del test di Anderson-Darling a due campioni, tabella di correlazione di Pearson, tabella di Dunnett, tabella di Dickey-Fuller aumentata e tabella di Engle-Granger.

Di più Calcolo, Analisi e visualizzazione dei dati strumenti

Suggerisci il tuo strumento online preferito:

Conosci un sito web migliore, complementare o sostitutivo di quello elencato sopra?

> Suggeriscilo qui <

decimo anno anniversario

Le immagini a grandezza naturale e i download sono disponibili, gratuitamente al 100%, solo per gli utenti registrati.

> Login <