Line Table Examples for Variable Data using LOC+

Example 1: LOC in Banner Logic:

This example shows how a banner column can represent a response base, such as rating scale, rather than the traditional respondent base. The logic used in this example results in the following table:

COMPUTER EVALUATION STUDY

PREPARED BY THE ANALYTICAL GROUP, INC.

Rating of Computer Life on:

 

 

 

 

Read-

Coverage

 

Total

Interest

ability

of Issues

 

====

======

=====

=======

Total

375

125

125

125

 

100.0

100.0

100.0

100.0

NO ANSWER

-

-

-

-

NET: HIGH

88

63

48

33

========

23.5

50.4

38.4

26.4

Very High (5)

74

46

11

17

 

19.7

36.8

8.8

13.6

High (4)

70

17

37

16

 

18.7

13.6

29.6

12.8

Medium (3)

111

15

38

58

 

29.6

12.0

30.4

46.4

NET: LOW

80

47

39

34

========

21.3

37.6

31.2

27.2

Low (2)

78

15

37

26

 

20.8

12.0

29.6

20.8

Very Low (1)

42

32

2

8

 

11.2

25.6

1.6

6.4

STATISTIC BASE

375

125

125

125

MEAN

3.1

3.2

3.1

3.1

STANDARD DEVIATION

1.27

1.65

1.00

1.07

STANDARD ERROR

0.15

0.09

0.10

 

 

Because the location is in the banner column, the row logic is used as the starting point. Each banner column uses the row logic plus the LOC number.

Variable

Record Location

Banner Text

Banner

 

1/13+1/14+1/15

Banner pt. 1=Total

LOC+0-2

Q5A

1/13

Banner pt. 2=Interest

LOC+0

Q5B

1/14

Banner pt. 3=Readability

LOC+1

Q5C

1/15

Banner pt. 4=Coverage of Issues

LOC+2

 

Table Logic:

NET: High^

NET 2^L=

 

Very High^

Q5A (5)^

 

High^

Q5A (4)^

 

Medium^

Q5A (3)^

 

NET: Low^

NET 2^L=

 

Low^

Q5A (2)^

 

Very Low^

Q5A (1)^

 

In this table, the mean reflects a mean of all the rating scalesa grand mean.

Example 2: LOC in Table Logic:

The logic used in this example results in this table:

COMPUTER STUDY

PREPARED BY THE ANALYTICAL GROUP, INC.

Computer Life:

 

 

 

VERY

 

 

 

VERY

 

 

TOTAL

HIGH

HIGH

MEDIUM

LOW

LOW

MEAN

 

=====

=====

=====

======

=====

=====

=====

Total

375

74

70

111

78

42

3.1

 

100.0

19.7

18.7

29.6

20.8

11.2

 

Interest

125

46

17

15

15

32

3.2

 

100.0

36.8

13.6

12.0

12.0

25.6

 

Readability

125

11

37

38

37

2

3.1

 

100.0

8.8

29.6

30.4

29.6

1.6

 

Coverage

125

17

16

58

26

8

3.1

of Issues

100.0

13.6

12.8

46.4

20.8

6.4

 

 

Variable

Record Location

Row Text

Row Logic

 

1/13+1/14+1/15

Total

LOC+0-2

Q5A

1/13

Interest

LOC+0

Q5B

1/14

Readability

LOC+1

Q5C

1/15

Coverage of Issues

LOC+2

 

Banner Logic: Q5A (1-5), Q5A (5), Q5A (4), Q5A (3), Q5A (2), Q5A (1), Q5A (1-5)

Because the location is in the row, the banner logic is used as the starting point. Each row uses the banner logic plus the LOC number.

Similar to the Total position, the table filter can represent a response base, rather than a respondent base. The logic for the table filter when the locations are in the rows is LOC+ followed by the range of locations for that table.

Example 3: Using LOC With Other Logic:

If any row of the table must be based on a secondary criterion you can include the additional logic after the LOC instruction.

LOC+1 AND GENDER (1)

Example 4: Using [+] With LOC to increment logic

You can use [+] with LOC to increment banner, row and filter logic elements. Any logic surrounded by [+] is incremented by the LOC instruction. For example, if the logic for banner point 3 is:

LOC+5

and the row definition is:

[+]Q5A (5) AND Q3_1 (2)[+]

then the banner point with LOC+5 references:

Q5F (5) AND Q3_6 (2)

Example 5: Using [X] With LOC to exclude logic from incrementing

You can use [X] with LOC to exclude banner, row and filter logic elements from being incremented. Any logic surrounded by [X] is excluded. For example, if the logic for banner point 3 is:

LOC+5

and the row definition is:

[+]Q5A (5) AND [X]Q12 (2)[X] AND Q3_1 (2)[+]

then banner point three references:

Q5F (5) AND Q12 (2) AND Q3_6 (2)

the Q12 (2) does not get incremented

Related topics:

Line Tables and the LOC Instruction

Incrementing logic for VAR+/LOC+ banners and tables