Casio ClassPad 101 User's Guide Page 238

  • Download
  • Add to my manuals
  • Print
  • Page
    / 275
  • Table of contents
  • BOOKMARKS
  • Rated. / 5. Based on customer reviews
Page view 237
Chapter 13: Spreadsheet Application  238
u To execute a regression calculation and paste the results into the spreadsheet
1. Enter the paired-variable data into the spreadsheet, and then select the
range of cells where it is located.
2. On the menu bar, tap [Calc] and then [Regression]. Next, on the submenu
that appears, tap the desired regression type.
This displays a window which shows calculation results along with the
model formula for the selected regression type in the lower half of the
display.
For details about each regression type, see “Regression types” (page
133). For information about calculation results other than model formula
coefficients, (
r, MSe, etc.), see “To view regression calculation results”
(page 138).
3. On the calculation result window, tap the [Output>>] button.
You can use this screen to specify the data to be output to the
spreadsheet. Under initial default settings, the Labels and Results check
boxes are selected. Select the check boxes of the items you want to
output.
4. On the output window, tap [Paste].
This pastes a table of system variable labels to which regression
calculation results are assigned, the regression calculation results, and
residual values (items whose check boxes are selected).
Link check box
Changing the range of data you selected on the Spreadsheet window in step 1 above
will cause the regression calculation results displayed on the calculation result window
to be updated automatically. You can disable automatic updating (if you feel that
updating is taking too long or for any other reason) by clearing the Link check box on
the calculation result window.
Tip: For information about regression graphing, see “Regression Graph Operations (Curve Fitting)” (page 234).
Test and Interval Calculations
These calculations use the exact same wizard as the Statistics application.
For details about each calculation, see “Tests” (page 141) and “Confidence Intervals” (page 143) in “7-4 Performing
Advanced Statistical Calculations”. For information about command syntax, see “12-4 Program Command
Reference”.
The following are the differences between these calculations and the Statistics application.
For the Linear Regression
t Test,
χ
2
Test,
χ
2
GOF Test, One-Way ANOVA, and Two-Way ANOVA commands,
you need to input data to be used in the calculation into the spreadsheet beforehand.
The other commands are always executed using a variable type syntax. Values can be input directly on the
wizard screen, or they can be input into a spreadsheets and referenced from there. One line of spreadsheet
data is used for one calculation execution, so calculations can be batch executed by providing the required
number of data lines. For an actual execution example, see “
Z Tests, t Tests, Two-Sample F Test, and
Interval Calculations” below.
After the calculation result window is displayed, an output window can be displayed for outputting calculation
result data to the spreadsheet.
Formats of Data Used for Calculation and Example Calculation
This section specifies the data formats for the data input in the spreadsheet for each type of calculation, and
shows an example of an actual calculation. m and n used in the explanation text below represent any two
natural numbers.
Page view 237
1 2 ... 233 234 235 236 237 238 239 240 241 242 243 ... 274 275

Comments to this Manuals

No comments