EasyManua.ls Logo

HP 95LX - Page 74

HP 95LX
164 pages
Save Page as PDF
Print Icon
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Loading...
Data
Tables
in
1-2-3
A
data
table
shows
the
results
as
youvary
one
or
two
input
variables
in
a
formula—
essentially,
a
sensitivity
analysis.
There
are
two
kinds
of
data
tables
in
1-2-3:
To
study
the
effects
on
formula(s)
of
varying
one
variable
in
(each)
formula:
1.
Open
the
worksheet
containing
a
formula
or
formulas
whose
variable
you
wish
to
explore.
Be
sure
that
each
variable
in
the
formula
has
its
own
input
cell.
2.
Reserve
aclear
area
ofthe
worksheet
forthe
data
table.
You'll
need
a
minimum
of
two
columns
(an
extra
column
for
each
additional
formula
other
than
the
first
one)
and
a
row
for
each
different
value
of
the
variable
you
use.
3.
Enter
the
formulain
the
first
row
of
the
table
(or
a
cell
reference
to
the
formula)
at
the
top
of
the
second
column.
4.
Enter
the
input
values
of
the
variable
you
want
to
explore
into
the
first
column
of
the
data
table,
beginning
with
the
second
row.
5.
Press
MENU),
(Dlata,
(Table,
(1)
to
indicate
you're
using
the
first
kind
of
table.
6.
Type
in
the
entire
range
of
the
data
table
and
press
[ENTER].
7.
Typein
the
cell
reference
to
the
input
cell
(not
in
the
data
table)
of
the
variable
under
examination
and
press
[ENTER].
To
study
the
effect
in
one
formula
of
varying
two
of
its
variables:
1.
Open
the
worksheet
containing
the
target
formula
containing
the
two
vari-
ables
you
wish
to
explore
using
a
data
table.
Be
sure that
each
variable
has
its
own
input
cell
(this
is
normally
the
case).
2.
Reserve
a
clear
area
of
the
worksheet
for
the
data
table.
3.
Enter
the
formula
(or
a
cell
reference)
in
the
upper
left
cell
of
the
table.
4.
Enter
the
input
values
of
the
first
variable
you
want
to
explore
into
the
first
column
of
the
data
table,
beginning
with
the
second
row.
5.
Enter
theinput
values
of
the
second
variable
into
the
first
row
of
the
data
table,
beginning
with
the
second column.
6.
Press
(MENU),
(Data,
(Table,
(2)
to
indicate
you're
using
the
second
kind
of
table.
7.
Type
in
the
entire
range
of
the
data
table
and
press
(ENTER).
8.
Type
in
the
cell
reference
to
the
input
cell
(not
in
the
data
table)
of
the
first
variable
under
examination
and
press
[ENTER).
9.
Type
in
the
cell
reference
to
the
input
cell
of
the
second
variable
under
examination
and
press
(ENTER).
74
2.
ANALYZING
INFORMATION

Table of Contents

Related product manuals