To select input variables (cell range, column or several columns) for the command you can either use the list of variables (columns) or the button in the range input field. ii) A strange computer behavior weve seen is that the Excel Data Analysis simply disappears from the Tools menu. Run the Basic Statistics→Descriptive Statistics commandįrom the StatFi ribbon or from the Statistics menu of the standalone app. You can also open a dataset from a command help page, when available. The Favorites menu allows you to recall saved commands.įor the standalone spreadsheet - use the File→Open command to open a dataset, or open a dataset with Microsoft Excel.

The Recent menu allows you to quickly repeat one of the last twenty commands (you can change input variables and command options, if necessary). In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK. In the Manage box, select Excel Add-ins and then click Go. Click the File tab, click Options, and then click the Add-Ins category. The StatFi ribbon is available on the right side of the Excel ribbon and provides access to the statistics commands.īoth the standalone app and the Excel add-in include the ability to quickly repeat a data analysis using the Recent and Favorites menus. These instructions apply to Excel 2010, Excel 2013 and Excel 2016.

Launch standalone app (StatPlus) or ExcelĪll the data analysis commands are available from the standalone app main menu or from the StatFi ribbon in the Excel app.

To perform an analysis, please follow these steps: Migration guide for Excel Analysis Toolpak (ATP) users is available here. After you load the Analysis ToolPak, the Data Analysis command is available under the Data tab. In the Add-ins box that opens, make sure the Analysis Toolpak is checked and then click on OK. Rentals Details: Click Add-Ins, and then in the box to the right, select the Analysis ToolPak check box, and then click GO. StatFi ( StatPlus for Microsoft Excel) runs as an add-in for Microsoft Excel™ (supported versions: 2007, 2010, 2013, 2016, 2019) app. Install the Excel Data Analysis Tool Pack. On the Windows platform, you can perform an analysis from a standalone spreadsheet app or using StatFi (Excel add‑in).

Descriptive Statistics (group variable).

Install data analysis excel 2013