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:

 

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Leave a Reply

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

four × two =