Pricing Free
Statistical analysis in Excel Online, with functions matching the Analysis ToolPak in desktop Excel.
With the XLMiner Analysis ToolPak App, you can perform statistical analyses of the same types available in the Analysis ToolPak in desktop Microsoft Excel. The App provides all 19 interactive functions included in the Excel Analysis ToolPak, plus a 20th function often requested by users, logistic regression. The App's Task Pane input fields and worksheet output 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 App's Random Number Generation function uses the Mersenne Twister algorithm.
App capabilities
When this app is used, it
- Can read and make changes to your document
- Can send data over the Internet
At a glance
Other apps from Frontline Systems Inc.
SolverFrontline Systems Inc.
ExcelSolve optimization models in Excel Online and Excel on iPad, upward compatible from Solver in Excel.
ExcelApplicable to:Excel
ExcelNaN out of 4
Analytic SolverFrontline Systems Inc.ExcelAnalyze risk, find the best way to allocate resources using Monte Carlo Simulation and Optimization
ExcelApplicable to:Excel
ExcelNaN out of 4
Analytic Solver Data ScienceFrontline Systems Inc.ExcelForecast the future, train and deploy predictive models using Data/Text Mining and Machine Learning
ExcelApplicable to:Excel
ExcelNaN out of 4
Risk Solver Add-inFrontline Systems Inc.ExcelEasily perform risk analysis using Monte Carlo simulation in your Excel model, for desktop and web.
ExcelApplicable to:Excel
ExcelNaN out of 4
By getting this product, I give Microsoft permission to use or share my account information so that the provider can contact me regarding this product and related products. I agree to the provider's terms of use and privacy policy and understand that the rights to use this product do not come from Microsoft, unless Microsoft is the provider. Use of terms is governed by separate privacy and {4}.