Creating and Sharing Spreadsheet Data as Lists

You can define a column as a named list of elements of the same type of data. After defining a list, you can link to it from the Graphs & Geometry, Calculator, or Data & Statistics applications, and from other instances of the Lists & Spreadsheet application within the current problem.

Sharing a Spreadsheet Column as a List Variable

You share a column of data by naming it as a list variable.

Note: Avoid defining variables that use the same names as those used for statistical analysis. In some cases, an error condition could occur.

Variable names used for statistical analysis are listed in the TI‑Nspire™ Reference Guide, under the stat.results entry.

Click the cell to move to the column’s name cell (the top cell of the column).

—or—

Press ▲ as necessary.

Type a name for the list variable, and press Enter.

The column is now available as a list variable to other TI‑Nspire™ applications.

Create elements in the list the same as you would create data in spreadsheet cells. For example, you can type the data into each cell or use a formula to generate a column of data.

Notes:

•

If a variable with the name you specified already exists in the current problem, Lists & Spreadsheet displays an error message.

•

When you select the column formula cell of a list, it displays the list name in an expression similar to width:=.

•

Lists can contain empty elements (denoted by “_”) .

•

You can refer to a specific element in a named list from the Calculator application. Use the list name and the element’s position within the list. In a list named Heights, for example, refer to the first element as Heights[1]. The expression Heights[2] refers to the second element, and so on.

Linking to an Existing List Variable

Linking a column to an existing list variable lets you easily view and edit the values in the list. The list can be any shared list in the current problem and can be defined in Graphs & Geometry, Calculator, or any instance of Lists & Spreadsheet.

After you link a column to a list, Lists & Spreadsheet automatically shows any changes that you make to the list with other TI‑Nspire™ applications.

Click the column formula cell (the second cell from the top) of the column that you want to link to the variable.

Type the name of the list variable you want to link to.

—or—

Click on the toolbar (press h on the handheld), click Link To, and click the variable you want to link to.

Press Enter.

The column shows the list elements.

Notes:

•

You cannot link to the same variable multiple times on the same page.

•

Use caution if you link to a system variable. Doing so could prevent the variable from being updated by the system. System variables include ans and statistics results (such as stat.results, stat.RegEqn, and stat.Resid).

Inserting an Element in a List

When you insert an element in a list, the remaining elements shift downward to create space. No other columns are affected.

▶

Click Insert > Insert Cell.

Deleting an Element from a List

When you delete an element, the remaining list elements shift upward to close the gap. The upward shift affects only the selected column.

Click the cell of the element to delete.

Open the context menu for the cell, and click Delete Cell.

Note: If you press Del or Backspace to clear the contents of the cell instead of deleting the list element, the element is assigned a value of 0 (zero). The remaining list elements do not shift.