{"text_format":"3","workbook":"xls","n_sheets":6,"sheets":["Schmuck","Schmuck_mit_Graphik","Schmuck_Lösungsversuch_Zusammen","Korrel_von_Hand","Lösung_Korrel_von_Hand","Tabelle3"],"not_rendered":{"charts":2,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Schmuck","index":0,"n_rows":29,"n_cols":3,"rows_kept":29,"flags":["formulas_cached_only"]}
["Einkommen (in Tausend pro Monat)","Ausgaben für Schmuck (in Franken pro Jahr)"]
[3.639,171.75,"Wie ist der Zusammenhang?"]
[6.904,341.73]
[6.646,356.94]
[10.267,520.97]
[3.589,197.17]
[4.505,206.69]
[5.451,291.45]
[8.017,428.15]
[8.883,487.37]
[9.12,426.88]
[5.353,300.81]
[8.484,397.49]
[4.569,208.94]
[7.125,379.77]
[5.006,237.49]
[10.173,529.88]
[2.643,113.3]
[7.549,369.45]
[6.489,317.59]
[5.815,294.22]
[8.54,425.21]
[4.407,214.56]
[8.701,445.8]
[8.817,439.95]
[7.705,388.25]
[6.059,311.42]
[6.604,363.83]
[6.406,330.14]

{"sheet":"Schmuck_mit_Graphik","index":1,"n_rows":29,"n_cols":6,"rows_kept":29,"flags":["formulas_cached_only"]}
["Einkommen (in Tausend pro Monat)","Ausgaben für Schmuck (in Franken pro Jahr)",{"$nulls":3},"Hypothese:"]
[3.639,171.75,{"$nulls":3},"Je mehr jemand pro Monat verdient"]
[6.904,341.73,{"$nulls":3},"desto mehr gibt er im Jahr für Schmuck aus."]
[6.646,356.94]
[10.267,520.97]
[3.589,197.17]
[4.505,206.69]
[5.451,291.45]
[8.017,428.15]
[8.883,487.37]
[9.12,426.88]
[5.353,300.81]
[8.484,397.49]
[4.569,208.94]
[7.125,379.77]
[5.006,237.49]
[10.173,529.88]
[2.643,113.3]
[7.549,369.45]
[6.489,317.59]
[5.815,294.22]
[8.54,425.21,null,"Wir suchen eine Kennzahl, die den Zusammenhang der beiden Variablen"]
[4.407,214.56,null,"beschreibt."]
[8.701,445.8]
[8.817,439.95]
[7.705,388.25]
[6.059,311.42]
[6.604,363.83]
[6.406,330.14]

{"sheet":"Schmuck_Lösungsversuch_Zusammen","index":2,"n_rows":61,"n_cols":6,"rows_kept":61,"flags":["formulas_cached_only"]}
["Einkommen (in Tausend pro Monat)","Ausgaben für Schmuck (in Franken pro Jahr)",{"$nulls":3},"Hypothese:"]
[3.639,171.75,6.695214285714287,339.1857142857143,null,"Je mehr jemand pro Monat verdient"]
[6.904,341.73,6.695214285714287,339.1857142857143,null,"desto mehr gibt er im Jahr für Schmuck aus."]
[6.646,356.94]
[10.267,520.97]
[3.589,197.17]
[4.505,206.69]
[5.451,291.45]
[8.017,428.15]
[8.883,487.37]
[9.12,426.88]
[5.353,300.81]
[8.484,397.49]
[4.569,208.94]
[7.125,379.77]
[5.006,237.49]
[10.173,529.88]
[2.643,113.3]
[7.549,369.45]
[6.489,317.59]
[5.815,294.22]
[8.54,425.21,"Wir suchen eine Kennzahl, die den Zusammenhang der beiden Variablen"]
[4.407,214.56,"beschreibt."]
[8.701,445.8]
[8.817,439.95]
[7.705,388.25]
[6.059,311.42]
[6.604,363.83]
[6.406,330.14]
[]
[]
[]
["Einkommen (in Tausend pro Monat)","Ausgaben für Schmuck (in Franken pro Jahr)","beide kleiner als ihr Mittelwert","beide grösser als ihr Mittelwert"]
[3.639,171.75,1,0,"summe mit gleichem vorzeichen",26]
[6.904,341.73,0,1,"Summe mit ungleichem vorzeichen",2]
[6.646,356.94,0,0,"Anzahl",28]
[10.267,520.97,0,1,"Anzahl",0.8571428571428571]
[3.589,197.17,1,0]
[4.505,206.69,1,0]
[5.451,291.45,1,0]
[8.017,428.15,0,1]
[8.883,487.37,0,1]
[9.12,426.88,0,1]
[5.353,300.81,1,0]
[8.484,397.49,0,1]
[4.569,208.94,1,0]
[7.125,379.77,0,1]
[5.006,237.49,1,0]
[10.173,529.88,0,1]
[2.643,113.3,1,0]
[7.549,369.45,0,1]
[6.489,317.59,1,0]
[5.815,294.22,1,0]
[8.54,425.21,0,1]
[4.407,214.56,1,0]
[8.701,445.8,0,1]
[8.817,439.95,0,1]
[7.705,388.25,0,1]
[6.059,311.42,1,0]
[6.604,363.83,0,0]
[6.406,330.14,1,0]

{"sheet":"Korrel_von_Hand","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"flags":["formulas_cached_only"]}
["Einkommen","Ausgaben für Schmuck"]
[1,7]
[2,8]
[5,9]
[8,10]
[9,11]

{"sheet":"Lösung_Korrel_von_Hand","index":4,"n_rows":32,"n_cols":5,"rows_kept":32,"flags":["formulas_cached_only"]}
["Einkommen","Ausgaben für Schmuck"]
[1,7]
[2,8]
[5,9]
[8,10]
[9,11]
[]
["xquer","=(1+2+5+8+9)/5"]
[null,5]
[]
["yquer","=(7+8+9+10+11)/5"]
[null,9]
[]
["Summe (xi-xquer)(yi-yquer)"]
["(1-5)*(7-9)+(2-5)*(8-9)+(5-5)*(9-9)+(8-5)*(10-9)+(9-5)*(11-9) ="]
[22]
["Kovarianz","=22/4",5.5]
[]
["Varianz x Daten"]
["Summe (xi-xquer)^2"]
["(1-5)^2+(2-5)^2+(5-5)^2+(8-5)^2+(9-5)^2 ="]
[50]
["Varianz: 50/4",12.5,"Stabw","wurzel(12.5)=",3.5355339059327378]
[]
["Varianz y Daten"]
["Summe (yi-yquer)^2"]
["(7-9)^2+(8-9)^2+(9-9)^2+(10-9)^2+(11-9)^2="]
[10]
["Varianz: 10/4",2.5,"Stabw","wurzel(2.5)=",1.5811388300841898]
[]
["Pearson-Korrelation: ",null,0.9838699100999074]
[null,null,"=5.5/(WURZEL(2.5)*WURZEL(12.5))"]

{"sheet":"Tabelle3","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}