Chapter 13: Spreadsheet Application
246
Test and Interval Calculations
These calculations use the exact same wizard as the Statistics application.
For details about each calculation, see “Tests” (page 146) and “Confidence Intervals” (page 149) 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.
Z
Tests,
t
Tests, Two-Sample
F
Test, and Interval Calculations
• Operation when inputting values directly on the wizard screen and performing the calculation is identical to
that when “Variable” is elected on the Statistics operation wizard screen.
• When the number of numeric input fields on the wizard screen is
m
, prepare
n
rows and
m
columns of data.
For example, in the case of the 1-Sample
Z
Test, there are four numeric
input fields as shown in the nearby screenshot. In this case, selecting 2 rows
×
4 columns of data (A1:D2) on the spreadsheet and running the wizard will
automatically input cell references into each field as shown in the nearby
screenshot. Increasing the number of rows causes batch calculation of each
line to be performed.
Important!
When you want to batch execute multiple calculations, be sure to input a set of
data for each calculation in each line. Calculation cannot be performed on the
wizard screen when data is grouped by columns.
Example:
To prepare the data shown in the nearby screenshot, select the
range A2:D4, and execute the 1-Sample
Z
Test. In this case, the
condition is
≠
(
≠
0).