{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cover","Daten","Regression","Parameter","Korrelation","RGP","RKP"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":14,"defined_names":48,"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":"Cover","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"Stochastik"]
[]
[]
[null,"Kapitel",6]
[null,"Thema","Beobachtungen und Messungen"]
[]
[null,"Inhalt","Regression und Korrelation"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Letzte Bearbeitung","2021-10-15"]
[]
[]
[null,"Springer Vieweg Verlag"]

{"sheet":"Daten","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Monat","Sonnenstd.","Besucher"]
[1,1.2,988]
[2,2.2999999999999998,1389]
[3,3.5,2133]
[4,4.9000000000000004,2987]
[5,6,3246]
[6,6.9,2856]
[7,7.3,2655]
[8,6.5,2431]
[9,4.8,2078]
[10,3.2,1891]
[11,2.1,1345]
[12,1.6,1120]

{"sheet":"Regression","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[1.2,988,null,314.24610808451479,1153.1303933138267]
[2.2999999999999998,1389,null,776.03506361240898,1498.8011122067928]
[3.5,2133,null,0.89140191424452409,1875.8964419082108]
[4.9000000000000004,2987,null,null,2315.8409932265313]
[6,3246,null,null,2661.5117121194976]
[6.9,2856,null,null,2944.333209395561]
[7.3,2655,null,null,3070.0316526293668]
[6.5,2431,null,null,2818.6347661617551]
[4.8,2078,null,null,2284.4163824180796]
[3.2,1891,null,null,1781.6226094828562]
[2.1,1345,null,null,1435.9518905898899]
[1.6,1120,null,null,1278.8288365476326]

{"sheet":"Parameter","index":3,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["AUSGABE: ZUSAMMENFASSUNG"]
[]
["Regressions-Statistik"]
["Multipler Korrelationskoeffizient",0.89140191424452409]
["Bestimmtheitsmaß",0.79459737271880182]
["Adjustiertes Bestimmtheitsmaß",0.774057109990682]
["Standardfehler",362.75229349728914]
["Beobachtungen",12]
[]
["ANOVA"]
[null,"Freiheitsgrade (df)","Quadratsummen (SS)","Mittlere Quadratsumme (MS)","Prüfgröße (F)","F krit"]
["Regression",1,5090511.9856245657,5090511.9856245657,38.684868992984704,9.8875750282183852E-5]
["Residue",10,1315892.264375434,131589.2264375434]
["Gesamt",11,6406404.25]
[]
[null,"Koeffizienten","Standardfehler","t-Statistik","P-Wert","Untere 95%","Obere 95%","Untere 95,0%","Obere 95,0%"]
["Schnittpunkt",776.03506361240943,236.25573477856591,3.284724768013608,8.223007709170704E-3,249.62448194772185,1302.4456452770969,249.62448194772185,1302.4456452770969]
["X Variable 1",314.24610808451467,50.524187998268069,6.2197161505156062,9.8875750282184123E-5,201.67120184051495,426.82101432851437,201.67120184051495,426.82101432851437]

{"sheet":"Korrelation","index":4,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Sonnenstd.","Besucher"]
["Sonnenstd.",1]
["Besucher",0.89140191424452409,1]

{"sheet":"RGP","index":5,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Monat","Besucher"]
[1,988,null,{"$f":"LINEST(B2:B13,A2:A13,TRUE,TRUE)","v":-27.374125874125866},2271.181818181818]
[2,1389,null,66.3706915384398,488.47506350025787]
[3,2133,null,1.6726389961149512E-2,793.67803511661668]
[4,2987,null,0.17010921263806347,10]
[5,3246,null,107156.01573426556,6299248.2342657344]
[6,2856]
[7,2655]
[8,2431]
[9,2078]
[10,1891]
[11,1345]
[12,1120]

{"sheet":"RKP","index":6,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Monat","Besucher"]
[1,988,null,{"$f":"LOGEST(B2:B13,A2:A13,TRUE,TRUE)","v":0.99126938400846565},2068.5398895123458]
[2,1389,null,3.5040225097431453E-2,0.25788907396901162]
[3,2133,null,6.2237214699018941E-3,0.41902014821205086]
[4,2987,null,6.2626987626505301E-2,10]
[5,3246,null,1.0995914006811214E-2,1.7557788460764907]
[6,2856]
[7,2655]
[8,2431]
[9,2078]
[10,1891]
[11,1345]
[12,1120]