{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["使い方","格差の縮小","格差の縮小 (SMR用)"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"使い方","index":0,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["このエクセルファイルは、マクロを使っています。\nセキュリティの警告でマクロが無効にされた場合は、コンテンツの有効化を行って下さい。"]
["平成30年度厚生労働科学研究費補助金「健康寿命及び地域格差の要因分析と健康増進対策の効果検証に関する研究」（研究代表者：辻一郎）　「健康寿命の地域格差の算定・評価に関する研究」（研究分担者：横山徹爾）"]
["健康指標の地域格差見える化ツールVer.1.1"]
["健康日本２１（第二次）中間評価で健康寿命の都道府県格差の評価のために用いられたのと同様の図を、自治体で作成できるようにしたツールです。"]
["図の作り方"]
["（１）「格差の縮小」シートの６～１５行目の途中に、必要なだけ行を追加（又は削除）する。\n　※最初の行と最後の行は削除しないように、７～１４行目の範囲で追加削除するとよい。\n　※No.の列や右側の計算領域（M列目から右）に空白セルが生じるが、計算時に自動的に埋められるのでそのままでよい。\n　※標準化死亡比(SMR)等の比を指標とする（信頼区間の上側と下側の幅が異なる）場合には「格差の縮小 (SMR用)」を使用する。"]
["（２）水色のセルに必要な情報を入力する。\n　※水色のセルの内容が図表に自動的に反映されるので全て入力する。\n　※95%信頼区間も入力することが望ましいが、不明の場合にはブランクにし「格差の縮小」シートを使用する。その場合、左側の図は推定値で描かれる。\n　※２時点だけで作成する場合は、中間年をブランクにしておき、最後に図の中間年の部分を削除する。"]
["（３）「計算開始」ボタンをクリックする。"]
["（４）図が自動的に作成される。\n　※グラフのＸ軸、Ｙ軸のスケール等は見やすいように変えてください。"]
["詳細は、分担研究報告書「健康寿命の地域格差の算定・評価に関する研究」（研究分担者：横山徹爾）をご覧下さい。"]
["更新履歴"]
["2019/9/5　ver.1.0公開"]
["2021/12/21 ver.1.1公開"]
["・ver.1.0で推定値の推移の図（右側の図）が正しくプロットされない不具合を修正。"]
["・正規スコア（Ｘ軸）の計算方法を微修正（健康日本２１（第２次）最終評価（案）資料と同じ計算方法に変更）"]

{"sheet":"格差の縮小","index":1,"n_rows":23,"n_cols":42,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,40,3,42],[18,0,18,5],[19,0,19,5],[18,6,18,10],[3,0,4,0],[3,1,4,1],[3,2,3,4],[3,5,3,7],[3,8,3,10],[4,16,4,17],[4,22,4,23],[4,28,4,29],[4,3,4,4],[4,6,4,7],[4,9,4,10],[3,27,3,29],[3,21,3,23],[3,15,3,17],[3,34,3,36],[3,37,3,39]]}
["XX県","女性","６５歳健康寿命（年）",null,null,"図の軸範囲",18,21,null,null,null,null,"データの行数"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROWS(M6:M15)","v":10}]
[{"$f":"A1&\"・\"&C1&\"【\"&B1&\"】\"","v":"XX県・６５歳健康寿命（年）【女性】"}]
["No.","市町村","2000年",null,null,"2013年",null,null,"2016年",null,null,null,null,null,null,{"$f":"C4","v":"2000年"},null,null,null,null,null,{"$f":"F4","v":"2013年"},null,null,null,null,null,{"$f":"I4","v":"2016年"},null,null,null,null,null,null,{"$f":"C4","v":"2000年"},null,null,{"$f":"F4","v":"2013年"},null,null,{"$f":"I4","v":"2016年"}]
[null,null,"推定値","95％信頼区間",null,"推定値","95％信頼区間",null,"推定値","95％信頼区間",null,null,"順位","prob.","Z値","推定値","95％信頼区間",null,"標準誤差","標準誤差2","補正値","推定値","95％信頼区間",null,"標準誤差","標準誤差2","補正値","推定値","95％信頼区間",null,"標準誤差","標準誤差2","補正値",null,"推定値","SE",null,"推定値","SE",null,"推定値","SE"]
[1,"A市",19.239586302571329,19.037002024570334,19.442170580572324,19.23569153099756,18.886889459508268,19.584493602486852,19.726217428778568,19.479688102576596,19.972746754980541,null,1,{"$f":"(M6-0.375)/(COUNT(M$6:M$15)+0.25)","v":6.097560975609756E-2},{"$f":"_xlfn.NORM.INV(N6,0,1)","v":-1.54663527139923},19.239586302571329,19.037002024570334,19.442170580572324,{"$f":"(R6-Q6)/1.96/2","v":0.1033593255107115},{"$f":"S6^2","v":1.0683150170029217E-2},{"$f":"(P6-P$16)*(P$21/P$18)+P$16","v":19.301604010588164},19.23569153099756,18.886889459508268,19.584493602486852,{"$f":"(H6-G6)/1.96/2","v":0.17796024055576115},{"$f":"Y6^2","v":3.1669847218664379E-2},{"$f":"(V6-V$16)*(V$21/V$18)+V$16","v":19.403679521544564},19.726217428778568,19.479688102576596,19.972746754980541,{"$f":"(K6-J6)/1.96/2","v":0.12578026847039428},{"$f":"AE6^2","v":1.5820675936484462E-2},{"$f":"(AB6-AB$16)*(AB$21/AB$18)+AB$16","v":19.84547728975658},null,{"$f":"C6","v":19.239586302571329},{"$f":"(E6-D6)/2/1.96","v":0.1033593255107115},null,{"$f":"F6","v":19.23569153099756},{"$f":"(H6-G6)/2/1.96","v":0.17796024055576115},null,{"$f":"I6","v":19.726217428778568},{"$f":"(K6-J6)/2/1.96","v":0.12578026847039428}]
[2,"B市",19.659088453504804,19.421242708636289,19.896934198373319,19.885129670222508,19.547024076928182,20.223235263516834,20.246073594407733,19.914760339238086,20.57738684957738,null,2,{"$f":"(M7-0.375)/(COUNT(M$6:M$15)+0.25)","v":0.15853658536585366},{"$f":"_xlfn.NORM.INV(N7,0,1)","v":-1.0004905456193149},19.481361467264271,19.112662997708874,19.850059936819669,0.18811146405887624,3.5385922910373888E-2,19.506837557842342,19.645372750005766,19.399806861578032,19.8909386384335,0.17250285372159502,2.9757234542094009E-2,19.674881674108914,20.045077276260628,19.677294731794955,20.4128598207263,0.16903737508655456,2.8573634176152538E-2,20.08766884346625,null,{"$f":"C7","v":19.659088453504804},{"$f":"(E7-D7)/2/1.96","v":0.1213498698308752},null,{"$f":"F7","v":19.885129670222508},{"$f":"(H7-G7)/2/1.96","v":0.17250285372159502},null,{"$f":"I7","v":20.246073594407733},{"$f":"(K7-J7)/2/1.96","v":0.16903737508655456}]
[3,"C市",19.481361467264271,19.112662997708874,19.850059936819669,19.664849978393885,19.351844183896269,19.977855772891502,20.169731282779001,19.79256578986319,20.546896775694812,null,3,0.25609756097560976,-0.65542350523442661,19.484655858180087,19.204785855381481,19.764525860978694,0.14279081775439109,2.0389217634967729E-2,19.509634038343361,19.657932556538277,19.456661530534252,19.859203582542303,0.1596968339273554,2.5503078766421331E-2,19.683196057120309,20.051431874304161,19.771129984867603,20.331733763740719,0.19243137393663828,3.7029833675142315E-2,20.092495509430989,null,19.481361467264271,0.18811146405887624,null,19.664849978393885,0.1596968339273554,null,20.169731282779001,0.19243137393663828]
[4,"D市",19.680111260292836,19.388030871011384,19.972191649574288,19.77202553719647,19.451141011220187,20.092910063172752,20.248288075473873,19.950787705364498,20.545788445583248,null,4,0.35365853658536583,-0.37546177023551847,19.510598553881373,19.314114237327566,19.70708287043518,0.10024710028255462,1.0049481115060564E-2,19.531655785162862,19.664849978393885,19.351844183896269,19.977855772891502,0.16371659488585841,2.6803123441020281E-2,19.687775275328011,20.169731282779001,19.79256578986319,20.546896775694812,0.1517859031170283,2.3038960385051901E-2,20.182350402631577,null,19.680111260292836,0.14902060677625095,null,19.77202553719647,0.16371659488585841,null,20.248288075473873,0.1517859031170283]
[5,"E市",19.484655858180087,19.204785855381481,19.764525860978694,19.645372750005766,19.399806861578032,19.8909386384335,20.051431874304161,19.771129984867603,20.331733763740719,null,5,0.45121951219512196,-0.12258084388880242,19.53282132906687,19.329373217525475,19.736269440608265,0.10380005690887482,1.0774451814285652E-2,19.550519835930622,19.692672507524051,19.337895004740183,20.047450010307919,0.12528871858557861,1.569726300481631E-2,19.706193326827059,20.246073594407733,19.914760339238086,20.57738684957738,0.14301116807987646,2.0452194195570674E-2,20.240336578103832,null,19.484655858180087,0.14279081775439109,null,19.645372750005766,0.12528871858557861,null,20.051431874304161,0.14301116807987646]
[6,"F市",19.510598553881373,19.314114237327566,19.70708287043518,19.692672507524051,19.337895004740183,20.047450010307919,20.300489900526067,19.94770091890129,20.653278882150843,null,6,0.54878048780487809,0.12258084388880255,19.659088453504804,19.421242708636289,19.896934198373319,0.1213498698308752,1.4725790907970356E-2,19.657703093908726,19.77202553719647,19.451141011220187,20.092910063172752,0.18100892999176951,3.276423273676532E-2,19.75872371255419,20.248288075473873,19.950787705364498,20.545788445583248,0.179994378379988,3.239797624839829E-2,20.242018598007888,null,19.510598553881373,0.10024710028255462,null,19.692672507524051,0.18100892999176951,null,20.300489900526067,0.179994378379988]
[7,"G市",19.931816827315057,19.600279348825612,20.263354305804501,20.031070722006735,19.652185366455843,20.409956077557627,20.599259388713492,20.352785197369869,20.845733580057114,null,7,0.64634146341463417,0.37546177023551847,19.680111260292836,19.388030871011384,19.972191649574288,0.14902060677625095,2.220714124396201E-2,19.675548538108202,19.846608039861863,19.477231729246146,20.21598435047758,0.1933088548729042,3.7368313372273539E-2,19.808096088753075,20.300489900526067,19.94770091890129,20.653278882150843,0.12575213844062388,1.5813600322389834E-2,20.281668749056092,null,19.931816827315057,0.16915177473951248,null,20.031070722006735,0.1933088548729042,null,20.599259388713492,0.12575213844062388]
[8,"H市",19.991507663930747,19.791231984233374,20.191783343628121,19.846608039861863,19.477231729246146,20.21598435047758,20.390443806586596,20.180523604197965,20.600364008975227,null,8,0.74390243902439024,0.65542350523442661,19.931816827315057,19.600279348825612,20.263354305804501,0.16915177473951248,2.8612322897526774E-2,19.889211618223158,19.885129670222508,19.547024076928182,20.223235263516834,0.18845730133454952,3.5516154426301204E-2,19.83359676730355,20.390443806586596,20.180523604197965,20.600364008975227,0.10710214407583195,1.1470869265640265E-2,20.349993677525738,null,19.991507663930747,0.10218146923335382,null,19.846608039861863,0.18845730133454952,null,20.390443806586596,0.10710214407583195]
[9,"I市",19.53282132906687,19.329373217525475,19.736269440608265,19.657932556538277,19.456661530534252,19.859203582542303,20.045077276260628,19.677294731794955,20.4128598207263,null,9,0.84146341463414631,1.0004905456193149,19.987675429102939,19.762289870776009,20.21306098742987,0.1149926317994544,1.3223305368164892E-2,19.936627815846869,19.895376337426686,19.644819720922563,20.14593295393081,0.10268929898164582,1.0545092125341845E-2,19.840379890555116,20.445123491775448,20.091494381044949,20.798752602505946,0.18764415533962889,3.5210329033122774E-2,20.391525899336727,null,19.53282132906687,0.10380005690887482,null,19.657932556538277,0.10268929898164582,null,20.045077276260628,0.18764415533962889]
[10,"J市",19.987675429102939,19.762289870776009,20.21306098742987,19.895376337426686,19.644819720922563,20.14593295393081,20.445123491775448,20.091494381044949,20.798752602505946,null,10,0.93902439024390238,1.5466352713992295,19.991507663930747,19.791231984233374,20.191783343628121,0.10218146923335382,1.0441052654686834E-2,19.939880851156019,20.031070722006735,19.652185366455843,20.409956077557627,0.1278350084204713,1.6341789377861966E-2,19.930207316079024,20.599259388713492,20.352785197369869,20.845733580057114,0.18042301567882565,3.2552464586641766E-2,20.508600572289893,null,19.987675429102939,0.1149926317994544,null,19.895376337426686,0.1278350084204713,null,20.445123491775448,0.18042301567882565]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"推定値の平均",{"$f":"AVERAGE(P6:P15)","v":19.649922314511038},null,null,null,null,null,{"$f":"AVERAGE(V6:V15)","v":19.732672963017382},null,null,null,null,null,{"$f":"AVERAGE(AB6:AB15)","v":20.222213611960559}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"〃分散",{"$f":"VAR(P6:P15)","v":6.3160308758945544E-2},null,null,null,null,null,{"$f":"VAR(V6:V15)","v":4.6631608669319063E-2},null,null,null,null,null,{"$f":"VAR(AB6:AB15)","v":5.964893070902931E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"〃標準偏差",{"$f":"SQRT(P17)","v":0.25131714776144015},null,null,null,null,null,{"$f":"SQRT(V17)","v":0.21594353120507931},null,null,null,null,null,{"$f":"SQRT(AB17)","v":0.24423130575139074}]
[{"$f":"A3&\"の分布の推移\"","v":"XX県・６５歳健康寿命（年）【女性】の分布の推移"},null,null,null,null,null,{"$f":"A3&\"の推定値の推移\"","v":"XX県・６５歳健康寿命（年）【女性】の推定値の推移"},null,null,null,null,null,null,null,"誤差分散",{"$f":"AVERAGE(T6:T15)","v":1.7649183671702793E-2},null,null,null,null,null,{"$f":"AVERAGE(Z6:Z15)","v":2.6196612901156019E-2},null,null,null,null,null,{"$f":"AVERAGE(AF6:AF15)","v":2.5236053782459484E-2}]
["誤差分散を補正した値であり推定値とは異なる",null,null,null,null,null,null,null,null,null,null,null,null,null,"真値の分布の分散",{"$f":"+P17-P19","v":4.5511125087242754E-2},null,null,null,null,null,{"$f":"+V17-V19","v":2.0434995768163045E-2},null,null,null,null,null,{"$f":"+AB17-AB19","v":3.441287692656983E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"〃標準偏差",{"$f":"SQRT(P20)","v":0.21333336608988937},null,null,null,null,null,{"$f":"SQRT(V20)","v":0.14295102576813867},null,null,null,null,null,{"$f":"SQRT(AB20)","v":0.1855070805294769}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"凡例1",{"$f":"C4&\"(SD=\"&FIXED(P21,2)&\")\"","v":"2000年(SD=0.21)"},null,null,null,null,null,{"$f":"F4&\"(SD=\"&FIXED(V21,2)&\")\"","v":"2013年(SD=0.14)"},null,null,null,null,null,{"$f":"I4&\"(SD=\"&FIXED(AB21,2)&\")\"","v":"2016年(SD=0.19)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"凡例2",{"$f":"C4","v":"2000年"},null,null,null,null,null,{"$f":"\"○\"&F4","v":"○2013年"},null,null,null,null,null,{"$f":"\"●\"&I4","v":"●2016年"}]

{"sheet":"格差の縮小 (SMR用)","index":2,"n_rows":23,"n_cols":61,"rows_kept":23,"cut":false,"hidden":false,"merged":[[4,28,4,29],[4,40,4,41],[18,0,18,5],[18,6,18,10],[3,52,3,54],[3,55,3,57],[3,58,3,60],[19,0,19,5],[4,21,4,22],[4,33,4,34],[3,0,4,0],[3,1,4,1],[3,2,3,4],[3,5,3,7],[3,8,3,10],[4,3,4,4],[4,6,4,7],[4,9,4,10],[4,45,4,46],[4,16,4,17]]}
["XX県","女性","標準化死亡比",null,null,"図の軸範囲",70,120,null,null,null,null,"データの行数"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROWS(M6:M15)","v":10}]
[{"$f":"A1&\"・\"&C1&\"【\"&B1&\"】\"","v":"XX県・標準化死亡比【女性】"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C4","v":"2000年"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"F4","v":"2013年"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"I4","v":"2016年"}]
["No.","市町村","2000年",null,null,"2013年",null,null,"2016年",null,null,null,null,null,null,"元のスケール",null,null,null,null,"logスケール",null,null,null,null,null,"元のスケール","元のスケール",null,null,null,null,"logスケール",null,null,null,null,null,"元のスケール","元のスケール",null,null,null,null,"logスケール",null,null,null,null,null,"元のスケール",null,{"$f":"C4","v":"2000年"},null,null,{"$f":"F4","v":"2013年"},null,null,{"$f":"I4","v":"2016年"}]
[null,null,"推定値","95％信頼区間",null,"推定値","95％信頼区間",null,"推定値","95％信頼区間",null,null,"順位","prob.","Z値","推定値","95％信頼区間",null,"Δ下側","Δ上側","推定値","95％信頼区間",null,"標準誤差","標準誤差2","補正値","補正値","推定値","95％信頼区間",null,"Δ下側","Δ上側","推定値","95％信頼区間",null,"標準誤差","標準誤差2","補正値","補正値","推定値","95％信頼区間",null,"Δ下側","Δ上側","推定値","95％信頼区間",null,"標準誤差","標準誤差2","補正値","補正値",null,"推定値","Δ下側","Δ上側","推定値","Δ下側","Δ上側","推定値","Δ下側","Δ上側"]
[1,"A市",96.6,93.734976949938741,99.530335025023533,90.7,78.622020158645938,104.108061680297,89.3,86.569970225225802,92.094219673203682,null,1,{"$f":"(M6-0.375)/(COUNT(M$6:M$15)+0.25)","v":6.097560975609756E-2},{"$f":"_xlfn.NORM.INV(N6,0,1)","v":-1.54663527139923},88,84.391439897775413,91.723181082238597,{"$f":"P6-Q6","v":3.6085601022245868},{"$f":"R6-P6","v":3.7231810822385967},{"$f":"LN(P6)","v":4.4773368144782069},{"$f":"LN(Q6)","v":4.4354659734461102},{"$f":"LN(R6)","v":4.5187751399246787},{"$f":"(W6-V6)/1.96/2","v":2.1252338387389939E-2},{"$f":"X6^2","v":4.5166188693212796E-4},{"$f":"(U6-U$16)*(U$21/U$18)+U$16","v":4.4803980672678536},{"$f":"EXP(Z6)","v":88.269803002386141},76,64.679163643871121,88.731815289292726,{"$f":"AB6-AC6","v":11.320836356128879},{"$f":"AD6-AB6","v":12.731815289292726},{"$f":"LN(AB6)","v":4.3307333402863311},{"$f":"LN(AC6)","v":4.169439103949224},{"$f":"LN(AD6)","v":4.4856185092122169},{"$f":"(AI6-AH6)/1.96/2","v":8.0658011546681868E-2},{"$f":"AJ6^2","v":6.5057148266646657E-3},{"$f":"(AG6-AG$16)*(AG$21/AG$18)+AG$16","v":4.3897542617797702},{"$f":"EXP(AL6)","v":80.620604982066226},85.8,82.569410056502221,89.124596431020933,{"$f":"AN6-AO6","v":3.2305899434977761},{"$f":"AP6-AN6","v":3.3245964310209359},{"$f":"LN(AN6)","v":4.4520190064939165},{"$f":"LN(AO6)","v":4.4136392736357646},{"$f":"LN(AP6)","v":4.4900353506010209},{"$f":"(AU6-AT6)/1.96/2","v":1.9488795144198035E-2},{"$f":"AV6^2","v":3.798131361725169E-4},{"$f":"(AS6-AS$16)*(AS$21/AS$18)+AS$16","v":4.4578345334114875},{"$f":"EXP(AX6)","v":86.300425919348712},null,{"$f":"C6","v":96.6},{"$f":"C6-D6","v":2.8650230500612537},{"$f":"E6-C6","v":2.9303350250235383},{"$f":"F6","v":90.7},{"$f":"F6-G6","v":12.077979841354065},{"$f":"H6-F6","v":13.408061680296996},{"$f":"I6","v":89.3},{"$f":"I6-J6","v":2.7300297747741951},{"$f":"K6-I6","v":2.7942196732036848}]
[2,"B市",99.7,97.191768033124035,102.25658534584731,98.9,88.17850786395573,110.56550366625264,94.1,91.486872581069136,96.768831595444041,null,2,{"$f":"(M7-0.375)/(COUNT(M$6:M$15)+0.25)","v":0.15853658536585366},-1.0004905456193149,91.7,88.260685531078337,95.238995469750776,3.4393144689216655,3.5389954697507733,4.5185223792624196,4.4802947709886487,4.5563894742063686,1.9411914086153045E-2,3.7682240848818703E-4,4.5202206625254835,91.855864889127574,83.2,71.930863462595937,95.733538183457981,11.269136537404066,12.533538183457978,4.4212473478271628,4.2757054280140263,4.561568688303022,7.2924301094131547E-2,5.3179536900675554E-3,4.4503391234397673,85.655987030294824,89.3,86.569970225225802,92.094219673203682,2.7300297747741951,2.7942196732036848,4.4920014878824537,4.4609529912889121,4.5228121798715257,1.5780405250666745E-2,2.490211898752706E-4,4.4952796910020449,89.593223899733957,null,{"$f":"C7","v":99.7},{"$f":"C7-D7","v":2.5082319668759681},{"$f":"E7-C7","v":2.55658534584731},{"$f":"F7","v":98.9},{"$f":"F7-G7","v":10.721492136044276},{"$f":"H7-F7","v":11.665503666252633},{"$f":"I7","v":94.1},{"$f":"I7-J7","v":2.6131274189308584},{"$f":"K7-I7","v":2.6688315954440469}]
[3,"C市",102,99.315330065575068,104.73885886489748,97.1,85.861665357810523,109.40040191675295,99.3,96.436925888811302,102.22648819782938,null,3,0.25609756097560976,-0.65542350523442661,92.9,89.967127541760092,95.904133028611781,2.9328724582399133,3.0041330286117756,4.5315236458197932,4.4994443540744076,4.5633490782350989,1.6302225551196779E-2,2.6576255792209314E-4,4.5327916732342963,93.01787446503981,83.4,69.628553718299045,99.097368864788066,13.77144628170096,15.697368864788061,4.423648309364701,4.2431747377822377,4.5961028906786137,9.0032692065402015E-2,8.1058856405435021E-3,4.4519461887609779,85.793752465982251,91.5,87.836731109501059,95.27679780203448,3.6632688904989408,3.7767978020344799,4.516338972281476,4.4754797629237331,4.5567863161912836,2.0741467670293504E-2,4.3020848111783065E-4,4.5180726970144329,91.658773407987667,null,102,2.6846699344249316,2.7388588648974803,97.1,11.238334642189471,12.300401916752961,99.3,2.8630741111886948,2.9264881978293857]
[4,"D市",110.7,107.52033890803258,113.94981495362127,109,95.507532539800025,123.86419214061195,101.9,98.62021449964034,105.2610643602677,null,4,0.35365853658536583,-0.37546177023551847,94,91.294745478208256,96.765060210807007,2.7052545217917441,2.7650602108070075,4.5432947822700038,4.5140932336797581,4.5722859808895731,1.484508857393238E-2,2.2037665476789772E-4,4.5441732629984548,94.082613470332248,90.7,78.622020158645938,104.108061680297,12.077979841354065,13.408061680296996,4.5075573571210912,4.3646518148893154,4.6454294143160055,7.1626938629257689E-2,5.1304183373994472E-3,4.5081100708877271,90.750144995271924,93.1,89.09747077279691,97.236001134381169,4.0025292272030839,4.1360011343811749,4.5336741842830213,4.4897309476855005,4.5771410249328559,2.2298489093713111E-2,4.972226158624426E-4,4.5343078010580173,93.159008414138484,null,110.7,3.179661091967418,3.2498149536212679,109,13.492467460199975,14.864192140611948,101.9,3.2797855003596652,3.3610643602676902]
[5,"E市",97.4,94.556154757237252,100.30764668936382,83.2,71.930863462595937,95.733538183457981,97.3,94.255558845199303,100.41774012769004,null,5,0.45121951219512196,-0.12258084388880242,94.1,90.820459836697637,97.46770320343883,3.2795401633023573,3.3677032034388361,4.5443580465913342,4.5088845888225633,4.5795210739331687,1.8019511507807496E-2,3.247027949800068E-4,4.545201340310058,94.179387407678391,91.1,77.364143748583487,106.57109649439488,13.735856251416507,15.471096494394885,4.5119578042659123,4.3485234141958218,4.668812335139255,8.1706357383528883E-2,6.6759288368849444E-3,4.511055476673576,91.017835031771966,94.1,91.486872581069136,96.768831595444041,2.6131274189308584,2.6688315954440469,4.5443580465913342,4.5161954929294517,4.5723249547830065,1.4318740268763987E-2,2.0502632288432336E-4,4.544313655970396,94.095822935281674,null,97.4,2.8438452427627539,2.9076466893638155,83.2,11.269136537404066,12.533538183457978,97.3,3.044441154800694,3.1177401276900412]
[6,"F市",92.9,89.967127541760092,95.904133028611781,76,64.679163643871121,88.731815289292726,94.6,91.40721683519854,97.875839284941847,null,6,0.54878048780487809,0.12258084388880255,96.6,93.734976949938741,99.530335025023533,2.8650230500612537,2.9303350250235383,4.5705787412184726,4.5404714061424594,4.6004624723230751,1.5303843413422393E-2,2.3420762322255196E-4,4.5705543035383469,96.597639348944426,91.4,79.967924503049673,104.00758214397287,11.432075496950333,12.607582143972863,4.5152454784601046,4.3816256105625815,4.6444638017144237,6.7050558967306703E-2,4.495777457828273E-3,4.5132560563589736,91.218347571546602,94.5,91.567913712878152,97.502076905062793,2.932086287121848,3.0020769050627933,4.5485998344996972,4.5170809233379581,4.5798736793673136,1.6018560211570287E-2,2.565942712517027E-4,4.5482862562487751,94.470371500957114,null,92.9,2.9328724582399133,3.0041330286117756,76,11.320836356128879,12.731815289292726,94.6,3.1927831648014546,3.2758392849418527]
[7,"G市",94,91.294745478208256,96.765060210807007,91.4,79.967924503049673,104.00758214397287,94.5,91.567913712878152,97.502076905062793,null,7,0.64634146341463417,0.37546177023551847,97.4,94.556154757237252,100.30764668936382,2.8438452427627539,2.9076466893638155,4.5788262106484892,4.5491938882501373,4.6082419302410083,1.5063276018079335E-2,2.2690228439684404E-4,4.5785288363323495,97.371040047794381,91.9,76.315867061575403,109.72986991277841,15.584132938424602,17.829869912778406,4.5207010293616419,4.3348808729165818,4.6980216174809843,9.2637945041939437E-2,8.581788861593392E-3,4.5169076878094936,91.552052270878036,94.6,91.40721683519854,97.875839284941847,3.1927831648014546,3.2758392849418527,4.5496574760578321,4.5153244341526335,4.5836997293438504,1.7442677344698183E-2,3.0424699295124725E-4,4.5492767789337938,94.563992906399292,null,94,2.7052545217917441,2.7650602108070075,91.4,11.432075496950333,12.607582143972863,94.5,2.932086287121848,3.0020769050627933]
[8,"H市",91.7,88.260685531078337,95.238995469750776,83.4,69.628553718299045,99.097368864788066,91.5,87.836731109501059,95.27679780203448,null,8,0.74390243902439024,0.65542350523442661,99.7,97.191768033124035,102.25658534584731,2.5082319668759681,2.55658534584731,4.6021656769677923,4.5766860168626646,4.6274851972094044,1.2958974578249949E-2,1.6793502211972846E-4,4.601095920834708,99.59340234044717,97.1,85.861665357810523,109.40040191675295,11.238334642189471,12.300401916752961,4.5757413752972793,4.4527374588092252,4.6950145638088561,6.1805383928477259E-2,3.8199054825464752E-3,4.5537485242151146,94.98780588106483,97.3,94.255558845199303,100.41774012769004,3.044441154800694,3.1177401276900412,4.577798989191959,4.5460098043787935,4.6093388861478992,1.6155378002322876E-2,2.6099623839793789E-4,4.5756324066374372,97.089419719599292,null,91.7,3.4393144689216655,3.5389954697507733,83.4,13.77144628170096,15.697368864788061,91.5,3.6632688904989408,3.7767978020344799]
[9,"I市",94.1,90.820459836697637,97.46770320343883,91.1,77.364143748583487,106.57109649439488,85.8,82.569410056502221,89.124596431020933,null,9,0.84146341463414631,1.0004905456193149,102,99.315330065575068,104.73885886489748,2.6846699344249316,2.7388588648974803,4.6249728132842707,4.5982999404605822,4.6514701938607086,1.3563840153093464E-2,1.8397775969867053E-4,4.6231482919330613,101.81406849175853,98.9,88.17850786395573,110.56550366625264,10.721492136044276,11.665503666252633,4.5941092386286666,4.479363258307326,4.7056081386849824,5.771553070858583E-2,3.3310824849737139E-3,4.5660429136599729,96.162831268355077,99.3,96.436925888811302,102.22648819782938,2.8630741111886948,2.9264881978293857,4.598145571051127,4.5688891769112203,4.6271908242061652,1.487286920789411E-2,2.2120223847512478E-4,4.5946877763315284,98.957233933210787,null,94.1,3.2795401633023573,3.3677032034388361,91.1,13.735856251416507,15.471096494394885,85.8,3.2305899434977761,3.3245964310209359]
[10,"J市",88,84.391439897775413,91.723181082238597,91.9,76.315867061575403,109.72986991277841,93.1,89.09747077279691,97.236001134381169,null,10,0.93902439024390238,1.5466352713992295,110.7,107.52033890803258,113.94981495362127,3.179661091967418,3.2498149536212679,4.7068238397145912,4.6776800288163054,4.7357581317642783,1.4815842588768594E-2,2.1950919161516926E-4,4.7022905912807609,110.19930514291723,109,95.507532539800025,123.86419214061195,13.492467460199975,14.864192140611948,4.6913478822291435,4.5592051191385377,4.8191857407357377,6.6321587142142868E-2,4.3985529210528503E-3,4.6311288592566591,102.62985340331377,101.9,98.62021449964034,105.2610643602677,3.2797855003596652,3.3610643602676902,4.6239919402286791,4.5912762558051776,4.6564435916004046,1.6624320355925239E-2,2.7636802729643023E-4,4.6188939119535819,101.38183285640078,null,88,3.6085601022245868,3.7231810822385967,91.9,15.584132938424602,17.829869912778406,93.1,4.0025292272030839,4.1360011343811749]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"推定値の平均",null,null,null,null,null,{"$f":"AVERAGE(U6:U15)","v":4.5698402950255375},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AG6:AG15)","v":4.5092289162842034},null,null,null,null,null,null,{"$f":"AVERAGE(AN6:AN15)","v":94.14},null,null,null,null,{"$f":"AVERAGE(AS6:AS15)","v":4.5436585508561489}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"〃分散",null,null,null,null,null,{"$f":"VAR(U6:U15)","v":4.104767290657378E-3},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VAR(AG6:AG15)","v":1.021104563781493E-2},null,null,null,null,null,null,{"$f":"VAR(AN6:AN15)","v":22.022666666666677},null,null,null,null,{"$f":"VAR(AS6:AS15)","v":2.5067840249803196E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"〃標準偏差",null,null,null,null,null,{"$f":"SQRT(U17)","v":6.4068457845162602E-2},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(AG17)","v":0.1010497186429281},null,null,null,null,null,null,{"$f":"SQRT(AN17)","v":4.692831412555396},null,null,null,null,{"$f":"SQRT(AS17)","v":5.0067794289146789E-2}]
[{"$f":"A3&\"の分布の推移\"","v":"XX県・標準化死亡比【女性】の分布の推移"},null,null,null,null,null,{"$f":"A3&\"の推定値の推移\"","v":"XX県・標準化死亡比【女性】の推定値の推移"},null,null,null,null,null,null,null,"誤差分散",null,null,null,null,null,{"$f":"AVERAGE(Y6:Y15)","v":2.6718581841432765E-4},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AK6:AK15)","v":5.6363008539554813E-3},null,null,null,null,null,null,{"$f":"AVERAGE(AX6:AX15)","v":4.5436585508561489},null,null,null,null,{"$f":"AVERAGE(AW6:AW15)","v":3.0806995142848277E-4}]
["誤差分散を補正した値であり推定値とは異なる",null,null,null,null,null,null,null,null,null,null,null,null,null,"真値の分布の分散",null,null,null,null,null,{"$f":"+U17-U19","v":3.8375814722430503E-3},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AG17-AG19","v":4.5747447838594482E-3},null,null,null,null,null,null,{"$f":"+AN17-AN19","v":17.479008115810529},null,null,null,null,{"$f":"+AS17-AS19","v":2.198714073551837E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"〃標準偏差",null,null,null,null,null,{"$f":"SQRT(U20)","v":6.1948216053757756E-2},null,null,null,null,null,{"$f":"STDEV(AA6:AA15)","v":6.1329127053179553},null,null,null,null,null,{"$f":"SQRT(AG20)","v":6.7636859654033668E-2},null,null,null,null,null,{"$f":"STDEV(AM6:AM15)","v":6.1608646194879695},{"$f":"SQRT(AN20)","v":4.1807903697519357},null,null,null,null,{"$f":"SQRT(AS20)","v":4.6890447572526292E-2},null,null,null,null,null,{"$f":"STDEV(AY6:AY15)","v":4.395566791946556}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"凡例1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"C4&\"(SD=\"&FIXED(AA21,2)&\")\"","v":"2000年(SD=6.13)"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"F4&\"(SD=\"&FIXED(AM21,2)&\")\"","v":"2013年(SD=6.16)"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"I4&\"(SD=\"&FIXED(AY21,2)&\")\"","v":"2016年(SD=4.40)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"凡例2",null,null,null,null,null,null,null,null,null,null,null,{"$f":"C4","v":"2000年"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"○\"&F4","v":"○2013年"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"●\"&I4","v":"●2016年"}]