Statistical Analysis of Split Plot Arrangement with EXCEL
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 would calculate sum of squares, mean squares and F in variance analysis quickly and accurately. Moreover, the results used DPS and this procedure was matched. The program was flexible and could be applied to calculate statistical analysis of split plot arrangement.
NETL
NSTL
万方数据
维普
