Statistical analysis in Google Sheets, with functions matching the Analysis ToolPak in desktop Excel.
Fiche mise à jour le :21 mai 2024
Compatible avec :
3 M+
Présentation
With the XLMiner Analysis ToolPak Add-on, you can easily perform statistical analyses of the same types available in the Analysis ToolPak add-in that has been part of Microsoft Excel for over 20 years, and has been featured in large numbers of textbooks, videos, statistics courses and the like.

The add-on provides all 19 interactive functions included in the Excel Analysis ToolPak, plus a 20th function often requested by users, logistic regression.  Sidebar input fields and output on the spreadsheet will be very familiar to Excel Analysis ToolPak users.

The 20 functions are:
ANOVA: Single Factor
ANOVA: Two-Factor with Replication
ANOVA: Two-Factor without Replication
Correlation
Covariance
Descriptive Statistics
Exponential Smoothing
F-Test Two-Sample for Variances
Fourier Analysis
Histogram
Linear Regression
Logistic Regression
Moving Average
Random Number Generation
Rank and Percentile
Sampling
t-Test: Paired Two-Sample for Means
t-Test: Two-Sample Assuming Equal Variances
t-Test: Two-Sample Assuming Unequal Variances
z-Test: Paired Two-Sample for Means

Results will generally match the Excel Analysis ToolPak, as seen in many textbooks, screen images and videos.  The add-on's Random Number Generation function uses the Mersenne Twister algorithm.
Informations supplémentaires
TarifsSans frais
Règles de confidentialité
Conditions d'utilisation
XLMiner Analysis ToolPak vous demandera les autorisations ci-dessous. En savoir plus
XLMiner Analysis ToolPak aura besoin d'accéder à votre compte Google
XLMiner Analysis ToolPak pourra ainsi effectuer les actions suivantes :
Afficher et diffuser du contenu Web tiers dans les invites et les barres latérales au sein des applications Google
Afficher l'adresse e-mail principale associée à votre compte Google
Consulter vos informations personnelles, y compris celles que vous avez choisi de rendre disponibles publiquement
Loading
Recherche
Effacer la recherche
Fermer le champ de recherche
Applications Google
Menu principal