Excel Analysis ToolPak Descriptive Statistics

Leave a comment

There is lots of functionality in the Excel Analysis ToolPak.

Let’s take a look at Descriptive Statistics. Let’s apply this to my data, which is MSFT stock prices over 2016. Select the input range and check labels in first row. Check summary statistics. This will go into a new tab on the worksheet.

Excel has now generated the Descriptive Statistics:



Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI.

carldesouza.comLinkedIn Twitter | YouTube


Leave a Reply

Your email address will not be published. Required fields are marked *