Live Chat Help Desk.Tech Support Advice Links.
Its products integrate forecasting and data mining for "predictive analytics," Monte Carlo simulation and risk analysis, and conventional and stochastic optimization for "prescriptive analytics.įounded inFrontline is based in Incline Village, Nevada Free Trial. The 20 functions in XLMiner Analysis ToolPak include sampling, descriptive statistics, analysis of variance ANOVAcorrelation and covariance, forecasting via exponential smoothing, moving averages, linear regression and logistic regression, random number generation using the Mersenne Twister, Fourier analysis, and statistical tests such as the F-test, T-test and Z-test.Įach function reads data from, and writes results to the spreadsheet in user-selected cell ranges.
But its functions are missing from both Excel Online and Google Sheets.įrontline's new tool fills this gap, providing all 19 interactive functions included in the Excel Analysis ToolPak, plus a 20th function often requested by users, logistic regression. Scores of statistics courses, textbooks, tutorials and online videos have introduced users to common statistical techniques using the Excel Analysis ToolPak. The new tool makes it easy for users to 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.