5. Drawing Statistical Graphs, and Performing Statistical and Regression Calculations

When you want to check the correlation between two sets of data (such as temperature and the price of some product), trends become easier to spot if you draw a graph that uses one set of data as the x-axis and the other set of data as the y-axis.

With the spreadsheet you can input the values for each set of data and draw a scatter plot or other types of graphs. Performing regression calculations on the data will produce a regression formula and correlation coefficient, and you can overlay a regression graph over the scatter plot.

Spreadsheet mode graphing, statistical calculations, and regression calculations use the same functions as the Statistics mode. The following shows an operation example that is unique to the Spreadsheet mode.

kExample of Statistical Graph Operations (GRAPH Menu)

Input the following data and draw a statistical graph (scatter plot in this example).

0.5,

1.2,

2.4,

4.0,

5.2

(x-axis data)

–2.1,

0.3,

1.5,

2.0,

2.4

(y-axis data)

uTo input data and draw a statistical graph (scatter plot)

1. Input the statistical calculation data into the spreadsheet.

•Here we will input the x-axis data into column A, and the y-axis data into column B. 2. Select the range of cells you want to graph (A1:B5).

3. Press 6(g)1(GRAPH) to display the GRAPH menu, and then press 1(GRAPH1).

•This will produce a scatter plot of the data in the range of cells you selected in step 2 of this procedure.

•The graph shown here is what is produced under initial default Spreadsheet mode settings. You can change the configuration of graph settings on the screen that appears when you press 6(SET) on the GRAPH menu. For details see “General Graph Settings Screen Operations” below.

9-27