Filter
Top Products
Spreadsheet 201
You can also export data from the Spreadsheet app to a
statistics app. See “Entering and editing statistical data” on
page 213 for the general procedure. It can be used in both
the Statistics 1Var and Statistics 2Var apps.
External
functions
You can use in a formula any
function available on the Math,
CAS, App, User or Catlg
menus (see chapter 21,
“Functions and commands” on
page 305). For example, to
find the root of 3 – x
2
closest to
x = 2, you could enter in a cell
S.AAROOTAR3wAs
jo2E. The answer displayed is 1.732…
You could also have selected a function from a menu. For
example:
1. P r e s s
S..
2. Press
D and tap .
3. Select Polynomial > Find Roots.
Your entry line will now look like this: =CAS.proot().
4. Enter the coefficients of the polynomial, in descending
order, separating each with a comma:
Q1o0o3
5. Press
E to see the result. Select the cell and tap
to see a vector containing both roots: [1.732…
–1.732…].
6. Tap to return to the spreadsheet.
Note that the CAS prefix added to your function is to remind you
that the calculation will be carried out by the CAS (and thus a
symbolic result will be returned, if possible). You can also force
a calculation to be handled by the CAS by tapping in
the spreadsheet.
There are additional spreadsheet functions that you can use
(mostly related to finance and statistics calculations). See
“Spreadsheet functions” on page 345.