<-μ

<-σ

xquer

s_x

H(x)

x

ϕ^{-1}(H(x))

Korrektur

GeoGebras

Eingabe:
A1: Erwartungswert μ, A2: Standardabweichung σ
Ausgabe:
(1) Histogramm zu 100 N(μ;σ) - normalverteilten Zufallszahlen (blau)
(2) Dichte φ Verteilungsfunktion ϕ der Normalverteilung (schwarz)
      Empirische Verteilungsfunktion der Zufallszahlen (blaue Punkte)
      NQ-Plot der Normalverteilung (schwarze Modellgerade)
      mit Nullstelle μ, Steigung 1/σ
(3) aus den Zufallszahlen rekonstruierter NQ-Plot (rot)
Hinweis: 
Man kann A5:A105 durch Messdaten/Zufallszahlen 
überscheiben und an der Linearität des NQ-Plots ablesen, 
wie gut das Normalverteilungsmodell passt. 

Info

Simulation

A1: 4
A2: 0.5
A106 = RandomNormal($A$1, $A$2)
A105 = RandomNormal($A$1, $A$2)
A104 = RandomNormal($A$1, $A$2)
A103 = RandomNormal($A$1, $A$2)
A102 = RandomNormal($A$1, $A$2)
A101 = RandomNormal($A$1, $A$2)
A100 = RandomNormal($A$1, $A$2)
A99 = RandomNormal($A$1, $A$2)
A98 = RandomNormal($A$1, $A$2)
A97 = RandomNormal($A$1, $A$2)
A96 = RandomNormal($A$1, $A$2)
A95 = RandomNormal($A$1, $A$2)
A94 = RandomNormal($A$1, $A$2)
A93 = RandomNormal($A$1, $A$2)
A92 = RandomNormal($A$1, $A$2)
A91 = RandomNormal($A$1, $A$2)
A90 = RandomNormal($A$1, $A$2)
A89 = RandomNormal($A$1, $A$2)
A88 = RandomNormal($A$1, $A$2)
A87 = RandomNormal($A$1, $A$2)
A86 = RandomNormal($A$1, $A$2)
A85 = RandomNormal($A$1, $A$2)
A84 = RandomNormal($A$1, $A$2)
A83 = RandomNormal($A$1, $A$2)
A82 = RandomNormal($A$1, $A$2)
A81 = RandomNormal($A$1, $A$2)
A80 = RandomNormal($A$1, $A$2)
A79 = RandomNormal($A$1, $A$2)
A78 = RandomNormal($A$1, $A$2)
A77 = RandomNormal($A$1, $A$2)
A76 = RandomNormal($A$1, $A$2)
A75 = RandomNormal($A$1, $A$2)
A74 = RandomNormal($A$1, $A$2)
A73 = RandomNormal($A$1, $A$2)
A72 = RandomNormal($A$1, $A$2)
A71 = RandomNormal($A$1, $A$2)
A70 = RandomNormal($A$1, $A$2)
A69 = RandomNormal($A$1, $A$2)
A68 = RandomNormal($A$1, $A$2)
A67 = RandomNormal($A$1, $A$2)
A66 = RandomNormal($A$1, $A$2)
A65 = RandomNormal($A$1, $A$2)
A64 = RandomNormal($A$1, $A$2)
A63 = RandomNormal($A$1, $A$2)
A62 = RandomNormal($A$1, $A$2)
A61 = RandomNormal($A$1, $A$2)
A60 = RandomNormal($A$1, $A$2)
A59 = RandomNormal($A$1, $A$2)
A58 = RandomNormal($A$1, $A$2)
A57 = RandomNormal($A$1, $A$2)
A56 = RandomNormal($A$1, $A$2)
A55 = RandomNormal($A$1, $A$2)
A54 = RandomNormal($A$1, $A$2)
A53 = RandomNormal($A$1, $A$2)
A52 = RandomNormal($A$1, $A$2)
A51 = RandomNormal($A$1, $A$2)
A50 = RandomNormal($A$1, $A$2)
A49 = RandomNormal($A$1, $A$2)
A48 = RandomNormal($A$1, $A$2)
A47 = RandomNormal($A$1, $A$2)
A46 = RandomNormal($A$1, $A$2)
A45 = RandomNormal($A$1, $A$2)
A44 = RandomNormal($A$1, $A$2)
A43 = RandomNormal($A$1, $A$2)
A42 = RandomNormal($A$1, $A$2)
A41 = RandomNormal($A$1, $A$2)
A40 = RandomNormal($A$1, $A$2)
A39 = RandomNormal($A$1, $A$2)
A38 = RandomNormal($A$1, $A$2)
A37 = RandomNormal($A$1, $A$2)
A36 = RandomNormal($A$1, $A$2)
A35 = RandomNormal($A$1, $A$2)
A34 = RandomNormal($A$1, $A$2)
A33 = RandomNormal($A$1, $A$2)
A32 = RandomNormal($A$1, $A$2)
A31 = RandomNormal($A$1, $A$2)
A30 = RandomNormal($A$1, $A$2)
A29 = RandomNormal($A$1, $A$2)
A28 = RandomNormal($A$1, $A$2)
A27 = RandomNormal($A$1, $A$2)
A26 = RandomNormal($A$1, $A$2)
A25 = RandomNormal($A$1, $A$2)
A24 = RandomNormal($A$1, $A$2)
A23 = RandomNormal($A$1, $A$2)
A22 = RandomNormal($A$1, $A$2)
A21 = RandomNormal($A$1, $A$2)
A20 = RandomNormal($A$1, $A$2)
A19 = RandomNormal($A$1, $A$2)
A18 = RandomNormal($A$1, $A$2)
A17 = RandomNormal($A$1, $A$2)
A16 = RandomNormal($A$1, $A$2)
A15 = RandomNormal($A$1, $A$2)
A14 = RandomNormal($A$1, $A$2)
A13 = RandomNormal($A$1, $A$2)
A12 = RandomNormal($A$1, $A$2)
A11 = RandomNormal($A$1, $A$2)
A10 = RandomNormal($A$1, $A$2)
A9 = RandomNormal($A$1, $A$2)
A8 = RandomNormal($A$1, $A$2)
A7 = RandomNormal($A$1, $A$2)
A6 = RandomNormal($A$1, $A$2)
A3 = mean(A6:A105)
B6: CountIf[x ≤ A6, $A$6:$A$105] / 100
B7: CountIf[x ≤ A7, $A$6:$A$105] / 100
B8: CountIf[x ≤ A8, $A$6:$A$105] / 100
B9: CountIf[x ≤ A9, $A$6:$A$105] / 100
B10: CountIf[x ≤ A10, $A$6:$A$105] / 100
B11: CountIf[x ≤ A11, $A$6:$A$105] / 100
B12: CountIf[x ≤ A12, $A$6:$A$105] / 100
B13: CountIf[x ≤ A13, $A$6:$A$105] / 100
B14: CountIf[x ≤ A14, $A$6:$A$105] / 100
B15: CountIf[x ≤ A15, $A$6:$A$105] / 100
B16: CountIf[x ≤ A16, $A$6:$A$105] / 100
B17: CountIf[x ≤ A17, $A$6:$A$105] / 100
B18: CountIf[x ≤ A18, $A$6:$A$105] / 100
B19: CountIf[x ≤ A19, $A$6:$A$105] / 100
B20: CountIf[x ≤ A20, $A$6:$A$105] / 100
B21: CountIf[x ≤ A21, $A$6:$A$105] / 100
B22: CountIf[x ≤ A22, $A$6:$A$105] / 100
B23: CountIf[x ≤ A23, $A$6:$A$105] / 100
B24: CountIf[x ≤ A24, $A$6:$A$105] / 100
B25: CountIf[x ≤ A25, $A$6:$A$105] / 100
B26: CountIf[x ≤ A26, $A$6:$A$105] / 100
B27: CountIf[x ≤ A27, $A$6:$A$105] / 100
B28: CountIf[x ≤ A28, $A$6:$A$105] / 100
B29: CountIf[x ≤ A29, $A$6:$A$105] / 100
B30: CountIf[x ≤ A30, $A$6:$A$105] / 100
B31: CountIf[x ≤ A31, $A$6:$A$105] / 100
B32: CountIf[x ≤ A32, $A$6:$A$105] / 100
B33: CountIf[x ≤ A33, $A$6:$A$105] / 100
B34: CountIf[x ≤ A34, $A$6:$A$105] / 100
B35: CountIf[x ≤ A35, $A$6:$A$105] / 100
B36: CountIf[x ≤ A36, $A$6:$A$105] / 100
B37: CountIf[x ≤ A37, $A$6:$A$105] / 100
B38: CountIf[x ≤ A38, $A$6:$A$105] / 100
B39: CountIf[x ≤ A39, $A$6:$A$105] / 100
B40: CountIf[x ≤ A40, $A$6:$A$105] / 100
B41: CountIf[x ≤ A41, $A$6:$A$105] / 100
B42: CountIf[x ≤ A42, $A$6:$A$105] / 100
B43: CountIf[x ≤ A43, $A$6:$A$105] / 100
B44: CountIf[x ≤ A44, $A$6:$A$105] / 100
B45: CountIf[x ≤ A45, $A$6:$A$105] / 100
B46: CountIf[x ≤ A46, $A$6:$A$105] / 100
B47: CountIf[x ≤ A47, $A$6:$A$105] / 100
B48: CountIf[x ≤ A48, $A$6:$A$105] / 100
B49: CountIf[x ≤ A49, $A$6:$A$105] / 100
B50: CountIf[x ≤ A50, $A$6:$A$105] / 100
B51: CountIf[x ≤ A51, $A$6:$A$105] / 100
B52: CountIf[x ≤ A52, $A$6:$A$105] / 100
B53: CountIf[x ≤ A53, $A$6:$A$105] / 100
B54: CountIf[x ≤ A54, $A$6:$A$105] / 100
B55: CountIf[x ≤ A55, $A$6:$A$105] / 100
B56: CountIf[x ≤ A56, $A$6:$A$105] / 100
B57: CountIf[x ≤ A57, $A$6:$A$105] / 100
B58: CountIf[x ≤ A58, $A$6:$A$105] / 100
B59: CountIf[x ≤ A59, $A$6:$A$105] / 100
B60: CountIf[x ≤ A60, $A$6:$A$105] / 100
B61: CountIf[x ≤ A61, $A$6:$A$105] / 100
B62: CountIf[x ≤ A62, $A$6:$A$105] / 100
B63: CountIf[x ≤ A63, $A$6:$A$105] / 100
B64: CountIf[x ≤ A64, $A$6:$A$105] / 100
B65: CountIf[x ≤ A65, $A$6:$A$105] / 100
B66: CountIf[x ≤ A66, $A$6:$A$105] / 100
B67: CountIf[x ≤ A67, $A$6:$A$105] / 100
B68: CountIf[x ≤ A68, $A$6:$A$105] / 100
B69: CountIf[x ≤ A69, $A$6:$A$105] / 100
B70: CountIf[x ≤ A70, $A$6:$A$105] / 100
B71: CountIf[x ≤ A71, $A$6:$A$105] / 100
B72: CountIf[x ≤ A72, $A$6:$A$105] / 100
B73: CountIf[x ≤ A73, $A$6:$A$105] / 100
B74: CountIf[x ≤ A74, $A$6:$A$105] / 100
B75: CountIf[x ≤ A75, $A$6:$A$105] / 100
B76: CountIf[x ≤ A76, $A$6:$A$105] / 100
B77: CountIf[x ≤ A77, $A$6:$A$105] / 100
B78: CountIf[x ≤ A78, $A$6:$A$105] / 100
B79: CountIf[x ≤ A79, $A$6:$A$105] / 100
B80: CountIf[x ≤ A80, $A$6:$A$105] / 100
B81: CountIf[x ≤ A81, $A$6:$A$105] / 100
B82: CountIf[x ≤ A82, $A$6:$A$105] / 100
B83: CountIf[x ≤ A83, $A$6:$A$105] / 100
B84: CountIf[x ≤ A84, $A$6:$A$105] / 100
B85: CountIf[x ≤ A85, $A$6:$A$105] / 100
B86: CountIf[x ≤ A86, $A$6:$A$105] / 100
B87: CountIf[x ≤ A87, $A$6:$A$105] / 100
B88: CountIf[x ≤ A88, $A$6:$A$105] / 100
B89: CountIf[x ≤ A89, $A$6:$A$105] / 100
B90: CountIf[x ≤ A90, $A$6:$A$105] / 100
B91: CountIf[x ≤ A91, $A$6:$A$105] / 100
B92: CountIf[x ≤ A92, $A$6:$A$105] / 100
B93: CountIf[x ≤ A93, $A$6:$A$105] / 100
B94: CountIf[x ≤ A94, $A$6:$A$105] / 100
B95: CountIf[x ≤ A95, $A$6:$A$105] / 100
B96: CountIf[x ≤ A96, $A$6:$A$105] / 100
B97: CountIf[x ≤ A97, $A$6:$A$105] / 100
B98: CountIf[x ≤ A98, $A$6:$A$105] / 100
B99: CountIf[x ≤ A99, $A$6:$A$105] / 100
B100: CountIf[x ≤ A100, $A$6:$A$105] / 100
B101: CountIf[x ≤ A101, $A$6:$A$105] / 100
B102: CountIf[x ≤ A102, $A$6:$A$105] / 100
B103: CountIf[x ≤ A103, $A$6:$A$105] / 100
B104: CountIf[x ≤ A104, $A$6:$A$105] / 100
B105: CountIf[x ≤ A105, $A$6:$A$105] / 100
B106: CountIf[x ≤ A106, $A$6:$A$105] / 100
ϕ = Normal(A1, A2, x, true)
A4 = stdevp(A6:A105)
a = NaN
C6 = InverseNormal(0, 1, B6)
C7 = InverseNormal(0, 1, B7)
C8 = InverseNormal(0, 1, B8)
C9 = InverseNormal(0, 1, B9)
C10 = InverseNormal(0, 1, B10)
C11 = InverseNormal(0, 1, B11)
C12 = InverseNormal(0, 1, B12)
C13 = InverseNormal(0, 1, B13)
C14 = InverseNormal(0, 1, B14)
C15 = InverseNormal(0, 1, B15)
C16 = InverseNormal(0, 1, B16)
C17 = InverseNormal(0, 1, B17)
C18 = InverseNormal(0, 1, B18)
C19 = InverseNormal(0, 1, B19)
C20 = InverseNormal(0, 1, B20)
C21 = InverseNormal(0, 1, B21)
C22 = InverseNormal(0, 1, B22)
C23 = InverseNormal(0, 1, B23)
C24 = InverseNormal(0, 1, B24)
C25 = InverseNormal(0, 1, B25)
C26 = InverseNormal(0, 1, B26)
C27 = InverseNormal(0, 1, B27)
C28 = InverseNormal(0, 1, B28)
C29 = InverseNormal(0, 1, B29)
C30 = InverseNormal(0, 1, B30)
C31 = InverseNormal(0, 1, B31)
C32 = InverseNormal(0, 1, B32)
C33 = InverseNormal(0, 1, B33)
C34 = InverseNormal(0, 1, B34)
C35 = InverseNormal(0, 1, B35)
C36 = InverseNormal(0, 1, B36)
C37 = InverseNormal(0, 1, B37)
C38 = InverseNormal(0, 1, B38)
C39 = InverseNormal(0, 1, B39)
C40 = InverseNormal(0, 1, B40)
C41 = InverseNormal(0, 1, B41)
C42 = InverseNormal(0, 1, B42)
C43 = InverseNormal(0, 1, B43)
C44 = InverseNormal(0, 1, B44)
C45 = InverseNormal(0, 1, B45)
C46 = InverseNormal(0, 1, B46)
C47 = InverseNormal(0, 1, B47)
C48 = InverseNormal(0, 1, B48)
C49 = InverseNormal(0, 1, B49)
C50 = InverseNormal(0, 1, B50)
C51 = InverseNormal(0, 1, B51)
C52 = InverseNormal(0, 1, B52)
C53 = InverseNormal(0, 1, B53)
C54 = InverseNormal(0, 1, B54)
C55 = InverseNormal(0, 1, B55)
C56 = InverseNormal(0, 1, B56)
C57 = InverseNormal(0, 1, B57)
C58 = InverseNormal(0, 1, B58)
C59 = InverseNormal(0, 1, B59)
C60 = InverseNormal(0, 1, B60)
C61 = InverseNormal(0, 1, B61)
C62 = InverseNormal(0, 1, B62)
C63 = InverseNormal(0, 1, B63)
C64 = InverseNormal(0, 1, B64)
C65 = InverseNormal(0, 1, B65)
C66 = InverseNormal(0, 1, B66)
C67 = InverseNormal(0, 1, B67)
C68 = InverseNormal(0, 1, B68)
C69 = InverseNormal(0, 1, B69)
C70 = InverseNormal(0, 1, B70)
C71 = InverseNormal(0, 1, B71)
C72 = InverseNormal(0, 1, B72)
C73 = InverseNormal(0, 1, B73)
C74 = InverseNormal(0, 1, B74)
C75 = InverseNormal(0, 1, B75)
C76 = InverseNormal(0, 1, B76)
C77 = InverseNormal(0, 1, B77)
C78 = InverseNormal(0, 1, B78)
C79 = InverseNormal(0, 1, B79)
C80 = InverseNormal(0, 1, B80)
C81 = InverseNormal(0, 1, B81)
C82 = InverseNormal(0, 1, B82)
C83 = InverseNormal(0, 1, B83)
C84 = InverseNormal(0, 1, B84)
C85 = InverseNormal(0, 1, B85)
C86 = InverseNormal(0, 1, B86)
C87 = InverseNormal(0, 1, B87)
C88 = InverseNormal(0, 1, B88)
C89 = InverseNormal(0, 1, B89)
C90 = InverseNormal(0, 1, B90)
C91 = InverseNormal(0, 1, B91)
C92 = InverseNormal(0, 1, B92)
C93 = InverseNormal(0, 1, B93)
C94 = InverseNormal(0, 1, B94)
C95 = InverseNormal(0, 1, B95)
C96 = InverseNormal(0, 1, B96)
C97 = InverseNormal(0, 1, B97)
C98 = InverseNormal(0, 1, B98)
C99 = InverseNormal(0, 1, B99)
C100 = InverseNormal(0, 1, B100)
C101 = InverseNormal(0, 1, B101)
C102 = InverseNormal(0, 1, B102)
C103 = InverseNormal(0, 1, B103)
C104 = InverseNormal(0, 1, B104)
C105 = InverseNormal(0, 1, B105)
C106 = InverseNormal(0, 1, B106)
H: (A6:A105, C6:C105)
F: (A6:A105, B6:B105)
modell(x) = (1 / A2 * (x - A1))
b = Histogram(false, Classes[{A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19, A20, A21, A22, A23, A24, A25, A26, A27, A28, A29, A30, A31, A32, A33, A34, A35, A36, A37, A38, A39, A40, A41, A42, A43, A44, A45, A46, A47, A48, A49, A50, A51, A52, A53, A54, A55, A56, A57, A58, A59, A60, A61, A62, A63, A64, A65, A66, A67, A68, A69, A70, A71, A72, A73, A74, A75, A76, A77, A78, A79, A80, A81, A82, A83, A84, A85, A86, A87, A88, A89, A90, A91, A92, A93, A94, A95, A96, A97, A98, A99, A100, A101, A102, A103, A104, A105, A106}, 20], {A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19, A20, A21, A22, A23, A24, A25, A26, A27, A28, A29, A30, A31, A32, A33, A34, A35, A36, A37, A38, A39, A40, A41, A42, A43, A44, A45, A46, A47, A48, A49, A50, A51, A52, A53, A54, A55, A56, A57, A58, A59, A60, A61, A62, A63, A64, A65, A66, A67, A68, A69, A70, A71, A72, A73, A74, A75, A76, A77, A78, A79, A80, A81, A82, A83, A84, A85, A86, A87, A88, A89, A90, A91, A92, A93, A94, A95, A96, A97, A98, A99, A100, A101, A102, A103, A104, A105, A106}, true, 0.009900990099009901)
φ(x) = exp(((x - 3.9719329410536646) / 0.5271118215919737)^(2) / -2) / 2.5066282746310002 / 0.5271118215919737
D6 = InverseNormal(0, 1, ((B6 * 100) - 0.3175) / (100 + 0.365))
D7 = InverseNormal(0, 1, ((B7 * 100) - 0.3175) / (100 + 0.365))
D8 = InverseNormal(0, 1, ((B8 * 100) - 0.3175) / (100 + 0.365))
D9 = InverseNormal(0, 1, ((B9 * 100) - 0.3175) / (100 + 0.365))
D10 = InverseNormal(0, 1, ((B10 * 100) - 0.3175) / (100 + 0.365))
D11 = InverseNormal(0, 1, ((B11 * 100) - 0.3175) / (100 + 0.365))
D12 = InverseNormal(0, 1, ((B12 * 100) - 0.3175) / (100 + 0.365))
D13 = InverseNormal(0, 1, ((B13 * 100) - 0.3175) / (100 + 0.365))
D14 = InverseNormal(0, 1, ((B14 * 100) - 0.3175) / (100 + 0.365))
D15 = InverseNormal(0, 1, ((B15 * 100) - 0.3175) / (100 + 0.365))
D16 = InverseNormal(0, 1, ((B16 * 100) - 0.3175) / (100 + 0.365))
D17 = InverseNormal(0, 1, ((B17 * 100) - 0.3175) / (100 + 0.365))
D18 = InverseNormal(0, 1, ((B18 * 100) - 0.3175) / (100 + 0.365))
D19 = InverseNormal(0, 1, ((B19 * 100) - 0.3175) / (100 + 0.365))
D20 = InverseNormal(0, 1, ((B20 * 100) - 0.3175) / (100 + 0.365))
D21 = InverseNormal(0, 1, ((B21 * 100) - 0.3175) / (100 + 0.365))
D22 = InverseNormal(0, 1, ((B22 * 100) - 0.3175) / (100 + 0.365))
D23 = InverseNormal(0, 1, ((B23 * 100) - 0.3175) / (100 + 0.365))
D24 = InverseNormal(0, 1, ((B24 * 100) - 0.3175) / (100 + 0.365))
D25 = InverseNormal(0, 1, ((B25 * 100) - 0.3175) / (100 + 0.365))
D26 = InverseNormal(0, 1, ((B26 * 100) - 0.3175) / (100 + 0.365))
D27 = InverseNormal(0, 1, ((B27 * 100) - 0.3175) / (100 + 0.365))
D28 = InverseNormal(0, 1, ((B28 * 100) - 0.3175) / (100 + 0.365))
D29 = InverseNormal(0, 1, ((B29 * 100) - 0.3175) / (100 + 0.365))
D30 = InverseNormal(0, 1, ((B30 * 100) - 0.3175) / (100 + 0.365))
D31 = InverseNormal(0, 1, ((B31 * 100) - 0.3175) / (100 + 0.365))
D32 = InverseNormal(0, 1, ((B32 * 100) - 0.3175) / (100 + 0.365))
D33 = InverseNormal(0, 1, ((B33 * 100) - 0.3175) / (100 + 0.365))
D34 = InverseNormal(0, 1, ((B34 * 100) - 0.3175) / (100 + 0.365))
D35 = InverseNormal(0, 1, ((B35 * 100) - 0.3175) / (100 + 0.365))
D36 = InverseNormal(0, 1, ((B36 * 100) - 0.3175) / (100 + 0.365))
D37 = InverseNormal(0, 1, ((B37 * 100) - 0.3175) / (100 + 0.365))
D38 = InverseNormal(0, 1, ((B38 * 100) - 0.3175) / (100 + 0.365))
D39 = InverseNormal(0, 1, ((B39 * 100) - 0.3175) / (100 + 0.365))
D40 = InverseNormal(0, 1, ((B40 * 100) - 0.3175) / (100 + 0.365))
D41 = InverseNormal(0, 1, ((B41 * 100) - 0.3175) / (100 + 0.365))
D42 = InverseNormal(0, 1, ((B42 * 100) - 0.3175) / (100 + 0.365))
D43 = InverseNormal(0, 1, ((B43 * 100) - 0.3175) / (100 + 0.365))
D44 = InverseNormal(0, 1, ((B44 * 100) - 0.3175) / (100 + 0.365))
D45 = InverseNormal(0, 1, ((B45 * 100) - 0.3175) / (100 + 0.365))
D46 = InverseNormal(0, 1, ((B46 * 100) - 0.3175) / (100 + 0.365))
D47 = InverseNormal(0, 1, ((B47 * 100) - 0.3175) / (100 + 0.365))
D48 = InverseNormal(0, 1, ((B48 * 100) - 0.3175) / (100 + 0.365))
D49 = InverseNormal(0, 1, ((B49 * 100) - 0.3175) / (100 + 0.365))
D50 = InverseNormal(0, 1, ((B50 * 100) - 0.3175) / (100 + 0.365))
D51 = InverseNormal(0, 1, ((B51 * 100) - 0.3175) / (100 + 0.365))
D52 = InverseNormal(0, 1, ((B52 * 100) - 0.3175) / (100 + 0.365))
D53 = InverseNormal(0, 1, ((B53 * 100) - 0.3175) / (100 + 0.365))
D54 = InverseNormal(0, 1, ((B54 * 100) - 0.3175) / (100 + 0.365))
D55 = InverseNormal(0, 1, ((B55 * 100) - 0.3175) / (100 + 0.365))
D56 = InverseNormal(0, 1, ((B56 * 100) - 0.3175) / (100 + 0.365))
D57 = InverseNormal(0, 1, ((B57 * 100) - 0.3175) / (100 + 0.365))
D58 = InverseNormal(0, 1, ((B58 * 100) - 0.3175) / (100 + 0.365))
D59 = InverseNormal(0, 1, ((B59 * 100) - 0.3175) / (100 + 0.365))
D60 = InverseNormal(0, 1, ((B60 * 100) - 0.3175) / (100 + 0.365))
D61 = InverseNormal(0, 1, ((B61 * 100) - 0.3175) / (100 + 0.365))
D62 = InverseNormal(0, 1, ((B62 * 100) - 0.3175) / (100 + 0.365))
D63 = InverseNormal(0, 1, ((B63 * 100) - 0.3175) / (100 + 0.365))
D64 = InverseNormal(0, 1, ((B64 * 100) - 0.3175) / (100 + 0.365))
D65 = InverseNormal(0, 1, ((B65 * 100) - 0.3175) / (100 + 0.365))
D66 = InverseNormal(0, 1, ((B66 * 100) - 0.3175) / (100 + 0.365))
D67 = InverseNormal(0, 1, ((B67 * 100) - 0.3175) / (100 + 0.365))
D68 = InverseNormal(0, 1, ((B68 * 100) - 0.3175) / (100 + 0.365))
D69 = InverseNormal(0, 1, ((B69 * 100) - 0.3175) / (100 + 0.365))
D70 = InverseNormal(0, 1, ((B70 * 100) - 0.3175) / (100 + 0.365))
D71 = InverseNormal(0, 1, ((B71 * 100) - 0.3175) / (100 + 0.365))
D72 = InverseNormal(0, 1, ((B72 * 100) - 0.3175) / (100 + 0.365))
D73 = InverseNormal(0, 1, ((B73 * 100) - 0.3175) / (100 + 0.365))
D74 = InverseNormal(0, 1, ((B74 * 100) - 0.3175) / (100 + 0.365))
D75 = InverseNormal(0, 1, ((B75 * 100) - 0.3175) / (100 + 0.365))
D76 = InverseNormal(0, 1, ((B76 * 100) - 0.3175) / (100 + 0.365))
D77 = InverseNormal(0, 1, ((B77 * 100) - 0.3175) / (100 + 0.365))
D78 = InverseNormal(0, 1, ((B78 * 100) - 0.3175) / (100 + 0.365))
D79 = InverseNormal(0, 1, ((B79 * 100) - 0.3175) / (100 + 0.365))
D80 = InverseNormal(0, 1, ((B80 * 100) - 0.3175) / (100 + 0.365))
D81 = InverseNormal(0, 1, ((B81 * 100) - 0.3175) / (100 + 0.365))
D82 = InverseNormal(0, 1, ((B82 * 100) - 0.3175) / (100 + 0.365))
D83 = InverseNormal(0, 1, ((B83 * 100) - 0.3175) / (100 + 0.365))
D84 = InverseNormal(0, 1, ((B84 * 100) - 0.3175) / (100 + 0.365))
D85 = InverseNormal(0, 1, ((B85 * 100) - 0.3175) / (100 + 0.365))
D86 = InverseNormal(0, 1, ((B86 * 100) - 0.3175) / (100 + 0.365))
D87 = InverseNormal(0, 1, ((B87 * 100) - 0.3175) / (100 + 0.365))
D88 = InverseNormal(0, 1, ((B88 * 100) - 0.3175) / (100 + 0.365))
D89 = InverseNormal(0, 1, ((B89 * 100) - 0.3175) / (100 + 0.365))
D90 = InverseNormal(0, 1, ((B90 * 100) - 0.3175) / (100 + 0.365))
D91 = InverseNormal(0, 1, ((B91 * 100) - 0.3175) / (100 + 0.365))
D92 = InverseNormal(0, 1, ((B92 * 100) - 0.3175) / (100 + 0.365))
D93 = InverseNormal(0, 1, ((B93 * 100) - 0.3175) / (100 + 0.365))
D94 = InverseNormal(0, 1, ((B94 * 100) - 0.3175) / (100 + 0.365))
D95 = InverseNormal(0, 1, ((B95 * 100) - 0.3175) / (100 + 0.365))
D96 = InverseNormal(0, 1, ((B96 * 100) - 0.3175) / (100 + 0.365))
D97 = InverseNormal(0, 1, ((B97 * 100) - 0.3175) / (100 + 0.365))
D98 = InverseNormal(0, 1, ((B98 * 100) - 0.3175) / (100 + 0.365))
D99 = InverseNormal(0, 1, ((B99 * 100) - 0.3175) / (100 + 0.365))
D100 = InverseNormal(0, 1, ((B100 * 100) - 0.3175) / (100 + 0.365))
D101 = InverseNormal(0, 1, ((B101 * 100) - 0.3175) / (100 + 0.365))
D102 = InverseNormal(0, 1, ((B102 * 100) - 0.3175) / (100 + 0.365))
D103 = InverseNormal(0, 1, ((B103 * 100) - 0.3175) / (100 + 0.365))
D104 = InverseNormal(0, 1, ((B104 * 100) - 0.3175) / (100 + 0.365))
D105 = InverseNormal(0, 1, ((B105 * 100) - 0.3175) / (100 + 0.365))
D106 = InverseNormal(0, 1, ((B106 * 100) - 0.3175) / (100 + 0.365))
NachgebauterNQ: (A6:A105, D6:D105)
rekonstruiert = FitPoly(NachgebauterNQ, 1)
GeoGebrasNQ = NormalQuantilePlot({A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19, A20, A21, A22, A23, A24, A25, A26, A27, A28, A29, A30, A31, A32, A33, A34, A35, A36, A37, A38, A39, A40, A41, A42, A43, A44, A45, A46, A47, A48, A49, A50, A51, A52, A53, A54, A55, A56, A57, A58, A59, A60, A61, A62, A63, A64, A65, A66, A67, A68, A69, A70, A71, A72, A73, A74, A75, A76, A77, A78, A79, A80, A81, A82, A83, A84, A85, A86, A87, A88, A89, A90, A91, A92, A93, A94, A95, A96, A97, A98, A99, A100, A101, A102, A103, A104, A105, A106})
c = true
info = false