Facts and Myths about Normality Test
February 29, 2012:In this week's issue of Tips & Tricks, we use the NumXLi package to demystify the normality test, a common diagnostic tool in econometric and time series analysis.
Using the Analysis Pack Add-in in Excel, we generate 5 series of random numbers, each from a different distribution. Then we apply three major normality tests - the Jarque-Bera, the Shapiro-Wilk and the Anderson-Darling - to examine the sensitivity of each test in detecting deviation from normality for different sample sizes. The exercise highlights the pros and cons of each test, and provides a useful introduction to using the Normality Test function in NumXL.
You can find more details and a step-by-step tutorial, along with a downloadable spreadsheet and PDF, at the following link: Facts and Myths about Normality Test