Editing a Program...................................................................................................................................

195

12-3User-defined Functions......................................................................................................

196

Creating a New User-defined Function ..................................................................................................

196

Executing a User-defined Function ........................................................................................................

197

Editing a User-defined Function .............................................................................................................

197

12-4 Program Command Reference ..........................................................................................

198

Using This Reference.............................................................................................................................

198

Syntax Conventions ...............................................................................................................................

198

Command List ........................................................................................................................................

199

12-5 Including ClassPad Functions in Programs ....................................................................

218

Including Graphing Functions in a Program ...........................................................................................

218

Including Table & Graph Functions in a Program ..................................................................................

218

Including Recursion Table and Recursion Graph Functions in a Program ............................................

218

Including Statistical Graphing and Calculation Functions in a Program.................................................

218

Including Financial Calculation Functions in a Program.........................................................................

218

Chapter 13: Spreadsheet Application..............................................................................

219

Spreadsheet Window-Specific Menus and Buttons ...............................................................................

219

Changing the Width of a Column ...........................................................................................................

220

Option Settings.......................................................................................................................................

221

13-1 Inputting and Editing Cell Contents..................................................................................

221

Selecting Cells........................................................................................................................................

221

Inputting Data into a Cell ........................................................................................................................

222

Inputting a Formula ................................................................................................................................

222

Inputting a Cell Reference......................................................................................................................

223

Cell Data Types (Text Data and Calculation Data) ................................................................................

224

Inputting a Constant into a Calculation Data Type Cell..........................................................................

224

Using the Cell Viewer Window ...............................................................................................................

226

Changing the Text Color and Fill Color of Specific Cells........................................................................

226

Copying or Cutting Cells and Pasting Them to Another Location ..........................................................

227

Recalculating Spreadsheet Expressions................................................................................................

227

Importing and Exporting Variable Values ...............................................................................................

228

13-2 Graphing..............................................................................................................................

229

Basic Graphing Steps ............................................................................................................................

229

Column Series and Row Series .............................................................................................................

229

Graph Colors and Color Link..................................................................................................................

230

Spreadsheet Graph Window-Specific Menus and Buttons ....................................................................

231

Graph Menu and Graph Examples.........................................................................................................

232

Regression Graph Operations (Curve Fitting)........................................................................................

234

Other Graph Window Operations ...........................................................................................................

236

13-3 Statistical Calculations ......................................................................................................

237

Single-variable,Paired-variable and Regression Calculations...............................................................

237

Test and Interval Calculations ................................................................................................................

238

Distribution Calculations.........................................................................................................................

240

About DispStat Command......................................................................................................................

241

13-4 Cell and List Calculations ..................................................................................................

241

Using the Cell Calculation Functions......................................................................................................

241

Using the List Calculation Functions ......................................................................................................

242

Chapter 14: System Application ......................................................................................

243

14-1 Managing Memory Usage ..................................................................................................

243

Using the Storage Sheet ........................................................................................................................

243

Using the Main Memory Sheet and eActivity Sheet ...............................................................................

244

8