uTo 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 CalculationsThese 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.

Chapter 13: Spreadsheet Application

238