Pivoting the Descriptives Table

To assess how the mean of Aflatoxin PPB varies by Corn Yield, you can pivot the Descriptives table to display the statistics that you want.

  1. In the output window, double-click the Descriptives table to activate it.
  2. From the Viewer menus choose:

    Pivot > Pivoting Trays...

  3. Select the Statistics element in the Row area.
  4. Drag the Statistics element to the Layer area.
    Figure 1. Pivoting Trays window with Statistics in the layer
    Pivoting Trays window showing the Statistics element in the layer dimension
  5. Close the Pivoting Trays window.
  6. Deactivate the table by clicking outside of its boundaries.
Figure 2. Mean aflatoxin level
Descriptives table showing the mean aflatoxin level

According to U.S. law, a yield is unfit for human consumption if aflatoxin exceeds 20 PPB. The pivoted table makes it clear that in these data, only yields 4, 7, and 8 fall below the 20 PPB cutoff.