One-Way Analysis    Targeting    Two-Way Analysis    Regression

The aggregate data method creates a separate data set with only the variables that you select, for the purposes of creating a ranked analysis.

                    Open RFSPBasline.sav

1.  Click on Data on the tool bar, and select aggregate.

2.  Scroll through the variable list and click on district, then click the arrow next to the box labeled break variables. District should now be in that box.

3.  Scroll through the variable list and click on the following variables, and move each into the box labeled aggregate variables: foodsuff, meals, chmeal, admeal, irr99, cult, lit, edcat, watercat, and totarea.

4.  Click on the box next to save number of cases in break group as variable; a check mark should now be in that box.

5.  Double-check that the circle next to create new data file has a black dot in it; if not, click that circle so the dot appears.

6.  Click OK.

7.  Close the Somalia data set (we need to close this data set in order to view our new set).

8.  Open the aggregate data set (if you are using the CD ROM it will be saved on your hard drive).

9.  Click data on the tool bar, select sort cases.

            10. Scroll to foodsuff and move it to the sort by box. Under sort order, select descending.

            11.   Click OK.

The aggregate data set is now sorted by district, highest to lowest according to food sufficiency status.  It should look like this: