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:

 

ABOUT CARL DE SOUZA

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 *