New Inquirer Spreadsheet Output
Format
In order to provide a column for 182 categories and still
fit on an Excel spreadsheet, each document creates two row, the first
(shown as yellow) for raw counts and the second (shown as blue/green)
for scaled scores. These can be selected by the "r" (for raw) and "s"
(for scaled) in the "format" column, using the Excel "filter" option
or exclude/include selection options in SPSS or JMP.
Note that the first three columns were produced from the file
names, for example, "bradley speech race3" yielded the information
for the first four columns.
The scaled scores are as a percentage to one decimal place. For
example, in the first document, there were 135 leftover words (words
not in the Inquirer dictionary, which was 4.1% of the text. In the
text, there were 6.5% positive words and 1.8% negative words, etc.
Primary candidates
Person
|
Form
|
Topic
|
Serial#
|
format
|
wordcount
|
leftovers
|
Positiv
|
Negativ
|
Affil
|
Hostile
|
Strong
|
bradley
|
speech
|
announce
|
1
|
r
|
3,312
|
135
|
215
|
61
|
131
|
23
|
319
|
bradley
|
speech
|
announce
|
1
|
s
|
3,312
|
4.1
|
6.5
|
1.8
|
4.0
|
0.7
|
9.6
|
bradley
|
speech
|
announce
|
2
|
r
|
805
|
21
|
72
|
18
|
37
|
5
|
125
|
bradley
|
speech
|
announce
|
2
|
s
|
805
|
2.6
|
8.9
|
2.2
|
4.6
|
0.6
|
15.5
|
bradley
|
speech
|
campaignfinance
|
1
|
r
|
3,687
|
154
|
211
|
87
|
106
|
35
|
404
|
bradley
|
speech
|
campaignfinance
|
1
|
s
|
3,687
|
4.2
|
5.7
|
2.4
|
2.9
|
0.9
|
11.0
|
bradley
|
speech
|
democrat
|
1
|
r
|
3,491
|
86
|
238
|
94
|
171
|
24
|
439
|
bradley
|
speech
|
democrat
|
1
|
s
|
3,491
|
2.5
|
6.8
|
2.7
|
4.9
|
0.7
|
12.6
|
bradley
|
speech
|
family
|
1
|
r
|
3,396
|
141
|
294
|
75
|
180
|
16
|
369
|
bradley
|
speech
|
family
|
1
|
s
|
3,396
|
4.2
|
8.7
|
2.2
|
5.3
|
0.5
|
10.9
|
bradley
|
speech
|
foreign
|
1
|
r
|
2,785
|
101
|
144
|
54
|
69
|
25
|
292
|
bradley
|
speech
|
foreign
|
1
|
s
|
2,785
|
3.6
|
5.2
|
1.9
|
2.5
|
0.9
|
10.5
|
bradley
|
speech
|
foreign
|
2
|
r
|
3,068
|
96
|
181
|
64
|
62
|
33
|
283
|
bradley
|
speech
|
foreign
|
2
|
s
|
3,068
|
3.1
|
5.9
|
2.1
|
2.0
|
1.1
|
9.2
|
bradley
|
speech
|
gunviolence
|
1
|
r
|
3,005
|
133
|
179
|
209
|
107
|
153
|
449
|
bradley
|
speech
|
gunviolence
|
1
|
s
|
3,005
|
4.4
|
6.0
|
7.0
|
3.6
|
5.1
|
14.9
|
bradley
|
speech
|
healthcare
|
1
|
r
|
3,821
|
138
|
351
|
137
|
187
|
28
|
445
|
bradley
|
speech
|
healthcare
|
1
|
s
|
3,821
|
3.6
|
9.2
|
3.6
|
4.9
|
0.7
|
11.6
|
bradley
|
speech
|
poverty
|
1
|
r
|
3,412
|
91
|
195
|
136
|
121
|
26
|
313
|
bradley
|
speech
|
poverty
|
1
|
s
|
3,412
|
2.7
|
5.7
|
4.0
|
3.5
|
0.8
|
9.2
|
bradley
|
speech
|
poverty
|
2
|
r
|
3,354
|
103
|
206
|
87
|
162
|
24
|
303
|
bradley
|
speech
|
poverty
|
2
|
s
|
3,354
|
3.1
|
6.1
|
2.6
|
4.8
|
0.7
|
9.0
|
bradley
|
speech
|
president
|
1
|
r
|
648
|
23
|
31
|
4
|
16
|
0
|
61
|
bradley
|
speech
|
president
|
1
|
s
|
648
|
3.5
|
4.8
|
0.6
|
2.5
|
0.0
|
9.4
|
bradley
|
speech
|
race
|
1
|
r
|
3,244
|
119
|
152
|
66
|
94
|
24
|
329
|
bradley
|
speech
|
race
|
1
|
s
|
3,244
|
3.7
|
4.7
|
2.0
|
2.9
|
0.7
|
10.1
|
bradley
|
speech
|
race
|
2
|
r
|
5,372
|
244
|
296
|
251
|
179
|
110
|
528
|
bradley
|
speech
|
race
|
2
|
s
|
5,372
|
4.5
|
5.5
|
4.7
|
3.3
|
2.0
|
9.8
|
bradley
|
speech
|
race
|
3
|
r
|
1,225
|
132
|
45
|
74
|
37
|
41
|
116
|
bradley
|
speech
|
race
|
3
|
s
|
1,225
|
10.8
|
3.7
|
6.0
|
3.0
|
3.3
|
9.5
|
bradley
|
speech
|
race
|
4
|
r
|
4,166
|
160
|
265
|
214
|
143
|
79
|
460
|
bradley
|
speech
|
race
|
4
|
s
|
4,166
|
3.8
|
6.4
|
5.1
|
3.4
|
1.9
|
11.0
|
bradley
|
speech
|
race
|
5
|
r
|
3,468
|
132
|
217
|
162
|
104
|
55
|
389
|
bradley
|
speech
|
race
|
5
|
s
|
3,468
|
3.8
|
6.3
|
4.7
|
3.0
|
1.6
|
11.2
|
bradley
|
speech
|
union
|
1
|
r
|
5,169
|
163
|
228
|
79
|
108
|
17
|
403
|
bradley
|
speech
|
union
|
1
|
s
|
5,169
|
3.2
|
4.4
|
1.5
|
2.1
|
0.3
|
7.8
|
buchanan
|
speech
|
abortion
|
1
|
r
|
2,793
|
180
|
100
|
89
|
68
|
45
|
286
|
buchanan
|
speech
|
abortion
|
1
|
s
|
2,793
|
6.4
|
3.6
|
3.2
|
2.4
|
1.6
|
10.2
|
buchanan
|
speech
|
agriculture
|
1
|
r
|
2,254
|
206
|
94
|
105
|
61
|
42
|
221
|
buchanan
|
speech
|
agriculture
|
1
|
s
|
2,254
|
9.1
|
4.2
|
4.7
|
2.7
|
1.9
|
9.8
|
buchanan
|
speech
|
announce
|
1
|
r
|
2,285
|
110
|
138
|
88
|
114
|
44
|
261
|
buchanan
|
speech
|
announce
|
1
|
s
|
2,285
|
4.8
|
6.0
|
3.9
|
5.0
|
1.9
|
11.4
|
buchanan
|
speech
|
china
|
1
|
r
|
2,479
|
204
|
113
|
138
|
62
|
94
|
334
|
buchanan
|
speech
|
china
|
1
|
s
|
2,479
|
8.2
|
4.6
|
5.6
|
2.5
|
3.8
|
13.5
|
buchanan
|
speech
|
foreign
|
1
|
r
|
2,101
|
158
|
117
|
86
|
66
|
48
|
213
|
buchanan
|
speech
|
foreign
|
1
|
s
|
2,101
|
7.5
|
5.6
|
4.1
|
3.1
|
2.3
|
10.1
|
buchanan
|
speech
|
republicans
|
1
|
r
|
2,066
|
235
|
126
|
103
|
67
|
64
|
258
|
buchanan
|
speech
|
republicans
|
1
|
s
|
2,066
|
11.4
|
6.1
|
5.0
|
3.2
|
3.1
|
12.5
|
buchanan
|
speech
|
stump
|
1
|
r
|
2,013
|
160
|
127
|
51
|
70
|
25
|
211
|
buchanan
|
speech
|
stump
|
1
|
s
|
2,013
|
7.9
|
6.3
|
2.5
|
3.5
|
1.2
|
10.5
|
buchanan
|
speech
|
trade
|
1
|
r
|
3,317
|
224
|
145
|
116
|
68
|
39
|
340
|
buchanan
|
speech
|
trade
|
1
|
s
|
3,317
|
6.8
|
4.4
|
3.5
|
2.1
|
1.2
|
10.3
|
buchanan
|
speech
|
values
|
1
|
r
|
3,254
|
253
|
194
|
107
|
140
|
65
|
258
|
buchanan
|
speech
|
values
|
1
|
s
|
3,254
|
7.8
|
6.0
|
3.3
|
4.3
|
2.0
|
7.9
|
bush
|
speech
|
agriculture
|
1
|
r
|
1,238
|
28
|
93
|
59
|
58
|
19
|
155
|
bush
|
speech
|
agriculture
|
1
|
s
|
1,238
|
2.3
|
7.5
|
4.8
|
4.7
|
1.5
|
12.5
|
bush
|
speech
|
announce
|
1
|
r
|
2,036
|
53
|
187
|
67
|
98
|
23
|
208
|
bush
|
speech
|
announce
|
1
|
s
|
2,036
|
2.6
|
9.2
|
3.3
|
4.8
|
1.1
|
10.2
|
bush
|
speech
|
announce
|
2
|
r
|
1,048
|
13
|
92
|
16
|
53
|
4
|
139
|
bush
|
speech
|
announce
|
2
|
s
|
1,048
|
1.2
|
8.8
|
1.5
|
5.1
|
0.4
|
13.3
|
bush
|
speech
|
defense
|
1
|
r
|
3,306
|
110
|
276
|
161
|
185
|
101
|
532
|
bush
|
speech
|
defense
|
1
|
s
|
3,306
|
3.3
|
8.3
|
4.9
|
5.6
|
3.1
|
16.1
|
bush
|
speech
|
education
|
1
|
r
|
3,444
|
126
|
342
|
141
|
157
|
68
|
364
|
bush
|
speech
|
education
|
1
|
s
|
3,444
|
3.7
|
9.9
|
4.1
|
4.6
|
2.0
|
10.6
|
bush
|
speech
|
education
|
2
|
r
|
3,792
|
149
|
302
|
126
|
155
|
34
|
453
|
Last Updated on 8/23/00
By Philip Stone
Return to Home Page |