Ikä

Lukumäärä

0–14

15–29

30–44

45–59

60–74

75–100

alaraja

kertymä sf

kertymä sf%

B3: 1118550
B4: 1197300
B5: 856763
B6: 764779
B7: 535627
B8: 125317
C3: 0
C4: 15
C5: 30
C6: 45
C7: 60
C8: 75
C9: 100
B9: NaN
D3: 0
D4 = Sum($B$3:B3)
D5 = Sum($B$3:B4)
D6 = Sum($B$3:B5)
D7 = Sum($B$3:B6)
D8 = Sum($B$3:B7)
D9 = Sum($B$3:B8)
E3: D3 / $D$9
E4: D4 / $D$9
D10 = NaN
D11 = NaN
D12 = NaN
D13 = NaN
E5: D5 / $D$9
E6: D6 / $D$9
E7: D7 / $D$9
E8: D8 / $D$9
E9: D9 / $D$9
A: (C3, E3)
B: (C4, E4)
C: (C5, E5)
D: (C6, E6)
E: (C7, E7)
F: (C8, E8)
G: (C9, E9)
f = PolyLine({A, B, C, D, E, F, G})
g: y = 0.5
h: y = 0.3
H = Intersect(h, f)
p: y = 0.7
I = Intersect(p, f)