Firstly, checking normality and secondly ANOVA analysis. Materials and Methods: In this paper will explain how to conduct one-way ANOVA using XLSTAT software, an add on of Microsoft Ofﬁce Excel. The objective in this study is to provide basic guideline how to conduct one-way ANOVA analysis using XLSTAT Excel. This provides the information that is of most use to the researcher.

In ANOVA, multiple comparison methods are designed to investigate differences between specific pairs of means. There are two assumption are needed for this analysis such as normality distribution and randomness & independence. Universiti Putra Malaysia (Family Health)īackground: The One-Way ANOVA is commonly used to test statistical differences among the means of two or more groups or intervention or change score. Universiti Putra Malaysia (Occupational Medicine) Universiti Putra Malaysia (Epidemiology/ Occupational Medicine) Universiti Putra Malaysia (Medical Biostatistics) Universiti Putra Malaysia (Environmental Medicine) Universiti Putra Malaysia (Health Promotion) (Health Service Management, Universiti Putra Malaysia) (Family Health, Universiti Putra Malaysia)

Associate Professor Dr Halimatus Sakdiah Minhat

How to do an anova in excel