Abstract:

The aim of this present study was to demonstrate a method for statistical analysis of split plot arrangement with Microsoft EXCEL. Based on the principle of analysis of variance, the procedure for statistical analysis of split plot arrangement was established with EXCEL. After the user input raw data of test, the procedure will calculate sum of squares, mean squares and F in variance analysis quickly and accurately. Moreover, the results used DPS and this procedure is matched. The program is flexible and can be applied to calculate statistical analysis of split plot arrangement.