Statistics add-on in Google Sheets

The Statistical analysis add on called XLMiner Analysis ToolPak was recently added to in Google Sheets, with functions matching the Analysis ToolPak in desktop Excel 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.

To get an Add on, open sheets then Tools > Add Ons. Search for XLMiner