Excel alkalmazása normális eloszlás tesztelésére Shapiro-Wilk próbával

Abstract

Microsoft Excel can repeatedly execute programmed calculations on filtered large data sets with the help of Visual Basic fór Application. There are several statistical applications to check normality with Shapiro-Wilk test, bút only Excel can be used to do this in a programmable way. We have created a user-friendly interface with the help of Excel spreadsheet to perform automatic calculations.