Series IMP

Data from the IMP Series Textbooks:

  • IMP Yr 1a Patterns
  • IMP Yr 1b Overland Trail
  • IMP Yr 2a Cookies
  • IMP Yr 2b Fireworks
  • IMP Yr 2c All About Alice
  • IMP YR 3a Meadows or Malls
  • IMP Yr 3b Small World

Table of Contents

Timeline Graph

Comments

  • Updated graphs to show both Year and individual volumes. -- DickFurnas - 19 Apr 2012
  • Topic Codes of 0 no longer appear in the graphs. -- DickFurnas - 19 Apr 2012
  • Summary Counts for Codes at the 100 level (Code00) and CogBeh by Year and totals for the series. Also, the Timeline Graphs are now current, the data points are now done with an opacity of .33 so overlapping points are more readily distinguished. Zoom in on the pdf to appreciate the goodness. -- DickFurnas - 18 Apr 2012
  • The latest IMP data tweaks are now in IMP_Reconciled.ods no extraneous sheets remain in the spreadsheet. Further sanity checks found a missing CogBeh row. -- DickFurnas - 16 Apr 2012
  • Uploaded latest :ods: spreadsheet. The new sheet IMP_Data_noJ was made by pasting from the original excel spreadsheets again, this time deleting the portion of column I where a column J was present. A further spreadsheet checks that both IMP_Data and IMP_Data_noJ sheets have the same data throughout except for the mergers. All looks good. -- DickFurnas - 09 Mar 2012
  • Added Sanity Checks below for all columns in the sheet IMP_Data_noJ of the :ods: spreadsheet. -- DickFurnas - 09 Mar 2012
  • Comment 2 -- DickFurnas - 09 Mar 2012
  • Comment 1 -- DickFurnas - 09 Mar 2012

Summary Counts

Year1 Year2 Year3 Code00 Total
22 51   100 73
66 14 21 200 101
49 59 37 300 145
2   12 400 14
333 236 111 500 680
34 237 294 600 565
38 7 16 700 61
  1 38 800 39
8   3 900 11
20   5 1000 25
1     1100 1
    84 1200 84
    5 1300 5
15 54 48 1400 117
187 247 159 1500 593
9 2   1600 11
784 908 833 Totals 2525

Year1 Year2 Year3 CogBeh Total
383 420 433 A 1236
44 107 73 K 224
96 95 84 R 275
523 622 590 Totals 1735

Sort of Codes:
Sort by Code:
2702 
1235 A
 224 K
   7 NMA
 275 R
   1 100
   1 101
   1 102
   3 103
   9 108
  25 110
  10 111
  13 112
   5 113
   5 116
  16 201
   9 202
   3 203
  39 204
   3 210
  18 217
  13 218
   1 300
   4 301
   5 303
   1 304
  17 305
  50 306
   3 307
   5 309
   2 310
   1 311
   2 312
   4 313
  50 314
   1 400
  12 402
   1 403
 107 502
  33 503
  10 504
  21 505
  58 506
  65 507
  47 508
  22 509
 171 510
  80 511
  58 512
   3 513
   5 514
  53 601
 165 602
  27 603
   4 604
  75 605
  33 607
  57 608
   5 612
  41 613
  14 614
  49 615
  42 616
   8 703
   1 705
   5 707
   7 708
  19 711
  15 714
   6 717
  11 804
  28 806
   3 901
   8 907
   5 1001
  20 1003
   1 1107
   2 1201
   3 1202
  23 1204
   1 1205
  55 1206
   3 1301
   2 1303
  23 1402
  76 1404
   3 1406
  14 1407
   1 1410
  97 1501
   2 1502
 118 1503
 189 1504
   1 1505
  11 1507
 115 1508
   2 1510
   8 1513
  23 1514
   6 1515
   7 1516
  13 1517
   1 1590
  10 1602
   1 1604
Sort by Frequency:
2702 
1235 A
 275 R
 224 K
 189 1504
 171 510
 165 602
 118 1503
 115 1508
 107 502
  97 1501
  80 511
  76 1404
  75 605
  65 507
  58 512
  58 506
  57 608
  55 1206
  53 601
  50 314
  50 306
  49 615
  47 508
  42 616
  41 613
  39 204
  33 607
  33 503
  28 806
  27 603
  25 110
  23 1514
  23 1402
  23 1204
  22 509
  21 505
  20 1003
  19 711
  18 217
  17 305
  16 201
  15 714
  14 614
  14 1407
  13 218
  13 1517
  13 112
  12 402
  11 804
  11 1507
  10 504
  10 1602
  10 111
   9 202
   9 108
   8 907
   8 703
   8 1513
   7 NMA
   7 708
   7 1516
   6 717
   6 1515
   5 707
   5 612
   5 514
   5 309
   5 303
   5 116
   5 113
   5 1001
   4 604
   4 313
   4 301
   3 901
   3 513
   3 307
   3 210
   3 203
   3 1406
   3 1301
   3 1202
   3 103
   2 312
   2 310
   2 1510
   2 1502
   2 1303
   2 1201
   1 705
   1 403
   1 400
   1 311
   1 304
   1 300
   1 1604
   1 1590
   1 1505
   1 1410
   1 1205
   1 1107
   1 102
   1 101
   1 100

Sanity Checks

Sanity checks of the data were performed on the columns of data in the master spreadsheet, summarizing the number of occurrances of various entries. These provided clues to data entry errors such as entries in the wrong column or the like. These were similar to the summaries for Topic and CogBeh codes but were arranged explicitly by column in the master spreadsheet. They were presented as tables which could be sorted by clicking on the column header of the table.

  • Created by copying the column from the spreadsheet to the clipboard and invoking the following command in Terminal on the Mac before pasting in here:
pbpaste | sort -n | uniq -c | sed -e 's/^ */|/' -e 's/ /|/' -e 's/$/|/' | pbcopy

Column A

Count Entry
0 Errors Remain
0 Totals

Column B

Count Entry
0 Errors Remain
0 Totals

Column C

Count Entry
0 Errors Remain
0 Totals

Column D

Count Entry
0 Errors Remain
0 Totals

Column E

Count Entry
0 Errors Remain
0 Totals

Column F

Count Entry
0 Errors Remain
0 Totals

Column G

Count Entry
0 Errors Remain
0 Totals

Column H

Count Entry
0 Errors Remain
0 Totals

Column I

Count Entry
0 Errors Remain
0 Totals


-- DickFurnas - 2012-03-05

Topic attachments
I Attachment HistorySorted ascending Action Size Date Who Comment
PNGpng IMP_Timeline_Graph.png r10 r9 r8 r7 r6 manage 42.2 K 2012-04-19 - 05:45 DickFurnas  
Texttxt IMP_Reconciled.txt r2 r1 manage 86.6 K 2012-04-19 - 00:08 DickFurnas  
Unknown file formatods IMP_Reconciled.ods r8 r7 r6 r5 r4 manage 83.6 K 2012-04-19 - 00:04 DickFurnas Colored Column J by Year
PDFpdf IMP_Timeline_Graph.pdf r8 r7 r6 r5 r4 manage 683.8 K 2012-04-19 - 05:45 DickFurnas  
Edit | Attach | Watch | Print version | History: r13 < r12 < r11 < r10 < r9 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r10 - 2012-04-19 - DickFurnas
 
  • Edit
  • Attach
This site is powered by the TWiki collaboration platform Powered by Perl This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.