{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cover","Daten","Regression","Korrelation"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":6,"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,"für Controller"]
[]
[]
[null,"Kapitel",6]
[null,"Thema","Analyse-Methoden"]
[]
[null,"Inhalt","Regression und Korrelation"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-04-26"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Daten","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Ziele\n","Erfolg\n[%]","Risiko \n[%]"]
["A",15,20]
["B",40,65]
["C",60,30]
["D",60,80]
["E",70,35]

{"sheet":"Regression","index":2,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["AUSGABE: ZUSAMMENFASSUNG"]
[]
["Regressions-Statistik"]
["Multipler Korrelationskoeffizient",0.30612002257788817]
["Bestimmtheitsmaß",9.3709468223086775E-2]
["Adjustiertes Bestimmtheitsmaß",-0.20838737570255095]
["Standardfehler",27.863755828834151]
["Beobachtungen",5]
[]
["ANOVA"]
[null,"Freiheitsgrade (df)","Quadratsummen (SS)","Mittlere Quadratsumme (MS)","Prüfgröße (F)","F krit"]
["Regression",1,240.83333333333303,240.83333333333303,0.3101967799642214,0.61641188233010413]
["Residue",3,2329.166666666667,776.38888888888903]
["Gesamt",4,2570]
[]
[null,"Koeffizienten","Standardfehler","t-Statistik","P-Wert","Untere 95%","Obere 95%","Untere 95,0%","Obere 95,0%"]
["Schnittpunkt",28.645833333333329,33.558430507129678,0.85361063972426721,0.45605911920597197,-78.152069845201623,135.44373651186828,-78.152069845201623,135.44373651186828]
["X Variable 1",0.35416666666666674,0.63590031684452164,0.55695312187312673,0.61641188233010391,-1.6695519472039211,2.3778852805372548,-1.6695519472039211,2.3778852805372548]

{"sheet":"Korrelation","index":3,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Spalte 1","Spalte 2"]
["Spalte 1",1]
["Spalte 2",0.3061200225778884,1]