Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

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
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.