How to Graph and Update a Regression Equation
How to Work with Individual Cells in Lists & Spreadsheet
Perform Regressions from within TI-Nspire Calculator Application

How to Create Column Data Based on Another Column

When you're working in the Lists & Spreadsheet application on the TI-Nspire, you can create column data based on another column. Assume that you're interested in finding the sum of the dice for each trial. You can use the header row to accomplish this task.

Just move to the formula cell for column C, type =a[]+b[], and press [ENTER]. The first screen shows the results of this action.

When referencing a column in the formula row, you must include an empty set of brackets, accessed by pressing [CTRL][ ( ] after the column letter.

Perhaps you chose to name the first three columns first_die, second_die, and total, respectively. Rather than use a letter reference for a column, you can reference these list names. After naming the first two columns, follow these steps:

  1. Move the cursor to the formula cell for column C and press the [=] key.

    Notice that total:= automatically appears in the header row.

  2. Press [VAR], highlight first_die, and press [ENTER].

  3. Press [+].

  4. Press [VAR], highlight second_die, and press [ENTER].

    See the second screen.

  5. Press [ENTER] to complete the command.

    See the third screen.

    image0.jpg

If you are following along, your screen may differ from the screen shown. That’s okay. Remember, these are random integers, and it’s to be expected that they will differ each time.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
How to Sort Data in Lists & Spreadsheet
Select Rows and Columns in Lists & Spreadsheet
How to Graph a Scatter Plot of Data
How to Perform a Second Regression on the Same Data
How to Resize Columns in Lists & Spreadsheet
Advertisement

Inside Dummies.com