Use 'File > Load ' to load ThreeNetSciResearchers.isi, which is a file that contains all of Wasserman's, Vespignani's and Barabási's ISI records and is provided as a sample dataset in 'yourSci2directory/sampledata/scientometrics/isi/ThreeNetSciResearchers.isi'. The result is two new tables in the Data Manager. The first is a table with all ISI records. The second is a derived (indented) table with unique ISI records named '262 Unique ISI Records'. In the latter file, ISI records with unique ID numbers (UT field) are merged, and only the record with the higher citation count (CT value) is kept. Select the '262 Unique ISI Records' table and run 'Analysis > Temporal > Burst Detection' using the parameters:
A third table (derived from '262 Unique ISI Records') labeled 'Burst detection analysis ...' will appear in the Data Manager. On a PC running Windows, right click on this table and select view to see the data in Excel. On a Mac or a Linux system, right click and save the file, then open using the spreadsheet program of your choice. The table has 6 columns. The first column lists bursting words, here author names, the length of the burst, the burst weight, burst strength, together with the burst start and end year. Note that words can burst multiple times. If they do, then the burst 'weight' indicates how much support there is for the burst above the previous bursting level, while 'strength' indicates how much support there is for the burst over the non-bursting baseline. Since the burst detection algorithm was run with 'bursting state = 1', i.e., modeled only one burst per word, the burst weight is identical to the burst strength in this output.
Select 'OK' and then repeat step three, using the formula below:
4. Once both formatting rules have been established, select 'Conditional Formatting > Manage Rules', highlight the first formatting rule and move to the top of the list:
5. Make sure both formatting rules are selected and apply them to current selection. Apply the format to all cells in the word by year matrix. The result for the given example is shown in Figure 5.33
Figure 5.33: Visualizing burst results in MS Excel