[Graph] - [Box Whisker] 1

Min Q1 Med Q3 Max

This type of graph lets you see how a large number of data items are grouped within specific ranges. The lines from Min to Q1, and from Q3 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 Q1, Q3, Med, Min, or Max location of a box whisker graph will cause the applicable value to appear at the bottom of the screen.

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.

uTo 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￿ebx regression curve

Exponential Reg

k

Exponential a￿bx regression curve

abExponential Reg

4

Power regression curve

Power Reg

;

 

 

 

Sinusoidal regression curve

Sinusoidal Reg

5

 

 

 

Logistic regression curve

Logistic Reg

6

 

 

 

Chapter 13: Spreadsheet Application

234