Google Workspace Marketplace
Statistical analysis in Google Sheets, with functions matching the Analysis ToolPak in desktop Excel.
By:
Listing updated:⧍⧧ āĻŽā§‡, ⧍ā§Ļ⧍ā§Ē
Works with:
ā§Šā§Ģ āϞāĻž+
āĻāĻ• āύāϜāϰ⧇
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.
Additional information
PricingāĻĢā§āϰāĻŋ
Developer
āϏāĻŽāĻ°ā§āĻĨāύ
āĻ—ā§‹āĻĒāĻ¨ā§€ā§ŸāϤāĻž āύ⧀āϤāĻŋ
āĻĒāϰāĻŋāώ⧇āĻŦāĻžāϰ āĻļāĻ°ā§āϤāĻžāĻĻāĻŋ
āϰāĻŋāĻĒā§‹āĻ°ā§āϟ āĻ•āϰ⧁āύFlag as inappropriate
XLMiner Analysis ToolPak will ask for the permissions shown below. Learn more
XLMiner Analysis ToolPak will need access to your Google account
This will allow XLMiner Analysis ToolPak to :
Google āĻāϰ āĻ…ā§āϝāĻžāĻĒā§āϞāĻŋāϕ⧇āĻļāύ⧇āϰ āĻĒā§āϰāĻŽā§āĻĒāϟ āĻāĻŦāĻ‚ āϏāĻžāχāĻĄāĻŦāĻžāϰ⧇ āϤ⧃āĻ¤ā§€ā§Ÿ āĻĒāĻ•ā§āώ⧇āϰ āĻ“ā§Ÿā§‡āĻŦ āĻ•āĻ¨ā§āĻŸā§‡āĻ¨ā§āϟ āĻĻ⧇āĻ–āĻžā§Ÿ āĻāĻŦāĻ‚ āϚāĻžāϞāĻžā§Ÿ
āφāĻĒāύāĻžāϰ āĻĒā§āϰāĻžāĻĨāĻŽāĻŋāĻ• āχāĻŽā§‡āϞ āφāχāĻĄāĻŋ āĻĻ⧇āϖ⧁āύ
āφāĻĒāύāĻŋ āϏāĻ°ā§āĻŦāϜāύ⧀āύāĻ­āĻžāĻŦ⧇ āωāĻĒāϞāĻ­ā§āϝ āĻ•āϰ⧇āϛ⧇āύ āĻāĻŽāύ āϝ⧇āϕ⧋āύāĻ“ āĻŦā§āϝāĻ•ā§āϤāĻŋāĻ—āϤ āϤāĻĨā§āϝ āϏāĻš āφāĻĒāύāĻžāϰ āĻŦā§āϝāĻ•ā§āϤāĻŋāĻ—āϤ āϤāĻĨā§āϝ āĻĻ⧇āϖ⧇
āϰāĻŋāĻ­āĻŋāω
Language:
āĻāχ āĻ…āύ⧁āϝāĻžā§Ÿā§€ āϏāĻžāϜāĻžāύ:
Google āϰāĻŋāĻ­āĻŋāω āĻ“ āϰ⧇āϟāĻŋāĻ‚ āϝāĻžāϚāĻžāχ āĻ•āϰ⧇ āύāĻžāĨ¤ āϰāĻŋāĻ­āĻŋāω āϏāĻŽā§āĻĒāĻ°ā§āϕ⧇ āφāϰāĻ“ āϜāĻžāύ⧁āύ
No comments
āϏāĻžāĻ°ā§āϚ āĻ•āϰ⧁āύ
āϏāĻžāĻ°ā§āϚ āĻŽā§āϛ⧁āύ
āϏāĻžāĻ°ā§āϚ āĻŦāĻ¨ā§āϧ āĻ•āϰ⧁āύ
Google āĻ…ā§āϝāĻžāĻĒā§āϞāĻŋāϕ⧇āĻļāĻžāύāϗ⧁āϞāĻŋ
āĻĒā§āϰāϧāĻžāύ āĻŽā§‡āύ⧁