Nspire Stat Logo Main Page MathBits.com Table of Contents MathBits.com Terms of Use TI-84+ Web Site

Lists and Spreadsheets

NAME your lists!!!!!
Start formulas with an = sign !!!!

spreadsheet home

Spread Sheet

To insert a page for lists and spreadsheets, choose option #3 Lists and Spreadsheets from the HOME screen or press CTRL I (to choose the insertion of a spreadsheet page). This spreadsheet behaves much like Microsoft Excel.
Remember, you MUST name your lists!
Remember, to do a formula, you must start with an equal sign (=).

 

EXAMPLE: Consider the data set:  {15, 22, 32, 31, 52, 41, 11}
We will name this data set Ex1.

Entering Data:
Simply type your data and press ENTER after each entry, or arrow down. Use your arrows to move between cells and columns.

You MUST Name your list: Arrow to the top of the column and enter the name of your list. Keep the name descriptive, but short. We are naming our list Ex1, for this first example.

You can edit a cell entry by typing over it.
You can delete a cell entry by highlighting the cell and pressing CTRL-MENU, #1 Cut.

Ex1
Creating a new list: Data can be entered in a second list based upon the information in a previous list.  We will now double all of our data values in Ex1 and store them in column B, which we will name Twice.  Arrow over to the shaded cell below the listing of column B. Type the formula = 2 * Ex1 into this cell.  The formula will also appear at the bottom of the screen.  Press ENTER and the new list is created.
Create new list

Resizing the Columns: Often times it is necessary to make a column wider so that you can more clearly see its contents.

1. Move to a cell in the column you wish to adjust.
2. Hit MENU, #1 Actions, #2 Resize, #1 Resize Column Width
3.
Use your arrow to drag the edge of the column to the right to enlarge the column.
4. Resize row height by highlighting the row and then follow the menu options again.

The columns are now wider and the formula is more easily viewed.

Resize Columns

wider columns

Delete or Clear a Column: To delete or clear a column, arrow to the top of the column and arrow up one more time. This will highlight the column. Press clear to clear all of the entries.
Delete column

Filling Columns: Suppose we want the first cell in column C to be 30, but we want the next 4 cells to be 3 times their corresponding values in column A.

1. Enter the first cell value of 30 directly.
2. Now, in cell C2, type the formula =A2*3.
3. Press MENU, #3 Data, #3 Fill Down.
4. Now, arrow down to cover the number of cells you wish to fill. You will see a dotted line around the cells. Hit ENTER.
5. The cells that were highlighted will repeat the pattern set by the formula.

Fill done

Fill Start

Fill

Selecting a Column (or Row): To select a column, press Shift and arrow down to highlight all of the cells you wish to capture. Now, the cells can be cleared, copied, moved, etc.

Copy: control key+C Paste: control key+V

 

select column

Working with a Block of Cells: Find the "mean" of cells A4, A5, B4, and B5 and place the answer in D1.
1. Highlight cell D1.
2. Type the formula = mean(A4:B5)*1.
You can find "mean" in the Catalog, catalog. For the block of cells, start with the upper left cell, and finish with the lower right cell. Multiplying by 1. (don't forget the decimal) will force the answer to be a decimal approximation.

3. The answer appears in cell D1.

mean

One Variable Statistics:
P
ress menu, #4 Statistics, #1 Stat Calculations, and choose #1 One-Variable Statistics.

The choice "Open Variable Statistics" yields the following results back to the spreadsheet columns. One column will "label" these values, while the following column contains the actual values.

mean symbol
= mean
Sum x
= the sum of the data
sum squared
= the sum of the squares of the data
sx
= the sample standard deviation
population sd
= the population standard deviation
n
= the sample size (# of pieces of data)
MinX
= the smallest data entry
quartile1
= data at the first quartile
MedianX
= data at the median (second quartile)
quartile 3
= data at the third quartile
MaxX
= the largest data entry
SSx
= the sum of squared deviations of x from the
   mean of x.

Menu Choices

Menu Choice

When prompted for the
number of lists, enter 1.


list stats

Stats

 


Table of Contents | MathBits.com | Terms of Use