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