Chapter 13: Spreadsheet Application 234
[Graph] - [Box Whisker] 1
This type of graph lets you see how a large number of data items are grouped
within specific ranges. The lines from Min to Q
1
, and from Q
3
to Max are called
“whiskers”. If [Calc] - [Show Outliers] box is checked on the Spreadsheet Graph
window, “outlier” circular symbols are shown instead of “whisker” lines where a
data value is relatively large or small compared to the other data values.
• When you select a box whisker graph, each column will be displayed as a
separate box whisker.
• Tapping the Q
1
, Q
3
, Med, Min, or Max location of a box whisker graph will
cause the applicable value to appear at the bottom of the screen.
Q
3
MedMin MaxQ
1
Regression Graph Operations (Curve Fitting)
After plotting a scatter graph using paired-variable (x, y) data on the spreadsheet, you can draw a regression
graph that approximates the scatter graph and determine the regression formula.
u To plot a scatter graph and then draw its regression graph
1. Enter the paired-variable data into the spreadsheet, and then select the range of cells where it is located.
• For information about how data is treated based on the range of cells that are selected, see “[Graph] -
[Scatter]” (page 233) under “Graph Menu and Graph Examples”.
2. Tap [Graph] and then [Scatter].
• This will open the Graph window in the lower half of the display and plot the scatter graph.
3. When plotting a scatter graph with multiple
y-values, select one of the y-value plots that you want to use for
drawing the regression graph by tapping it.
4. On the Graph window, perform the following steps.
To draw this: Select this [Calc] menu item: Or tap this:
Linear regression curve Linear Reg
d
Med-Med graph MedMed Line
2
Quadratic regression curve Quadratic Reg
f
Cubic regression curve Cubic Reg
g
Quartic regression curve Quartic Reg
h
Quintic regression curve Quintic Reg
j
Logarithmic regression curve Logarithmic Reg
l
Exponential
aؒe
bx
regression curve
Exponential Reg
k
Exponential
aؒb
x
regression curve
abExponential Reg
4
Power regression curve Power Reg
;
Sinusoidal regression curve Sinusoidal Reg
5
Logistic regression curve Logistic Reg
6
