1.In the Statewide Assessment, choose the uniqueness study.
2. | Use no limits or settings. (If you do one of the other studies, you will need to use the limits.)
3. | Using the export button at the top of the page, export the data to an excel file. It will be a .csv file, but I would advise saving it as an excel spreadsheet so that it will be easier to work with. The result should look like this:
| DIVISION | Unique | Shared By 2 | Shared By 3 | Shared By 4 |
| Language and Literature | 813989 | 365675 | 184935 | 84193 |
| History | 456331 | 208377 | 80682 | 47641 |
| Business & Economics | 294927 | 175982 | 49593 | 31333 |
| Philosophy & Religion | 292184 | 97680 | 45559 | 29043 |
| Medicine | 136168 | 57521 | 34180 | 23629 |
| Engineering & Technology | 166998 | 59514 | 30587 | 18363 |
| Art and Architecture | 150583 | 63819 | 28308 | 16630 |
| Sociology | 129513 | 52320 | 23237 | 14978 |
| Education | 126064 | 37188 | 15503 | 9842 |
| Political Science | 101635 | 44699 | 18302 | 11354 |
| Law | 104370 | 41729 | 17963 | 12609 |
| Reference | 95212 | 38088 | 17960 | 10581 |
| Geography & Earth Sci. | 104672 | 30727 | 12310 | 7483 |
| Agriculture | 99213 | 19465 | 8368 | 5669 |
| Biological Sciences | 58041 | 23294 | 12981 | 8447 |
| Physics | 42734 | 20256 | 13825 | 6667 |
| Music | 48207 | 20088 | 9071 | 5655 |
| Mathematics | 40823 | 11761 | 6961 | 4993 |
| Psychology | 34039 | 11475 | 6078 | 3932 |
| Performing Arts | 28047 | 12042 | 6164 | 3634 |
| Physical Education | 28761 | 10473 | 5487 | 4240 |
| Anthropology | 25590 | 11686 | 4819 | 2901 |
| Computer Science | 21221 | 10176 | 5945 | 4077 |
| Chemistry | 11726 | 4930 | 2831 | 2102 |
I eliminated the no call number row, but you may not want to do that. There will be up to 72 columns.
4. Divide each row by the number in the header. In other words, in the column that is shared by two, you would divide the number in the columns by 2, in the column that is shared by 3, you would divide by 3, and so on. You can add a column, write a formula to do the divisions and use the paste special to create a column of values.
5. Once you have deduplicated each column, you will need to sum each row. The resulting sum is the total deduplicated count for that division. The results would look like this:
| DIVISION | Titles | Percent |
| Language and Literature | 1,671,899 | 23.71% |
| History | 938,152 | 13.30% |
| Business & Economics | 670,172 | 9.50% |
| Philosophy & Religion | 546,617 | 7.75% |
| Medicine | 324,730 | 4.60% |
| Engineering & Technology | 318,764 | 4.52% |
| Art and Architecture | 312,581 | 4.43% |
| Sociology | 296,835 | 4.21% |
| Education | 240,897 | 3.42% |
| Political Science | 222,889 | 3.16% |
| Law | 218,922 | 3.10% |
| Reference | 195,355 | 2.77% |
| Geography & Earth Sci. | 176,976 | 2.51% |
| Agriculture | 141,938 | 2.01% |
| Biological Sciences | 133,155 | 1.89% |
| Physics | 107,449 | 1.52% |
| Music | 103,592 | 1.47% |
| Mathematics | 87,751 | 1.24% |
| Psychology | 76,029 | 1.08% |
| Performing Arts | 66,468 | 0.94% |
| Physical Education | 59,656 | 0.85% |
| Anthropology | 55,114 | 0.78% |
| Computer Science | 55,010 | 0.78% |
| Chemistry | 31,094 | 0.44% |
| 7,052,045 | 100.00% |
I added in the percentages, because I think that’s interesting.
If you have further questions, please let me know mmunroe@niu.edu.
|