The descriptive statistics are as for three-factor Anova described in Real Statistics Support for Three Factor ANOVA (with only the first 12 rows shown in Figure 3). If the input data is already in standard format you would choose the Standard format with column headings or Standard format without column headings and obviously the conversion to standard format would not be necessary. The data analysis tool first converts the data in Excel format into standard format (as shown in range G1:J34 of Figure 1), and then outputs the descriptive statistics and Anova shown in Figure 3. We choose the Excel format option using the RCB model for whole plots with 3 rows per replication. You now fill in the dialog box that appears as shown in Figure 2. To access the tool, press Crtl-m, choose the Analysis of Variance option and then select the Split-plot Anova option. To conduct the analysis we use Real StatisticsвЂ™ Split-plot Anova data analysis tool. stacked format), although only the first 15 of 36 rows is displayed. The layout on the right side of Figure 1 is the same data in standard (i.e. The layout on the left side of Figure 1 represents the data in Excel format, with the columns corresponding to whole plots and the rows to subplots. main plot), which is divided into 4 sub-treatments (i.e. a replication) and where each batch corresponds to a main treatment (i.e. a split-plot design) creates only 3 batches per day, where each day is a block (i.e. In that case, on each day 12 batches would be created, and that batch would use one of the 12 combinations of composition and temperature, for a total of 36 batches over the 3 days. Note that this design is different from a completely randomized design. The values in the cells are the measurements of flexibility. Here the columns represent compositions and the rows represent the temperatures. The level of flexibility of the plastic for each run is as described in range A3:E12 of Figure 1. In any one shift, a batch of the selected composition is split into 3 parts each of which is heated to a different one of the 3 temperatures.

Since it is difficult to change the process for creating each composition, the decision was made to produce one such composition per shift, randomly choosing the order of the 4 compositions among the 4 shifts. The manufacturer has dedicated one production facility to this test for three days and this facility runs 4 shifts a day and is capable of 3 runs per shift.

Thus, there are 4 Г— 3 = 12 different combinations of the two factors. It is also interested in determining which of three temperature levels during the manufacturing process produces the best result. Example 1: A manufacturer of plastics is exploring four different compositions for a new type of plastic and wants to determine which yields a plastic with more flexibility.

Cluster analysis xlstat