Create a Collection from the Cells of a Summary Table

How To... > Create Simulations > Collect Measures and Other Results > Create a Collection from the Cells of a Summary Table

At times, it is useful to convert the values computed in a summary table into a new collection.

The tables below show one such situation. Census microdata for 5000 people has been tabulated so that we have the counts of people in each state. But how many states are represented, and what is the distribution of counts? To answer these, and other questions for which we wish to treat the states as cases, we create a new collection in which each cell of the summary table is one case and each formula is an attribute.

To create a collection from the cells of a summary table:

•With the summary table selected, choose Summary | Create Collection From Cells.

The contents of the cells collection automatically update when the source collection changes. For example, if you import a fresh sample of 5000 people into the microdata collection, the cells collection would immediately reflect the new counts. It is even possible to collect measures from the cells collection.

See also

Create Collection From Cells