Casio ClassPad 101 User's Guide download pdf (Page 241)

Chapter 13: Spreadsheet Application 241

2. On the menu bar, tap [Calc] and then [Distribution].

• The Distribution Calculation Wizard will appear in the lower half of the display.

3. Tap the v button to the right of the second item from the top and then select the desired distribution

calculation from the menu that appears.

4. Tap [Next >>].

• This will display a screen with the variable assignments for the range you selected in step 1 of this

procedure entered automatically in the input fields as the initial defaults.

5. Enter values for the other variables and then tap [Next >>].

• This displays the calculation results. If there are multiple calculation results, tap V to view them.

• You can tap $ here to display the distribution graph.

6. On the calculation result window, tap the [Output>>] button.

7. On the output window, tap [Paste].

• This pastes the calculation results in formula format.

About DispStat Command

Tapping [Calc] - [DispStat] displays a DispStat window that displays statistical calculation (one-variable, two-

variable, regression, test, interval, distribution, or inverse distribution calculations) results after a calculation is

performed.

Tip: The DispStat window shows statistical calculation results of the last statistical calculation that was executed using

any ClassPad application (except for eActivity). For example, immediately after a calculation is executed using

“NormPD” command in the Main application, that calculation result is displayed on the DispStat window, even with

the Spreadsheet application. However, note that calculation results produced using a mathematical function, such as

“normPDf(”, are not displayed on the DispStat window.

13-4 Cell and List Calculations

Using the Cell Calculation Functions

Spreadsheet application special functions are included on the [Cell-Calculation] submenu of the [Calc] menu.

Selecting a menu item on the [Cell-Calculation] submenu will input the corresponding function into the currently

selected cell. This section provides explanations of the functions and input syntax of the cell calculation

functions.

Function Description

row Function: Returns the row number of a specified cell.

Syntax: row(cell)

col Function: Returns the column number of a specified cell.

Syntax: col(cell)

count Function: Returns a count of the number of cells in the specified range.

Syntax: count(start cell[:end cell])

cellif Function: Evaluates an equality or inequality, and returns one of three different expressions

based on whether the equality/inequality is true (expression 1), false (expression 2),

or inconclusive (expression 3).

With this function, the equality/inequality can include a string as in the following example:

cellif(A1="Red", 0,1,2).

Syntax: cellif(equation, expression 1, expression 2, expression 3)

cellif(inequality, expression 1, expression 2, expression 3)

1303 For each value in cells A1 through A5, to display “Big” in the neighboring B-column cell for values of 5

and greater, and “Small” for values less than 5

1 2 ... 236 237 238 239 240 241 242 243 244 245 246 ... 274 275

Comments to this Manuals

No comments

Casio ClassPad 101 User's Guide Page 241

Comments to this Manuals

Related products and manuals for Mice Casio ClassPad 101