Example of unstack columns

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.

  1. Open the sample data, FishWeights.MTW.
  2. Open the Unstack Columns dialog box.
    • Mac: Data > Unstack Columns
    • PC: DATA > Unstack Columns
  3. In Unstack the data in, enter Weight.
  4. In Unstack using the values in, enter Temp.
  5. Click OK.

Results

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.

C1 C2 C3 C4 C5 C6
Weight Temp Weight_38 Weight_42 Weight_46 Weight_50
22 38 22 15 14 17
18 38 18 21 28 18
22 38 22 26 21 13
24 38 24 16 19 20
16 38 16 25 24 21
18 38 18 17 23 18
19 38 19      
15 42        
21 42        
26 42        
16 42        
25 42        
17 42        
14 46        
... ...        
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy