
Using the CALC Function
k Executing a Statistical CalculationThe following shows an actual example of how to perform a statistical calculation in the S • SHT mode.
u To execute a statistical calculation
| Example | To input the data shown below into a spreadsheet, and then to perform | ||||
| 
 | |||||
| 
 | 
 | 
 | 
 | 
 | 
 | 
| 
 | 
 | Height | Shoe Size | Frequency | 
 | 
| 
 | A | 155 | 23 | 1 | 
 | 
| 
 | 
 | 
 | 
 | 
 | 
 | 
| 
 | B | 165 | 25.5 | 2 | 
 | 
| 
 | C | 180 | 27 | 2 | 
 | 
| 
 | D | 185 | 28 | 1 | 
 | 
| 
 | E | 170 | 25 | 3 | 
 | 
1.Input the statistical data into a spreadsheet.
•Here, we will input data in the A1:B5 range, and the frequency values in the C1:C5 range.
2.Select the range of cells where you input the data (A1:B5).
3.Press 6(g)2(CALC) to display the CALC submenu.
4.Press 6(SET) to display the statistical calculation settings screen.
•The first column of cells you selected in step 2 will be displayed for 1Var XCell, while the second column will be displayed for 2Var YCell.
•You can change the cell ranges manually using the same procedures as those for the graphing cell range settings. See “To change the XCellRange and YCellRange settings manually” (page 
5.Use the f and c cursor keys to move the highlighting to 2Var Freq.
6.Press 2(CELL).
•This enables cell range input for the Frequency setting. The function menu will change to the colon (:).
7.Input the range of cells for the frequency values (C1:C5).
•To input the colon (:), press 1(:).
8.After the settings are the way you want, press w.
20050401