Casio Spreadsheet Application Manual de usuario descargar pdf (Pagina 15)

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008

Choose Scat (F1) Arrow down 1 place

Change X Cell Range to A2:A5 (With Cell Range hi-lighted, arrow past the A2 press the DEL button type 2 EXE

Similarly, change Y Cell range to B2:B5

Set Frequency to 1 (Press F1) This is because the data is not set out as a Frequency Distribution Table. Rather, the data is

in a Column. Therefore each number is 1 score. Therefore the Frequency is set to '1' and NOT to a Column. (Fig66)

Press EXIT GPH1 (F1) (Fig67)

Investigating Correlation:

It seems there is a strong correlation.

To discover the exact correlation we can check the equation of the line of best fit.

Press CALC (F1) then X (F2) (Fig68)

Here is the equation of the line of best fit. Note that 'r' is the coefficient of correlation. R=0.99 indicating a very high

correlation in this case.

Drawing the Line of Best Fit:

Press DRAW (F6) (Fig69)

Tracing the Graph:

The example here is obviously over-simplified for the purposes of instruction. Hopefully you are seeing the potential

applications for these functions of the calculator. Usually in a statistical investigation you would want to trace the graph to

predict values which are not plotted. In fact, given there is never a scale given the 'golden rule' is to trace every graph drawn.

Press SHIFT F1 (Fig70)

Use your arrow left-right to scroll through different values.

Performing a Y-Calculation (Y-CALC):

If we want to find out the exact Y value for a given X value (eg X=5)

Press G-Solv (SHIFT F5) Y-CAL (F1) enter 5 (Fig71)

Fig66

Fig67

Fig68

Fig69

Fig70

Fig71

1 2 ... 10 11 12 13 14 15 16 17 18 19 20 21 22

Sin comentarios

Casio Spreadsheet Application Manual de usuario Pagina 15