{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["平均値の差の検定"],"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":"平均値の差の検定","index":0,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["2つのグループ（母集団）の平均値の間に，偶然とは言えない「統計的な有意差」があるかを判定する"]
[]
["群A","群B"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"↓分散が等しい前提","↓分散がわからない前提"]
[null,null,null,"片側=1，両側=2",1,null,null,null,"Studentのt検定（等分散）","Welchのt検定（不等分散）"]
[null,null,null,null,null,null,null,"p値",{"$f":"IFERROR(_xlfn.T.TEST(A4:A1002,B4:B1002,$E$9,2),\"\")","v":""},{"$f":"IFERROR(_xlfn.T.TEST(A4:A1000,B4:B1000,$E$9,3),\"\")","v":""}]
[null,null,null,null,"群A","群B",null,"t統計量",{"$f":"IFERROR((F13-E13)/(SQRT(((E14^2)*(E12-1)+(F14^2)*(F12-1))/(E12+F12-2))*SQRT(1/E12+1/F12)),\"\")","v":""},{"$f":"IFERROR((F13-E13)/SQRT((E14^2)/E12 + (F14^2)/F12),\"\")","v":""}]
[null,null,null,"大きさ（nA）",{"$f":"COUNTA(A4:A1000)","v":0},{"$f":"COUNTA(B4:B1000)","v":0},null,"自由度 df",{"$f":"IFERROR(E12+F12-2,\"\")","v":-2},{"$f":"IFERROR(((E14^2/E12 + F14^2/F12)^2)/(((E14^2/E12)^2)/(E12-1) + ((F14^2/F12)^2)/(F12-1)),\"\")","v":""}]
[null,null,null,"平均値",{"$f":"IFERROR(AVERAGE(A4:A1000),\"\")","v":""},{"$f":"IFERROR(AVERAGE(B4:B1000),\"\")","v":""},null,"有意判定",{"$f":"IF(I10<>\"\", IF(I10<0.05, \"有意\", \"非有意\"), \"\")","v":""},{"$f":"IF(J10<>\"\", IF(J10<0.05, \"有意\", \"非有意\"), \"\")","v":""}]
[null,null,null,"標準偏差",{"$f":"IFERROR(_xlfn.STDEV.S(A4:A1000),\"\")","v":""},{"$f":"IFERROR(_xlfn.STDEV.S(B4:B1000),\"\")","v":""},null,"※t検定は、正規分布（きれいな山形）を仮定しています。"]
[null,null,null,null,null,null,null,"※今回は対応していない２群（横が同じ人でない）の検定をしています。"]