Ctrl ↑

Type A1 in Name Box

Ctrl ↓

A characteristic of members of a population

Ex.

• Height
• Gender
• Salary 

Variable

(or field or attribute)

Observation

(or case or record)

A variable in which meaningful

arithmitic can be performed

A variable in which meaningful

arithmitic can NOT be performed

If a categorical variables value

has natural ordering

If categorical variables values

do not have natural ordering

When a numerical variable has been

catagorized into

discrete catagories

A numerical variable that results from a count

Ex.

• Number of Children 

Result of a continuous measurment

Ex.

• Weight and Height 

Data on a cross section of a population at a

distinct point in time

The $

If the $ sign is next to the cell referenced it will become Fixed or Absolute

 NO $

added to the cell reference it will be Relative

Alt

Enter

To define, delete or change a name of a cell or a range

highlight and go to the __________ tab, then ____________ and __________

• Formulas
• Name Manager
• Edit, delete or new

False gives ________

True gives ________

• Exact

• Approximate 

In the formulas argument a (      )

means that something is _______

In the formulas argument a [        ]

means that something is _______

_____ look up is Vertical

_____ look up is Horizontal

V Look up

H Look up

One way

Data table

Two Way

Data table

=Now() gives you?

&

F2 gives you?

Current Date & Time

Updated Date & Time