An environmental scientist wants to determine whether temperature changes in the ocean near a nuclear power plant affect the growth of fish. The scientist randomly divides 25 fish into four groups and places each group into a separate, simulated ocean environment. The simulated environments are identical except for temperature. Six months later, the scientist measures the weights of the fish.
The weights of fish for all temperature levels are in the same column. The scientist unstacks the columns in order to analyze one temperature level at a time.
Columns C1–C2 contain the original stacked weight data and corresponding temperature levels. Columns C3–C6 contain the unstacked weight data, with one column per temperature level.