Manuals / Brands / Computer Equipment / Calculator / Casio / Computer Equipment / Calculator

Casio FXCP400 [Calc] - [List-Statistics]submenu, [Calc] - [List-Calculation]submenu, Chapter 13: Spreadsheet Application, Using the List Calculation Functions

1 275

Download 275 pages, 3.22 Mb

Using the List Calculation Functions

The [Calc] menu functions shown in the table below are also included (with the same name) on the Main application [Action] - [List] - [Statistics] and [Action] - [List] - [Calculation] submenus.

[Calc] - [List-Statistics] submenu	min, max, mean, median, mode, Q1, Q3, percentile, stdDev, variance
[Calc] - [List-Calculation] submenu	sum, prod, cuml, Alist, percent, polyEval, sequence, sumSeq

Selecting a menu item on the [Calc] - [List-Statistics] submenu or [Calc] - [List-Calculation] submenu will input the corresponding function into the currently selected cell. For information about the syntax and other details about each function, see “Using the List-Statistics and List-Calculation Submenus” (page 70).

Tip: When a range of cells on a spreadsheet is specified as the arguments of these functions, the cells are regarded of a single list of data even if the range extends over multiple columns. For example, in the case of the nearby screenshot (where the range A1:B3 is selected), the data is treated as the following list data: {1,3,5,2,4,6}.

1304 To determine the mean of the values in the block whose upper left corner is located at A1 and whose lower right corner is located at C3, and input the result in cell C5

1305 When Column A is data and Column B is frequency, to totalize the data input in A1 through B3 in the nearby screenshot and input the total into cell B5

Chapter 13: Spreadsheet Application

242

Contents

Page Be sure to keep physical records of all important data Backing Up Data Contents Chapter 1: Basics 1-1General Guide 1-2Power Supply 1-3 Built-inApplication Basic Operations 2-5Matrix and Vector Calculations 2-6Specifying a Number Base 2-7Using the Action Menu 2-8Using the Interactive Menu 2-9Using the Main Application in Combination with Other Applications 3-4Using Trace 3-5Using the Sketch Menu 3-6Analyzing a Function Used to Draw a Graph 3-7Modifying a Graph Chapter 4: Conics Application 6-2Graphing a Recursion Chapter 7: Statistics Application 7-2Drawing a Statistical Graph 7-4Performing Advanced Statistical Calculations Chapter 8: Geometry Application Chapter 9: Numeric Solver Application Chapter 10: eActivity Application 10-1Creating an eActivity 11-1Financial Application Basic Operations 11-3Calculation Formulas 12-4Program Command Reference 12-5Including ClassPad Functions in Programs 13-3Statistical Calculations 13-4Cell and List Calculations Chapter 14: System Application 14-2Configuring System Settings 15-2Performing Data Communication between the ClassPad and a Personal Computer 15-3Performing Data Communication between Two ClassPads 15-4Connecting the ClassPad to an EA-200Data Analyzer 15-5Connecting the ClassPad to a Projector Chapter 1: Basics Turning Power On or Off Auto Power Off Note 1-2Power Supply Important 1-3 Built-inApplication Basic Operations Using the Application Menu Built-inApplications Tap this To start this Tip: Application Window To do this: Perform this operation: Switch the active window While a dual window is on the display, tap anywhere inside the window that does not have a thick boundary around it to make it the active window. Note that you 1-4Input Using the Soft Keyboard uTo display the soft keyboard Soft Keyboard Key Sets [Math1], [Math2], [Math3], [Trig] (trigonometric), [Advance] key sets Math1 Math2 [abc] key set [Catalog] key set [Number] key set Input Basics •The Main application is running. See “Built-inApplications” (page 12) kEditing Input uTo delete a single character Example: To change the expression 369 × × 2 to 369 × 1. c369**2 2. dK kUsing the Clipboard for Copy and Paste uTo copy characters 1.Drag the stylus across the characters you want to copy to select them 2.On the soft keyboard, tap p. Or tap the [Edit] menu and then tap [Copy] • This puts a copy of the selected characters onto the clipboard Example 2: 1.In the Main application work area, input: 2x^2 + 2x − 1. c2x{2+2x-1E •This will display the Graph Editor window in the bottom half of the screen Select the •This will copy 2x^2 + 2x − 1 to the location where you dropped it Key set Key Description kTemplate Input and Line Input uSwitching between Template Input and Line Input 1.Tap the [Math1] tab and then enter the line input mode (light blue key) 2+(d2!2)N (!2)+1)ewE Example 3: To use the template input mode to input () 1.Tap the [Math2] tab and then enter the template input mode (white L key) Oxe1f10exE Example 2: 2xyE uTo input a series of multiple characters Example: abcE Example: a*b+cE kUsing the Alphabet Keyboard 1-5ClassPad Data Data Types and Storage Locations (Memory Areas) ClassPad uses a “main memory” memory area to store various types of data Examples: Executing “10 Main Memory Data Types data type data type name Data Type Name Data Type Using Variable Manager About Variable Types uTo start up Variable Manager uVariable Manager operations Do this: Deselect a folder or Clear the check box next to the folder or variable name. To deselect all the variable folders or variables in the list, tap [All] and then [Deselect All] Delete a folder Selecting a Variable Folder and Variable Name Rules uTo delete a folder uTo input a folder name or variable name into an application Managing Application Files The applications below can save data to files uTo save a file 1.Tap [File] and then [Save] uTo open an existing file 1-6Creating and Using Variables Creating a New Variable uClassPad Operation Variable Usage Example 1.Assign 5 to 51WxE 2.Check the contents of variable “eq1” 0eqbw 4.Change the current folder specification to “Test” eq1E main\eq1E eq2E Rules Governing Variable Access 1-7Configuring Application Format Settings Select this O menu command: uTo configure application format settings Application Format Settings Switch between complex number calculations Select the “Complex Format” check box to enter the (Complex mode) and real number calculations (Real Complex mode, or clear the check box* to enter the mode) kGraph Format Dialog Box [Basic] tab To specify display of Graph window axes Tap 1 and then tap one of the settings described below On: show axis [Special] tab To specify the row width for Stat Editor and data table displays To specify a source for table data To specify a source for summary table data To show or hide the second derivative for summary tables kGeometry Format Dialog Box To specify the Geometry window numeric value display format Tap 1 and then select the format you want. The initial default Number 1Format setting is Fix2. For more information, see “To specify the numeric 2value display format” (page 34) kFinancial Format Dialog Box To specify the number of days in a year 3To specify the date format To specify the status of input fields when starting a new calculation To specify odd period handling Compound (CI): Apply compound interest to the odd period when 1performing a Compound Interest calculation 3Off*: Apply no interest to the odd period when performing a Compound 4Interest calculation 1-8When you keep having problems… 1.Initialize all application format settings 2.Perform the RAM reset (RESTART) operation To perform the RAM reset operation Important 3.Reset the ClassPad Chapter 2: Main Application Using the eKey 0202 Calculation examples Omitting the Multiplication Sign You can omit the multiplication sign in any of the following cases •In front of a function… 2sin (30), 10log (1.2), etc Calculation Priority Sequence Your ClassPad automatically performs calculations in the following sequence 1Commands with parentheses (sin(, diff(, etc.) 2Factorials (x!), degree specifications (o, r ), percents (%) 3Powers Normal Fix Sci 50 ÷ 4 1.25E + 2-2Using the Calculation History You can edit a calculation expression in the calculation history and then uTo delete part of the calculation history contents Move the cursor to the expression line or result line of the 2.Tap [Edit] and then [Delete] Problem Operation + 82.5 Rw Trigonometric and Inverse Trigonometric Functions S 0.5 w 1500 * 12 &w 660 / 880 &w 2500 *( 1 + 15 & 3500 *( 1 - 25 & :- 3.4567 w u“rand” Function “randList” Function u“randNorm” Function u“randBin” Function • “n” and “m” must be positive integers Randomly produce the number of heads that can be [randBin] , 0.5 w expected in accordance with binomial distribution for u“iLcm” Function u“iMod” Function Permutation (nPr) and Combination (nCr) uTotal Number of Permutations uTotal Number of Combinations Condition Judgment (judge, piecewise) u“judge” Function u“piecewise” Function Angle Symbol (∠) Derivative Symbol (’) Primality Test (isPrime) isPrime(Exp/List[ ) ] • Exp or all of the elements of List must be integers Determine whether the numbers 51 and 17 are [isPrime] { 51 , 17 })w Solution Example Dirac Delta Function Syntax: delta(x) nth-DeltaFunction 2-4List Calculations Inputting List Data in the Work Area LIST Variable Element Operations Using a List in a Calculation Using a List to Assign Different Values to Multiple Variables 2-5Matrix and Vector Calculations Inputting Matrix Data Inputting Matrix Values in a Single Line To input the matrix and assign it to the variable “mat1” in the Main application work area 2-6Specifying a Number Base •Except for Ans (Answer Memory variable), you cannot use variables If a calculation produces a Binary: 0 Octal: 0 to Selecting a Number Base uTo select the number base for the line where the cursor is located Number System Suffix uTo specify a number base for an input value 2-7Using the Action Menu Abbreviations and Punctuation Used in This Section Exp: Expression (Value, Variable, etc.) List: Example Screenshots When the input expression does not fit: When the output expression does not fit: Using the Transformation Submenu uapprox [Action][Transformation][approx] urFactor [Action][Transformation][factor][rFactor] rFactor ufactorOut [Action][Transformation][factor][factorOut] factorOut ucombine [Action][Transformation][combine] utoFrac [Action][Transformation][Fraction][toFrac] toFrac upropFrac [Action][Transformation][Fraction][propFrac] propFrac udms [Action][Transformation][DMS][dms] Laplace Transform of a Differential Equation ufourier [Action][Advanced][fourier], invFourier [Action][Advanced][invFourier] fourier invFourier (ω) Transform Definition n (optional) Modern Physics Pure Math Probability Using the Calculation Submenu udiff [Action][Calculation][diff] diff uimpDiff [Action][Calculation][impDiff] impDiff uΠ [Action][Calculation][Π] urangeAppoint [Action][Calculation][rangeAppoint] rangeAppoint umod [Action][Calculation][mod] mod ugcd [Action][Calculation][gcd/lcm][gcd] gcd ulcm [Action][Calculation][gcd/lcm][lcm] lcm udenominator [Action][Calculation][fraction][denominator] uconjg [Action][Complex][conjg] conjg ure [Action][Complex][re] uim [Action][Complex][im] ucExpand [Action][Complex][cExpand] Using the List-CreateSubmenu useq [Action][List][Create][seq] seq uaugment [Action][List][Create][augment] augment urotate [Action][List][Create][rotate] rotate usortA [Action][List][Create][sortA] sortA usortD [Action][List][Create][sortD] umedian [Action][List][Statistics][median] median umode [Action][List][Statistics][mode] mode uQ1 [Action][List][Statistics][Q1] uprod [Action][List][Calculation][prod] prod ucuml [Action][List][Calculation][cuml] cuml uAlist [Action][List][Calculation][Alist] Using the Matrix-CreateSubmenu utrn [Action][Matrix][Create][trn] trn uaugment [Action][Matrix][Create][augment] uident [Action][Matrix][Create][ident] ulistToMat [Action][Matrix][Create][listToMat] umatToList [Action][Matrix][Create][matToList] Using the Matrix-Calculationand Matrix-Row&ColumnSubmenus udim [Action][Matrix][Calculation][dim] udet [Action][Matrix][Calculation][det] ueigVl [Action][Matrix][Calculation][eigVl] eigVl ueigVc [Action][Matrix][Calculation][eigVc] eigVc uLU [Action][Matrix][Calculation][LU] umRow [Action][Matrix][Row&Column][mRow] mRow umRowAdd [Action][Matrix][Row&Column][mRowAdd] mRowAdd urowAdd [Action][Matrix][Row&Column][rowAdd] Using the Vector Submenu uaugment [Action][Vector][augment] ufill [Action][Vector][fill] udim [Action][Vector][dim] uunitV [Action][Vector][unitV] unorm [Action][Vector][norm] ucrossP [Action][Vector][crossP] crossP udotP [Action][Vector][dotP] dotP utoCyl [Action][Vector][toCyl] toCyl z Using the Equation/Inequality Submenu usolve [Action][Equation/Inequality][solve] udSolve [Action][Equation/Inequality][dSolve] urewrite [Action][Equation/Inequality][rewrite] rewrite uexchange [Action][Equation/Inequality][exchange] exchange uabsExpand [Action][Equation/Inequality][absExpand] absExpand uandConnect [Action][Equation/Inequality][andConnect] andConnect ugetRight [Action][Equation/Inequality][getRight] Using the Assistant Submenu uarrange [Action][Assistant][arrange] arrange ureplace [Action][Assistant][replace] replace Assignment of List Data Calculation Results to Variables prob unormPDf [Action][Distribution/Inv.Dist][Continuous][normPDf] normPDf unormCDf [Action][Distribution/Inv.Dist][Continuous][normCDf] utPDf [Action][Distribution/Inv.Dist][Continuous][tPDf] tPDf utCDf [Action][Distribution/Inv.Dist][Continuous][tCDf] tCDf uinvTCDf [Action][Distribution/Inv.Dist][Inverse][invTCDf] uchiCDf [Action][Distribution/Inv.Dist][Continuous][chiCDf] chiCDf uinvChiCDf [Action][Distribution/Inv.Dist][Inverse][invChiCDf] invChiCDf ufPDf [Action][Distribution/Inv.Dist][Continuous][fPDf] ubinomialCDf [Action][Distribution/Inv.Dist][Discrete][binomialCDf] binomialCDf uinvBinomialCDf [Action][Distribution/Inv.Dist][Inverse][invBinomialCDf] invBinomialCDf xInv ugeoPDf [Action][Distribution/Inv.Dist][Discrete][geoPDf] geoPDf ugeoCDf [Action][Distribution/Inv.Dist][Discrete][geoCDf] geoCDf uinvGeoCDf [Action][Distribution/Inv.Dist][Inverse][invGeoCDf] uinvHypergeoCDf [Action][Distribution/Inv.Dist][Inverse][invHypergeoCDf] invHypergeoCDf Using the Financial Submenu Using the Command Submenu uDefine 2-8Using the Interactive Menu Interactive Menu Example [Interactive] menu operations come in handy in the following cases •When you want to use a command on an expression you are calculating •When you want to use a command that requires multiple arguments Using Another Application’s Window To open another application’s window • This displays a palette of application icons 2.Tap the button that corresponds to the window you want to display uTo close another application’s window uTo use Stat Editor to recall a LIST variable created in the work area Using the Geometry Window uTo drag an expression from the work area to the Geometry window Dropping this into the Geometry window: Displays this: 2-10Using Verify uTo start up Verify 1. On the work area window, tap the right most toolbar down arrow button 2. On the icon palette that appears, tap W 2-12Running a Program in the Main Application You can run a program in the Main application or the eActivity application Syntax: Folder name\Program name(parameter) Page Chapter 3: Graph & Table Application Graph window • Clear all of the Graph window contents Zoom Analysis - Trace or Analysis - Sketch 3-1Storing Functions Using Graph Editor Sheets Storing a Function To input this type of expression: x equality Tap [Type] - [x=Type] Input an expression that includes variable y and then press E y inequality Tap [Type], [Inequality], and then tap one of the following: To specify this: Shading the Region Bounded by Two Expressions uTo shade the region bounded by two expressions Overlaying Two Inequalities in an Intersection Plot / Union Plot Intersection Plot: 3-2Using the Graph Window Configuring View Window Parameters for the Graph Window uTo configure View Window parameters To configure this setting: Rectangular Coordinates Use this item: To configure this View Window parameter: Polar Coordinates and Parametric Coordinates View Window Preset Parameters Note: Parameter Name View Window parameter precautions Using View Window Memory Panning the Graph Window You can drag the Graph window screen to scroll (pan) its contents •This causes the graph to be redrawn on the Graph window Scrolling the Graph Window •Tapping the graph controller arrows at the edges of the Graph window To do this on the Graph window: Using Quick Zoom Command View Window Parameter Values*1 xmin Saving a Screenshot of a Graph uTo open a screenshot of a graph uTo save a screenshot of a graph uTo clear the current screenshot of a graph Adjusting the Lightness (Fade I/O) of the Graph Window Background Image 3-3Using Table & Graph Generating a Number Table y=Type: (x, y) number table •Specifying the value range of x, , or t using the Table Input dialog box Tap the [Type] menu, and then select the type uTo generate a number table by assigning list values to x, , or t uTo draw a graph using a number table uTo save a number table to a list Generating Number Table Values from a Graph 0303 To generate number table values from the y = x3 – 3x graph Generating a Summary Table Creating a summary table with the View Window settings Specifying the range of 3-4Using Trace Using Trace to Read Graph Coordinates uTo perform a trace operation On the Graph Editor window, input and store a function, and then tap • Here, input y = x2 – 3 into line y1 3-5Using the Sketch Menu Using Sketch Menu Commands This section describes how to use each of the commands on the [Sketch] menu uTo clear figures inserted using the Sketch menu uTo plot a point on the Graph window uTo write text on the Graph window 1.While the Graph window is active, tap [Analysis], [Sketch], and then [Text] 2.On the dialog box that appears, enter the text you want and then tap [OK] •This displays the word “Text” in the lower right corner of the Graph window 3.Place the stylus on the screen and hold it there 3-6Analyzing a Function Used to Draw a Graph What You Can Do Using the G-SolveMenu Commands Analysis - G-Solve- x-Cal/y-Cal- x-Cal Analysis - G-Solve- x-Cal/y-Cal- y-Cal • Root (the x-intercept) 3-7Modifying a Graph uTo modify a single graph (Direct Modify) uTo modify multiple graphs simultaneously (Dynamic Modify) Chapter 4: Conics Application 4-1Inputting an Equation uTo input an equation using a Conics Form On the Conics Editor window, tap 3.Change the coefficients of the equation as required uTo input an equation manually 4-3Using G-Solveto Analyze a Conics Graph G-Solve- x-Cal/y-Cal- x-Cal G-Solve- x-Cal/y-Cal- y-Cal G-Solve- Focus G-Solve- Vertex uTo determine the focus of the parabola x = 2(y – 1)2 – Chapter 5: Differential Equation Graph Application • Toggle the use of unit vectors on or off for slope field or phase plane graphing Edit - Unit Vectors 5-1Graphing a Differential Equation Graphing a First Order Differential Equation uTo input a first order differential equation and draw a slope field 0501 To input y’ = y2 − x and draw its slope field uTo input initial conditions and graph the solution curves Graphing a Second Order Differential Equation uTo input a second order differential equation and draw a phase plane Graphing an Nth-orderDifferential Equation Configuring and Modifying Initial Conditions uTo modify an initial condition on the Differential Equation Graph window uTo configure new initial conditions on the Differential Equation Graph window Configuring Differential Equation Graph View Window Parameters uTo configure differential equation graph View Window settings Differential equation graph View Window parameters [Window] tab Setting [Solutions] tab 5-2Drawing f(x) Type Function Graphs and Parametric Function Graphs uTo draw an f(x) type function graph uTo draw a parametric function graph 5-3Using Trace to Read Graph Coordinates uTo start a point trace uTo start a graph/curve trace 2.Tap = or [Analysis] - [Trace] To draw this type of graph: Drop this type of expression or value into the Differential Equation Graph window: Chapter 6: Sequence Application Buttons common to multiple windows 6-1Recursive and Explicit Form of a Sequence Determining the General Term of a Recursion Expression About rSolve Calculating the Sum of a Sequence 6-2Graphing a Recursion About LinkTrace Chapter 7: Statistics Application 2.Input the data you want 3.Press Eto store the data in the cell uTo create a list 1.On the Stat Editor window, tap a list name cell to select it 2.Enter up to eight bytes for the list name you want, and then press E 7-2Drawing a Statistical Graph •Function graphs (using the Graph & Table application’s Graph Editor window) Operation Flow Up to Statistical Graphing uTo prepare list data for statistical graphing Prepare the list data using one of the patterns shown below uTo configure statistical graph settings Draw: Type: Single-variable Paired-variable Med-BoxPlot (MedBox) Normal Distribution Curve (NDist) y 2 π σ Histogram Bar Graph (Histogram), Broken Line Graph (Broken) kRegression graphs Linear regression graph Quadratic regression graph Logistic regression graph Regression types: Logistic regression y Overlaying a Regression Graph on a Scatter Plot * You can also overlay on other graph types as well Draw the scatter plot. Here we will use the operation under Overlaying a Function Graph on a Statistical Graph You can overlay an existing statistical graph with any type of function graph 2.Tap ! to display the Graph Editor window 3.Input the function 5.Tap y on the Graph Editor window 7-3Performing Basic Statistical Calculations Calculating Statistical Values uTo display single-variablecalculation results Calculation Methods for Q1 and Q3 , Q on Data] checked: Frequency Cumulative Frequency Cumulative Frequency Ratio uTo display paired-variablecalculation results Performing Regression Calculations uTo view regression calculation results MSe MSe Formulas Linear: 7-4Performing Advanced Statistical Calculations 2.On the Command menu, select the command you want to execute 4.Tap [Next >>] •This displays a screen for specifying conditions and inputting values 5.Input values and configure settings for each of the items on the screen 6.Tap [Next >>] Tests 1-Sample 2-Sample 1-Proportion 2-Proportion Linear Regression n: sample size (nt3) Test (Chi-squareTest) .... [Test] - [χ Test] To specify observed matrix: a Two-WayANOVA .... [Test] - [Two-WayANOVA] Temperature B1 Temperature B2 Time A1 113 Lower, Upper = (o1 – o2) Z Lower, Upper Lower, Upper Lower, Upper = oo Distributions Normal Probability Density .... [Distribution] - [Normal PD] f (x) Calculates the normal probability density for a specified value 2π σ Cumulative Distribution Inverse Binomial Distribution Probability Binomial Cumulative Distribution Inverse Binomial Cumulative Distribution Poisson Cumulative Distribution Inverse Poisson Cumulative Distribution Geometric Distribution Probability Geometric Cumulative Distribution Inverse Geometric Cumulative Distribution Input and Output Terms kInput Terms C-Level Contrib Expected kOutput Terms Err n:df / s SEb Chapter 8: Geometry Application • Display a submenu for drawing a figure of specially shaped figures such as triangles and rectangles (page 156) Draw - Special Polygon 8-1Drawing Figures Drawing a Figure uTo plot a point 1.Tap [Draw] - [Basic Object] - [Point], or tap 2.Tap the location on the screen where you want to plot a point uTo draw a line segment uTo add a labeled point to an existing line uTo draw an infinite line uTo draw a ray uTo draw a vector uTo draw an ellipse uTo draw a hyperbola uTo draw a parabola uTo draw a polygon uTo draw a function uTo draw a polar equation graph uTo draw a parametric equation graph Inserting Text Strings into the Screen Attaching an Angle Measurement to a Figure uTo attach an angle measurement to a figure Example: To attach the measurement of angle A in triangle ABC Coordinates of selected point Any single point (including the apex of a polygon) Direction of line or vector A single line (line segment, infinite line, ray, vector or any side of a polygon) uTo draw a triangle Using the Construct Submenu uTo construct a perpendicular bisector uTo construct a midpoint uTo construct the point of intersection of two lines uTo construct an angle bisector uTo construct a line parallel to another line through a specified point uTo construct a tangent to a curve through a specified point uTo reflect a line segment with respect to a specified line of symmetry uTo translate a line segment by inputting a vector uTo translate a line segment by selecting a vector uTo rotate a line segment uTo dilate a line segment toward a specified center point uTo transform a triangle using a matrix or vector (general transform) Tap [OK]. This performs the parallel displacement and draws triangle A’’B’’C’’ 8-2Editing Figures Selecting and Deselecting Figures uUsing Select • Tap G on the toolbar •To select side BC of the triangle, tap it Moving and Copying Figures uTo move a figure uTo copy a figure Pinning an Annotation on the Geometry Window uTo pin or unpin an annotation on the Geometry window Specifying the Color and Line Type of a Displayed Object uTo specify the color and line type of a particular object uTo specify the color and line type of all the objects on the Geometry window Changing the Display Priority of Objects 8-3Using the Measurement Box Viewing the Measurements of a Figure Icon Icon Name This icon appears when this uTo view the measurements of a line segment Specifying and Constraining a Measurement of a Figure uTo specify and constrain the measure of an angle of a triangle 3.Input 90 into the measurement box and press E • This specifies and constrains the measure of angle B at 90 degrees uTo clear all settings constrained with the measurement box Tap [Edit] and then [Clear Constraints] Changing a Label or Adding a Name to an Element 8-4Working with Animations Using Animation Commands [Edit] – [Animate] [View] – [Animation UI] uTo add an animation and run it uTo replace the current animation with a new one uTo trace a locus of points uTo edit an animation Steps: Animations: Traces: uTo view an animation table 8-5Using the Geometry Application with Other Applications Drag and Drop Geometric Figure Drag and drop into another application transforms to: Copy and Paste Chapter 9: Numeric Solver Application uTo solve an equation 1.On the Numeric Solver window, input an equation Here, we will input the equation 2.Press E 3.Input 2 as the values for variable y (to the right of y=) Chapter 10: eActivity Application 3.After the eActivity is the way you want, tap [File] and then [Save] Inserting Data into an eActivity Text row A text row can be Calculation row uTo insert a calculation row •< indicates the Calculation Input mode is selected 3.Press Eafter inputting an expression to display its result Inserting an Application Data Strip Title Application data strip list To insert this type of application data: Select this [Insert] menu item: Or tap this button: Inserting a Geometry Link Row uTo use a Geometry Link row 10-2Transferring eActivity Files File Compatibility The ClassPad Transferring eActivity Files between a ClassPad Unit and a Computer Transferring eActivity Files between Two ClassPad Units Chapter 11: Financial Application 5.Tap [Calc(1)] and then [Simple Interest] again 6.Change the I% value to 3, tap [SI], and then [SFV] •The SI and SFV values are updated in accordance with the new I% value Page Operations Tap Configuring Financial Application Settings Default settings Local settings Financial Calculation Setting Items 11-2Performing Financial Calculations To perform this type of calculation: Select this menu item: 11-3Calculation Formulas Simple Interest 1 + i × Frac (n) NPV (CF0 t 0) PBP n – NPVn Cost/Sell/Margin Depreciation uStraight-LineMethod uFixed-PercentageMethod uSum-of-the-Years’-DigitsMethod uPRC when “Date” is specified for “Bond Interval” uPRC when “Term” is specified for “Bond Interval” uYLD Break-EvenPoint uProfit (Profit Amount/Ratio Setting: Amount (PRF)) 11-4Financial Calculation Functions Financial Function Syntax This function 11-5Input and Output Field Names APR BAL C/Y Cash Chapter 12: Program Application Program Loader window and Program Editor window common commands O- Window - Program Output or O- Window - Text File Contents 12-1Creating and Running Program Creating a Program S = 2 3 A2, V = 23 A3 uTo create and save a new program 1.On the Program Loader or Program Editor window, tap O After the program is the way you want, tap •To run this program see “Running a Program” on page 2 ⋅ (3) ⋅ A^2 ⇒ S: (2)/3 ⋅ A^3 ⇒ Pausing Program Execution Parameter variable box Main Program: Subroutine: “Sub1” Jumps to subroutine program “Sub1” Subroutine: “Sub2” Using Strings in a Program 3.Input a side length of 7 and tap [OK] Terminating Program Execution Pressing cwhile a program is running terminates the program Creating a Text File uTo create and save a new text file Using Text Files File Name: “CAUTION” Program that displays contents of “CAUTION” file Converting a Text File to a Program File 12-2Debugging a Program •If an error message appears when you try to save the program •If an error message appears when you try to run the program •If a program produces some abnormal or unexpected result Debugging After an Error Message Appears 12-3 User-definedFunctions Creating a New User-definedFunction uTo create and save a new user-definedfunction using the Program Editor window uTo create a user-definedfunction using the Define command Executing a User-definedFunction Editing a User-definedFunction uTo edit a user-definedfunction •Tap the [Type] down arrow button and then select “Function” 4.Edit the expression and/or parameter variables as required 12-4Program Command Reference Using This Reference Break Ctrl - Control Syntax Conventions Command List Symbols (Carriage Return) : (Multi-statementCommand) Ctrl BinomialCD For While Switch BrokenMisc - Statistics(1) - Graph ColorBlack, ColorBlue, ColorRed, ColorMagenta ColorGreen, ColorCyan, ColorYellow I/O - Color CopyVar Cross DispStat Syntax: DispStat DispText Syntax: DispText Function: This command displays the Program Output window DrawSeqEtrCon, DrawSeqEtrPlt DrawSeqEtrCon DrawSeqEtrPlt DrawShade DrawStat GetKey I/O - Input Code GetPen GetVar38kI/O - Communication HypergeoCD HypergeoPD If~Then~ElseIf~Else~IfEndCtrl - If Then IfEnd InputFunc Description: See Input InputStr Syntax: InputStr<variable name>[,"<string 1>"[," <string 2>"]] IntersectionMisc - Graph&Table(1) Local Locate I/O - Output Lock LockFolderMisc - Variable - Folder MultiSortD NDistMisc - Statistics(1) - Graph NewFolderMisc - Variable - Folder Ctrl - For See For~To~(Step~)Next OneVariable OneWayANOVA OpenComPort38kI/O - Communication PeriodsAnnual PeriodsSemi PowerReg (PowerR) Print PrintNatural PTBrokenThck PTDot RclVWinMisc - Graph&Table(2) Syntax: RclVWin{<variable name> ; <folder name\ file name>} Receive38kI/O - Communication Syntax: Receive38k<variable name Function: Receives EA-200data SetAxes SetCellWidthMisc - Setup(4) SetComplexMisc - Setup(1) SetCoord SetDecimal SetReal SetSci SetSequenceMisc - Setup(4) StepDisp SetSimulGraphMisc - Setup(2) StatGraphMisc - Statistics(1) Scatter SinR LogisticR Graph Type 4: Histogram, MedBox, ModBox, NDist, Broken StrLwr StrMid StrRight StrRotate StrShift TPD TwoPropZInt TwoPropZTest TwoSampleFTest TwoSampleTInt SetSmryTable Wait While~WhileEndCtrl - While While~WhileEnd WhileEnd 12-5Including ClassPad Functions in Programs Including Graphing Functions in a Program Including Table & Graph Functions in a Program Including Recursion Table and Recursion Graph Functions in a Program Including Statistical Graphing and Calculation Functions in a Program Chapter 13: Spreadsheet Application Edit - Fill - Fill Range • Display a dialog box for specifying a sequence to fill a range of cells Edit - Fill - Fill Sequence Edit - Sort/Search - Sort, L or : Edit - Sort/Search - Search or e 13-1Inputting and Editing Cell Contents Selecting Cells To select this: Inputting Data into a Cell Inputting a Formula uTo input formula “=mean(B1:B3)” in cell B5 Inputting a Cell Reference There are two types of cell references: relative and absolute Relative Cell Reference Absolute Cell References This cell reference: Cell Data Types (Text Data and Calculation Data) When this data type is Inputting this into Causes this to be displayed: specified: uTo fill a range of cells with the same value (Fill Range) uTo fill a column of cells with a numeric sequence (Fill Sequence) Parameter Using the Cell Viewer Window uTo view or hide the Cell Viewer window Changing the Text Color and Fill Color of Specific Cells Copying or Cutting Cells and Pasting Them to Another Location uTo copy or cut a single cell and paste it to another cell or cells 1.Tap the cell that you want to copy or cut 2.Tap [Edit] - [Copy] (or [Cut]) 4.Tap [Edit] - [Paste] Importing and Exporting Variable Values uTo import the data assigned to a variable LIST variable “{1,2,3}” MAT variable “[[1,2][3,4]]” uTo export spreadsheet data to an EXPR variable 13-2Graphing Basic Graphing Steps The following are the basic steps for graphing spreadsheet data 1.Input the data you want to graph into the spreadsheet 2.Select the cells that contain the data you want to graph • When [Graph] - [Row Series] is selected, each row is treated as one set of data. Item A data (blue), Item B data (red), and Item C data (green) are cumulative, and there are two bars, one for each of the two days of the week. This lets you see the cumulative sales for each day Graph Colors and Color Link 3.Select the color you want and then tap [OK] •This will change the point to the color you selected Line Graph, Column graph, Bar graph: Scatter graph: Histogram, Box Whisker: Graph Menu and Graph Examples [Graph] - [Line] [Clustered] D [Stacked] F [100% Stacked] G [Graph] - [Pie] Z [Graph] - [Scatter] [Graph] - [Histogram] [Graph] - [Box Whisker] Regression Graph Operations (Curve Fitting) uTo plot a scatter graph and then draw its regression graph To draw this: Select this [Calc] menu item: 5.To clear all regression graphs, tap [Edit] - [Clear All] Other Graph Window Operations uTo change the appearance of a graph by dragging a point uTo use drag and drop to obtain the data of a graph Dragging this to a cell in the Creates a table containing these values starting from the 13-3Statistical Calculations Single-variable, Paired-variableand Regression Calculations Prepare this type of data: uTo execute a regression calculation and paste the results into the spreadsheet 3.On the calculation result window, tap the [Output>>] button 4.On the output window, tap [Paste] Link check box Test and Interval Calculations Z Tests, t Tests, Two-Sample F Test, and Interval Calculations Linear Regression t Test χ2 Test χ2 GOF Test One-WayANOVA Two-WayANOVA 13-4Cell and List Calculations Using the Cell Calculation Functions row Function: Returns the row number of a specified cell Syntax: row(cell) Using the List Calculation Functions [Calc] - [List-Statistics]submenu min, max, mean, median, mode, Q1, Q3, percentile, stdDev, variance [Calc] - [List-Calculation]submenu sum, prod, cuml, Alist, percent, polyEval, sequence, sumSeq Chapter 14: System Application Using the Main Memory Sheet and eActivity Sheet Main Memory Sheet This item: Shows how much memory is used by this type of data: eActivity Sheet 14-2Configuring System Settings System Application Menus and Buttons System - Reset or ; System - Initialize or n System - Display Settings or Z To delete this type of data: Select this option: uTo initialize your ClassPad Warning uTo adjust display brightness uTo specify the display language 1.On the System application window, tap [System] - [Language], or • This returns to the application menu uTo specify the complex number imaginary unit (i or j) 1.On the System application window, tap [System] - [Imaginary Unit] uTo optimize Flash ROM (eActivity area and storage area) uTo adjust touch panel alignment uTo view version information uTo register a user name on a ClassPad Chapter 15: Performing Data Communication Wakeup Communication Application Menus and Buttons Link - Transmit or E 15-2Performing Data Communication between the ClassPad and a Personal Computer You can perform the following operations when connected to a computer Transfer data between the ClassPad and a computer Transfer ClassPad display image data to the computer Computer System Requirements Connecting and Disconnecting with a Computer in the USB Flash Mode uTo establish a connection between ClassPad and a computer uTo terminate the connection between the ClassPad and a computer Transferring Data between the ClassPad and a Personal Computer uTo transfer data between ClassPad and a computer Auto Import of VCP Files Rules for ClassPad Files and Folders The following are characters that can be used in file names and folder names VCP and XCP File Operations A save operation saves the following variables and eActivity files uTo open a VCP file uTo create a new VCP file uTo export variable data to XCP files uTo export eActivity data to XCP files uTo import an XCP file 15-3Performing Data Communication between Two ClassPads Connecting to Another ClassPad Unit Transferring Data between Two ClassPads On the sending ClassPad: To list this on the Select Data dialog box: Select this [View] menu command: Select this [All] menu command: On the receiving ClassPad: 15-4Connecting the ClassPad to an EA-200Data Analyzer Connecting a ClassPad to a CASIO EA-200Data Analyzer 1. Turn off the ClassPad and Data Analyzer 15-5Connecting the ClassPad to a Projector Projecting ClassPad Screen Contents from a Projector Precautions when Connecting Appendix Page Page Page System Variable Table Name Type an0 an1 pˆ1 pˆ2 probA probAB probB Σxy Graph Types and Executable Functions : Executable −: Not executable xt Stat Function Error and Warning Message Tables Error Message Table Error Message Page Warning Message Table Warning Message Low Memory Error Processing Resetting and Initializing the ClassPad RAM Reset: Memory Reset: Memory Initialize: uTo perform the RAM reset operation Number of Digits and Precision Number of Digits Standard Mode Decimal Mode Precision Display Brightness and Battery Life Display Brightness Battery Life ClassPad Operation Display Brightness Condition (a) (b) (c) Auto power off: