9-27
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.
k Example 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)
u To 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.
To Next Page
Loading...
