how to install data analysis in excel 2013

I stumbled on the Analysis ToolPak when I took an quantitative analysis class for my Masters program. 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.Excel like many of Microsoft’s other Office applications are extremely powerful tools that have many ‘hidden’ features. 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). 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.

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. StatFi ( StatPlus for Microsoft Excel) runs as an add-in for Microsoft Excel™ (supported versions: 2007, 2010, 2013, 2016, 2019) app.

On the Windows platform, you can perform an analysis from a standalone spreadsheet app or using StatFi (Excel add‑in). Descriptive Statistics (group variable).

How to install data analysis in excel 2013