{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["README","立川市の降雨確率","作図マニュアル","1DIM","2DIM","CANONICALFORM"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["http://hdl.handle.net/10787/00034292"]
["分割表可視化ツール"]
["2021.10.26"]
["石黒真木夫＠統計数理研究所名誉教授"]
[]
["１／９．いかなるデータも適当にカテゴライズすることによって 分割表の形に集約できる。しかし、分割表として捉えられた内容は必ずしも見やすくない。"]
["２／９．ある変数を目的変数とし、他の変数を説明変数とする条件つき確率分布の形にすることによっていくらか分割表の内容は見やすくなるが、"]
["　　　　　説明変数の数が２以上になるとデータの全体的な構造を条件付き確率分布の集まりから読みとることはむずかしくなる。"]
["３／９．このファイルに組み込まれたツールによって目的変数の分布の説明変数への依存を可視化することができる。"]
["　　　　　ただし、説明変数の数が２を超える場合には、可視化に使用する説明変数２つを指定する必要がある。"]
["４／９．目的変数が離散値変数である場合には、目的変数が指定した値をとる確率が説明変数に依存する様子が表示される。"]
["５／９．目的変数が連続値変数である場合には、目的変数の中央値, G.MEDIAN を求め、目的変数が G.MEAN 以上の値をとる確率が説明変数に依存する様子が表示される。"]
["６／９．説明変数の値は、矩形領域の配置で、目的変数が指定された範囲の値をとる確率は以下のカラーコードで表示される"]
[]
[null,0,"0～0.1"]
[null,0.1,"0.1～0.2"]
[null,0.2,"0.2～0.3"]
[null,0.3,"0.3～0.4"]
[null,0.4,"0.4～0.5"]
[null,0.5,"0.5～0.6"]
[null,0.6,"0.6～0.7"]
[null,0.7,"0.7～0.8"]
[null,0.8,"0.8～0.9"]
[null,0.9,"0.9～1.0"]
[]
["７／９．データがない説明変数の矩形領域は赤で表示される。"]
[]
[null,-1]
[]
["８／９．ひとつの例として立川市に置ける降雨の有無が、年初からの日数とその日の主要j風向に依存する様子を可視化した例を「立川市の降雨確率」シートに示す。、"]
["　　主要風向は０～１５の値をとる16方位で測定され、風がない日は欠測となる。"]
[]
["９／９．このような図の作り方が「作図マニュアル」シートで説明されている。"]
[]
["以上"]

{"sheet":"立川市の降雨確率","index":1,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"360.5 ～ 56.5","56.5 ～ 160.5","160.5 ～ 224.5","224.5 ～ 272.5","272.5 ～ 360.5","360.5 ～ 56.5",null,"DAYoftheYEAR        "]
["0.0 ～ 3.5",9.4017094017094016E-2,0.29629629629629628,0.67123287671232879,0.54929577464788737,0.25280898876404495,9.4017094017094016E-2,null,null,0.23333333333333334]
["3.5 ～ 13.5",6.0240963855421686E-2,0.17073170731707318,0.21714285714285714,0.35106382978723405,9.4339622641509441E-2,6.0240963855421686E-2,null,"CONDITIONAL PROBABILITY MAP OF rain                ",0.66666666666666663]
["13.5 ～ 15.0",0.2,0.62857142857142856,0.625,0.62962962962962965,0.62121212121212122,0.2,null,null,0.1]
["MISSING of type  1",-1,-1,-1,-1,0,-1,null,null,0.1]
[]
["winddirection"]

{"sheet":"作図マニュアル","index":2,"n_rows":177,"n_cols":8,"rows_kept":177,"cut":false,"hidden":false,"merged":[]}
["作図マニュアル"]
[]
["実例で示す。"]
[]
["１／６．以下に CATDAP　の STDOUT 出力を示す。  このラインプリンターイメージの出力のままではこのファイルに組み込まれたマクロで可視化することができない。"]
[null,"x(1):rain                "]
[null,"x(2):winddirection       "]
[null,"x(3):DAYoftheYEAR        "]
[null," "]
[null," xx             response variable"]
[null," --             -----------------"]
[null," 23                 1    2"]
[null," --             -----------------"]
[null," 11               106   11  117"]
[null," 12                95   40  135"]
[null," 13                24   49   73"]
[null," 14                32   39   71"]
[null," 15               133   45  178"]
[null," 21                78    5   83"]
[null," 22               204   42  246"]
[null," 23               137   38  175"]
[null," 24                61   33   94"]
[null," 25                96   10  106"]
[null," 31                36    9   45"]
[null," 32                13   22   35"]
[null," 33                 3    5    8"]
[null," 34                10   17   27"]
[null," 35                25   41   66"]
[null," 41                 0    0    0"]
[null," 42                 0    0    0"]
[null," 43                 0    0    0"]
[null," 44                 0    0    0"]
[null," 45                 2    0    2"]
[null,"               -----------------"]
[null," total           1055  406 1461"]
[null,"               -----------------"]
[null," 35               37.9  62.1 100.0 (   66)"]
[null," 41                0.0   0.0   0.0 (    0)"]
[null," 42                0.0   0.0   0.0 (    0)"]
[null," 43                0.0   0.0   0.0 (    0)"]
[null," 44                0.0   0.0   0.0 (    0)"]
[null," 45              100.0   0.0 100.0 (    2)"]
[null,"               --------------------"]
[null," total            72.2  27.8 100.0"]
[null,"               --------------------"]
[null," "]
[]
[null," < note > "]
[null," x(1):rain                     1 :     0"]
[null,"                               2 :     1"]
[null," "]
[null," x(2):winddirection            1 :  0.00000D+00 -  0.35000D+01"]
[null,"                               2 :  0.35000D+01 -  0.13500D+02"]
[null,"                               3 :  0.13500D+02 -  0.15000D+02"]
[null,"                               4 :      MISSING of type  1"]
[null," "]
[null," x(3):DAYoftheYEAR             1 :  0.36050D+03 -  0.56500D+02"]
[null,"                               2 :  0.56500D+02 -  0.16050D+03"]
[null,"                               3 :  0.16050D+03 -  0.22450D+03"]
[null,"                               4 :  0.22450D+03 -  0.27250D+03"]
[null,"                               5 :  0.27250D+03 -  0.36050D+03"]
[" "]
["２／６．上の内容以下の形式でこのファイルの「CANONICALFORMAT」シートに書きこむ。　★以降は説明であり、あっても邪魔にはならないが無くてもいい。"]
[]
[" CONTINGENCY TABLE IN CANONICAL FORM"]
["HEADDER",2,2,null,null,"★説明変数の数　と　目的変数の値がとる値の数。このデータでは説明変数が winddirection と DAToftheYEAR の２つ。　目的変数は　2値変数。"]
[2,3,1,2,null,"★分割表の第１列にX(2)の値、第２列にX(3) の値が記され、第３列、第４列に目的変数が１番目の値、２番目の値、をとった回数が記される。"]
["TABLE",20,4,null,null,"★分割表は２０行４列。"]
[1,1,106,11]
[1,2,95,40]
[1,3,24,49]
[1,4,32,39]
[1,5,133,45]
[2,1,78,5]
[2,2,204,42]
[2,3,137,38]
[2,4,61,33]
[2,5,96,10]
[3,1,36,9]
[3,2,13,22]
[3,3,3,5]
[3,4,10,17]
[3,5,25,41]
[4,1,0,0]
[4,2,0,0]
[4,3,0,0]
[4,4,0,0]
[4,5,2,0]
[]
["OBSERVATION",1,"rain                ",null,null,"★X(1) の　名前は rain である。"]
["TYPE","INTEGER",null,null,null,"★X(1) は離散値変数である。"]
["RANGE",0,1,null,null,"★X(1) は最小値０、最大値１である。"]
["CATEGORY",2,null,null,null,"★X(1)は２値変数である。"]
[1,0,null,null,null,"★X(1)の１番目の値は０"]
[2,1,null,null,null,"★X(1)の２番目の値は１"]
[]
["OBSERVATION",2,"winddirection",null,null,"★X(2) の　名前は winddirection である。"]
["TYPE","CIRCULAR ",null,null,null,"★X(2) は循環連続値変数である。"]
["RANGE",0,15,null,null,"★X(2) は最小値０、最大値１5である。"]
["CATEGORY",4,null,null,null,"★X(2)の値は４つに区分されている。"]
[1,0,3.5,null,null,"★X(2)の１番目の区分は[0,3.5)"]
[2,3.5,13.5,null,null,"★X(2)の２番目の区分は[3.5,13.5)"]
[3,13.5,15,null,null,"★X(2)の3番目の区分は[13.5,15]"]
[4,"MISSING",1,null,null,"★X(2)の４番目の区分は「タイプ１の欠測」（もし必要なら無風による欠測をタイプ１、観測器の故障による欠測をタイプ２とするようなことも可能である。）"]
[]
["OBSERVATION",3,"DAYoftheYEAR        ",null,null,"★X(3) の　名前は DAYoftheYEAR である。"]
["TYPE","CIRCULAR ",null,null,null,"★X(３) は循環連続値変数である"]
["RANGE",1,366,null,null,"★X(3) は最小値1、最大値366である。"]
["CATEGORY",5,null,null,null,"★X(3)の値は５つに区分されている。"]
[1,360.5,56.5,null,null,"★X(3)の１番目の区分は[360.5,56.5)  循環連続値変数では最大値をまたぐ区分設定が可能。そのような区分は必ず１番目の区分としなくてはならない。"]
[2,56.5,160.5,null,null,"★X(3)の２番目の区分は[56.5,160.5)"]
[3,160.5,224.5,null,null,"★X(3)の3番目の区分は[160.5,224.5)"]
[4,224.5,272.5,null,null,"★X(3)の４番目の区分は[224.5,272.5)"]
[5,272.5,360.5,null,null,"★X(3)の５番目の区分は[272.5,360.55)"]
[]
["３／６．「1DIM」シートに移動し、「getDATA」ボタンをクリックすると以下の形の表が作られる。 "]
[]
[null,"choice",1,2,null,1,null,"★choice 行を編集することで、可視化に使う説明変数の選択、目的変数の値の選択ができる"]
[null,null,1,1,0.90598290598290598,9.4017094017094016E-2,117,"★choice 行のC列D列を「1，2」として作図する場合の縦軸を変数X(2),横軸をX(3)とすることを指定している。"]
[null,null,1,2,0.70370370370370372,0.29629629629629628,135,"★　    　　　　　C列D列を「2、1」とすれば縦軸を変数X(3),横軸をX(2)とする指定になる。"]
[null,null,1,3,0.32876712328767121,0.67123287671232879,73,"★choice 行E列F列の値を重みとするE列F列の確率値の加重平均がカラーコードで表示される。"]
[null,null,1,4,0.45070422535211269,0.54929577464788737,71,"★　上の説明は説明変数が２個、目的変数が２値の場合であることに注意されたい。"]
[null,null,1,5,0.7471910112359551,0.25280898876404495,178]
[null,null,2,1,0.93975903614457834,6.0240963855421686E-2,83]
[null,null,2,2,0.82926829268292679,0.17073170731707318,246]
[null,null,2,3,0.78285714285714281,0.21714285714285714,175]
[null,null,2,4,0.64893617021276595,0.35106382978723405,94]
[null,null,2,5,0.90566037735849059,9.4339622641509441E-2,106]
[null,null,3,1,0.8,0.2,45]
[null,null,3,2,0.37142857142857144,0.62857142857142856,35]
[null,null,3,3,0.375,0.625,8]
[null,null,3,4,0.37037037037037035,0.62962962962962965,27]
[null,null,3,5,0.37878787878787878,0.62121212121212122,66]
[null,null,4,1,null,null,0]
[null,null,4,2,null,null,0]
[null,null,4,3,null,null,0]
[null,null,4,4,null,null,0]
[null,null,4,5,1,0,2]
[null,null,null,null,0.30758293838862555,1,1461]
["OBSERVATION",1,2,3]
["NAME","rain                ","winddirection","DAYoftheYEAR        "]
["TYPE","INTEGER","CIRCULAR ","CIRCULAR "]
["MIN",0,0,1]
["MAX",1,15,366]
["CATEGORY",2,4,5]
["BIN",0,0,360.5]
[null,null,3.5,56.5]
[null,1,3.5,56.5]
[null,null,13.5,160.5]
[null,null,13.5,160.5]
[null,null,15,224.5]
[null,null,"MISSING",224.5]
[null,null,1,272.5]
[null,null,null,272.5]
[null,null,null,360.5]
[]
["４／６．「1DIM」シート１行目の編集"]
[null,"choice",1,2,null,1,null,"★この行を編集することで、可視化に使う説明変数の選択、目的変数の値の選択ができる"]
["を"]
[null,"choice",2,1,null,1,null,"★この行を編集することで、可視化に使う説明変数の選択、目的変数の値の選択ができる"]
["とすると出来上がる図の縦横が入れ替わる"]
[null,"choice",1,2,1,null,null,"★この行を編集することで、可視化に使う説明変数の選択、目的変数の値の選択ができる"]
["とすると、目的変数が１番目の値をとる確率が可視化される"]
[null,"choice",1,2,null,null,null,"★この行を編集することで、可視化に使う説明変数の選択、目的変数の値の選択ができる"]
["のように目的変数を指定しないと、目的変数が G.MEDIAN 以上の値をとる確率が可視化される。"]
[]
["５／６．「makeFIGURE」ボタンをクリックすると「2DIM」シートに可視化の結果が得られる。 "]
[]
["６／６．分割表の CANONICAL FORM"]
[]
["いかなる観測であってもデータがとる値は「連続値」、「離散値」、「欠測」、「循環値」のいずれかである。"]
["連続値を適切にカテゴライズすることによって、いかなるデータも分割表の形に集約することができる。"]
["各変数が「連続値」、「離散値」、「循環値」のいずれであるか、最小値、最大値、連続値をカテゴライズする区分が明示された分割表を"]
[" CONTINGENCY TABLE IN CANONICAL　FORM　と呼ぶことにする。"]
[" CONTINGENCY TABLE IN CANONICAL　FORM　を構成する記法が唯一でないことは当然だが、このマニュアルで採用した記法は CONTINGENCY TABLE IN CANONICAL　FORM　である。　"]
[]
["CATDAP　プログラムはCONTINGENCY TABLE IN CANONICAL　FORM の形で分析結果を出力する。"]

{"sheet":"1DIM","index":3,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,"choice",1,2,null,1]
[null,null,1,1,0.90598290598290598,9.4017094017094016E-2,117]
[null,null,1,2,0.70370370370370372,0.29629629629629628,135]
[null,null,1,3,0.32876712328767121,0.67123287671232879,73]
[null,null,1,4,0.45070422535211269,0.54929577464788737,71]
[null,null,1,5,0.7471910112359551,0.25280898876404495,178]
[null,null,2,1,0.93975903614457834,6.0240963855421686E-2,83]
[null,null,2,2,0.82926829268292679,0.17073170731707318,246]
[null,null,2,3,0.78285714285714281,0.21714285714285714,175]
[null,null,2,4,0.64893617021276595,0.35106382978723405,94]
[null,null,2,5,0.90566037735849059,9.4339622641509441E-2,106]
[null,null,3,1,0.8,0.2,45]
[null,null,3,2,0.37142857142857144,0.62857142857142856,35]
[null,null,3,3,0.375,0.625,8]
[null,null,3,4,0.37037037037037035,0.62962962962962965,27]
[null,null,3,5,0.37878787878787878,0.62121212121212122,66]
[null,null,4,1,null,null,0]
[null,null,4,2,null,null,0]
[null,null,4,3,null,null,0]
[null,null,4,4,null,null,0]
[null,null,4,5,1,0,2]
[null,null,null,null,0.30758293838862555,1,1461]
["OBSERVATION",1,2,3]
["NAME","rain                ","winddirection","DAYoftheYEAR        "]
["TYPE","INTEGER","CIRCULAR ","CIRCULAR "]
["MIN",0,0,1]
["MAX",1,15,366]
["CATEGORY",2,4,5]
["BIN",0,0,360.5]
[null,null,3.5,56.5]
[null,1,3.5,56.5]
[null,null,13.5,160.5]
[null,null,13.5,160.5]
[null,null,15,224.5]
[null,null,"MISSING",224.5]
[null,null,1,272.5]
[null,null,null,272.5]
[null,null,null,360.5]

{"sheet":"2DIM","index":4,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"360.5 ～ 56.5","56.5 ～ 160.5","160.5 ～ 224.5","224.5 ～ 272.5","272.5 ～ 360.5","360.5 ～ 56.5",null,"DAYoftheYEAR        "]
["0.0 ～ 3.5",9.4017094017094016E-2,0.29629629629629628,0.67123287671232879,0.54929577464788737,0.25280898876404495,9.4017094017094016E-2,null,null,0.23333333333333334]
["3.5 ～ 13.5",6.0240963855421686E-2,0.17073170731707318,0.21714285714285714,0.35106382978723405,9.4339622641509441E-2,6.0240963855421686E-2,null,"CONDITIONAL PROBABILITY MAP OF rain                ",0.66666666666666663]
["13.5 ～ 15.0",0.2,0.62857142857142856,0.625,0.62962962962962965,0.62121212121212122,0.2,null,null,0.1]
["MISSING of type  1",-1,-1,-1,-1,0,-1,null,null,0.1]
[]
["winddirection"]

{"sheet":"CANONICALFORM","index":5,"n_rows":50,"n_cols":4,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[" CONTINGENCY TABLE IN CANONICAL FORM"]
["HEADDER",2,2]
[2,3,1,2]
["TABLE",20,4]
[1,1,106,11]
[1,2,95,40]
[1,3,24,49]
[1,4,32,39]
[1,5,133,45]
[2,1,78,5]
[2,2,204,42]
[2,3,137,38]
[2,4,61,33]
[2,5,96,10]
[3,1,36,9]
[3,2,13,22]
[3,3,3,5]
[3,4,10,17]
[3,5,25,41]
[4,1,0,0]
[4,2,0,0]
[4,3,0,0]
[4,4,0,0]
[4,5,2,0]
[]
["OBSERVATION",1,"rain                "]
["TYPE","INTEGER"]
["RANGE",0,1]
["CATEGORY",2]
[1,0]
[2,1]
[]
["OBSERVATION",2,"winddirection"]
["TYPE","CIRCULAR "]
["RANGE",0,15]
["CATEGORY",4]
[1,0,3.5]
[2,3.5,13.5]
[3,13.5,15]
[4,"MISSING",1]
[]
["OBSERVATION",3,"DAYoftheYEAR        "]
["TYPE","CIRCULAR "]
["RANGE",1,366]
["CATEGORY",5]
[1,360.5,56.5]
[2,56.5,160.5]
[3,160.5,224.5]
[4,224.5,272.5]
[5,272.5,360.5]