https://store-images.s-microsoft.com/image/apps.2225.9cbf413e-e33f-4be9-90ef-2fdb353c52a1.6e475dbb-9ae3-4b89-ae41-004faa21a088.e9552e6b-53ec-4728-ba49-ba04757c6dd0.png

XLMiner Analysis ToolPak

作者 Frontline Systems Inc.

(61 评分)

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.

应用功能

使用此应用时,
  • 可读取文档并对其作出更改
  • 可通过 Internet 发送数据

概览

https://store-images.s-microsoft.com/image/apps.24241.9cbf413e-e33f-4be9-90ef-2fdb353c52a1.6e475dbb-9ae3-4b89-ae41-004faa21a088.cce9788e-1342-4386-b570-6929c6a3a12b.png
https://store-images.s-microsoft.com/image/apps.44439.9cbf413e-e33f-4be9-90ef-2fdb353c52a1.6e475dbb-9ae3-4b89-ae41-004faa21a088.28559cd9-d134-4091-8883-cb33e617655e.png
https://store-images.s-microsoft.com/image/apps.44927.9cbf413e-e33f-4be9-90ef-2fdb353c52a1.6e475dbb-9ae3-4b89-ae41-004faa21a088.753231f4-ca13-4889-a57a-7a2fc94554b5.png
https://store-images.s-microsoft.com/image/apps.58470.9cbf413e-e33f-4be9-90ef-2fdb353c52a1.6e475dbb-9ae3-4b89-ae41-004faa21a088.c282e02d-d5e6-472e-b5a8-c2f4e21e5425.png
https://store-images.s-microsoft.com/image/apps.61546.9cbf413e-e33f-4be9-90ef-2fdb353c52a1.6e475dbb-9ae3-4b89-ae41-004faa21a088.75601f6d-61b7-472b-97df-3840fcfd2d44.png