Use Data Analysis ToolPak and Add-Ins in Excel for Android
Question details
Determine whether Excel for Android supports the Data Analysis ToolPak, XLA add-ins, and COM add-ins for statistical analysis.

- Product
- Microsoft Excel for Android
- Device & OS
- Android
- Scenario
- A user wants to perform statistical analysis using the ToolPak or traditional Excel add-ins on an Android device.
- Observed behavior
- The full Data Analysis ToolPak and traditional XLA and COM add-ins are not available in Excel for Android in the same way as in desktop Excel.
Check whether your analysis requires a ToolPak command or add-in, or whether a built-in formula will suffice. If you need the ToolPak, have access to desktop Excel for Windows or Mac.
Use the Analysis ToolPak in desktop Excel
Use desktop Excel when you need ToolPak commands such as descriptive statistics or regression.
Open your workbook in Excel for Windows or Mac.
On Windows, select File > Options > Add-ins, choose Excel Add-ins under Manage, and select Go. On Mac, select Tools > Excel Add-ins. Check Analysis ToolPak and select OK.
Open the Data tab, select Data Analysis, choose an analysis tool, and enter the requested input range and output settings.

Use statistical formulas in Excel for Android
Use built-in formulas for basic calculations when you do not need the full ToolPak.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Microsoft Office format compatibility makes it easier to move existing files between applications. It does not enable Excel's Android ToolPak or traditional Excel add-ins.

Frequently Asked Questions
Can I install the Data Analysis ToolPak in Excel for Android?
No. The full ToolPak is a desktop Excel feature. To use it, open the workbook in Excel for Windows or Mac, enable Analysis ToolPak, and select Data > Data Analysis.
Can Excel for Android run XLA or COM add-ins?
Traditional XLA and COM add-ins do not run in Excel for Android as they do in desktop Excel. COM add-ins are a Windows technology; check the add-in's requirements before using it on a desktop.
How can I calculate an average on Android without the ToolPak?
In Excel for Android, tap an empty cell and enter =AVERAGE(A2:A20), replacing the range with your own data. Confirm the formula to see the result.
Does Excel for the web provide the full Analysis ToolPak?
Do not assume that the desktop ToolPak is available in Excel for the web. You can use supported worksheet formulas in a browser, but use desktop Excel if your task requires a ToolPak command.




