Chapter 13: Spreadsheet Application  247
1. On the Spreadsheet window, input the data and then select input range cells
A2:D4.
2. Tap [Calc] - [Test] - [One-Sample Z-Test], and then tap [Next>>].
3. This will automatically insert the cell references into the fields as shown in
the nearby screenshot (lower half).
• You can also directly input reference cell ranges for each field. If you
do, however, you can specify in the column direction (such as A1:A3).
Specifying in the row direction (such as A1:C1) will cause an error.
4. Tap [Next>>].
• A calculation is executed for each line of input data, which obtains three
results for
z value. The calculation results for each line can be displayed by
tapping the down arrow button (v) of each field on the calculation result
window.
5. To graph the calculation results as a normal distribution graph, tap $.
Linear Regression t Test
In a spreadsheet, input paired-variable data (page 245 (c) or (d)) as test data.
1301 To perform a Linear Regression
t Test on the paired-variable data
shown in the nearby screenshot
χ
2
Test
For test data, input data of at least one row and two columns (observed matrix) into the spreadsheet. You can
see an actual example ( 0704 ) of how this is done using the Statistics application in Chapter 7 of this manual.
χ
2
GOF Test
For test data, input two lists (observed list and expected list) into the spreadsheet. This is equivalent to inputting
two rows of data of n lines. You can see an actual example ( 0705 ) of how this is done using the Statistics
application in Chapter 7 of this manual.
One-Way ANOVA
For test data, input data (Factor A) into the spreadsheet that is n rows × 2 columns up to n × 6 columns. You
can see an actual example ( 0706 ) of how this is done using the Statistics application in Chapter 7 of this
manual.
To Next Page
Loading...
Need help?
General
