{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["単純回帰","手計算","Sheet6"],"not_rendered":{"charts":2,"images":0,"macros":0,"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":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,null,"ｘ","ｙ"]
[null,1,40,32]
[null,2,30,24]
[null,3,50,38]
[null,4,45,31]
[null,5,35,25]

{"sheet":"手計算","index":1,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,null,"ｘ","ｙ","ｘｙ","ｘ＾２","ｙ＾２"]
[null,1,40,32,{"$f":"C2*D2","v":1280},{"$f":"C2^2","v":1600},{"$f":"D2^2","v":1024}]
[null,2,30,24,{"$f":"C3*D3","v":720},{"$f":"C3^2","v":900},{"$f":"D3^2","v":576}]
[null,3,50,38,1900,2500,1444]
[null,4,45,31,1395,2025,961]
[null,5,35,25,875,1225,625]
[null,"合計",{"$f":"SUM(C2:C6)","v":200},{"$f":"SUM(D2:D6)","v":150},6170,8250,4630]

{"sheet":"Sheet6","index":2,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,5,11,7]]}
[null,"所得","消費","（１）ｘｙ","（１）ｘ＾２","（１）ｙ＾２","（４）y_h(予測値）","（5）u_h(残さ）","y_h＾２(予測値）","y_h＾２(予測値）"]
[1,40,32,{"$f":"B2*C2","v":1280},{"$f":"B2^2","v":1600},{"$f":"C2^2","v":1024},{"$f":"$E$12+$E$11*B2","v":30},{"$f":"C2-G2","v":2},{"$f":"G2^2","v":900},{"$f":"H2^2","v":4}]
[2,30,24,{"$f":"B3*C3","v":720},{"$f":"B3^2","v":900},576,{"$f":"$E$12+$E$11*B3","v":23.2},{"$f":"C3-G3","v":0.80000000000000071},{"$f":"G3^2","v":538.24},{"$f":"H3^2","v":0.64000000000000112}]
[3,50,38,1900,2500,1444,36.799999999999997,1.2000000000000028,1354.2399999999998,1.4400000000000068]
[4,45,31,1395,2025,961,33.4,-2.3999999999999986,1115.56,5.7599999999999936]
[5,35,25,875,1225,625,26.599999999999998,-1.5999999999999979,707.55999999999983,2.5599999999999934]
["合計",{"$f":"SUM(B2:B6)","v":200},{"$f":"SUM(C2:C6)","v":150},6170,8250,4630,{"$f":"SUM(G2:G6)","v":150},{"$f":"SUM(H2:H6)","v":7.1054273576010019E-15},{"$f":"SUM(I2:I6)","v":4615.5999999999995},{"$f":"SUM(J2:J6)","v":14.399999999999995}]
["平均",{"$f":"B7/5","v":40},{"$f":"C7/5","v":30}]
[null,null,null,null,null,null,"（↑$E$12+$E$11*Bｎ）","（↑C2-G2）","（↑Cn^2）","（↑Hn^2）"]
["（２）準備",null,null,"（３）推定量"]
["Sxｙ＝",{"$f":"D7-5*B8*C8","v":170},"（D7-5*B8*C8）","a_h(予測値）",{"$f":"B11/B12","v":0.68},"（B11/B12）"]
["Sxx＝",{"$f":"E7-5*B8^2","v":250},"（E7-5*B8^2）","ｂ_h(予測値）",{"$f":"C8-E11*B8","v":2.7999999999999972},"（B11/B12）C8-E11*B8）"]
["Syy=",{"$f":"F7-5*C8^2","v":130},"（F7-5*C8＾２）"]