![how to perform statistical analysis in excel 2010 how to perform statistical analysis in excel 2010](https://blog.cometdocs.com/wp-content/uploads/excel-data-and-statystical-analysis.png)
Creating a histogram using the Analysis ToolPak generates a chart and a data table, as seen below to get the ‘Frequency’ of the ‘Bin’ (Bin size is determined by the analyst).In this post, we will share on normality test using Microsoft Excel.įor the example of the normality test, we’ll use set of data below. Most us are relying to our advance statistical software such as Minitab, SigmaXL, JMP and many more to validate the data normality.
![how to perform statistical analysis in excel 2010 how to perform statistical analysis in excel 2010](https://www.digitalvidya.com/wp-content/uploads/2018/09/Pivot-Table2.png)
However, deeper analysis is require to validate the normality of the data since it is affecting our analysis method.
![how to perform statistical analysis in excel 2010 how to perform statistical analysis in excel 2010](https://support.content.office.net/en-us/media/02867c7b-3a0e-4b8c-b689-cadd35899578.jpg)
How to perform statistical analysis in excel 2010 how to#
In our previous post, we have discussed what is normal distribution and how to visually identify the normal distribution.