Statistical analysis in Google Sheets, with functions matching the Analysis ToolPak in desktop Excel.
Vermelding geüpdatet:21 mei 2024
Werkt met:
3 mln.+
Overzicht
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.
Meer informatie
KostenKosteloos
Servicevoorwaarden
XLMiner Analysis ToolPak vraagt u om de onderstaande rechten. Meer informatie
XLMiner Analysis ToolPak heeft toegang nodig tot uw Google-account
Hiermee kan XLMiner Analysis ToolPak het volgende doen:
Webcontent van derden weergeven in prompts en zijbalken in Google-apps
Het primaire e-mailadres van je Google-account bekijken
Uw persoonlijke info bekijken, met inbegrip van persoonlijke info die u openbaar heeft gemaakt
Reviews
Taal:
Sorteren op:
Google verifieert reviews en beoordelingen niet. Meer informatie over reviews
Geen opmerkingen
Zoeken
Zoekopdracht wissen
Zoekfunctie sluiten
Google-apps
Hoofdmenu