Model wzrostu populacji z wykresem

Symulacje w arkuszu: ciągi, procent składany i modele - Arkusz kalkulacyjny w liceum i technikum (sheet)

Model logistyczny: populacja rośnie tym wolniej, im bliżej jest pojemności środowiska K. Wzór kroku: `N(t+1) = N(t) + r·N(t)·(1 - N(t)/K)`, w arkuszu `=B2+$F$1*B2*(1-B2/$F$2)`. Wykres liniowy pokazuje charakterystyczną krzywą w kształcie litery S.

{"sheets":[{"name":"Arkusz1","cells":{"A1":"Rok","B1":"Populacja","A2":"0","B2":"10","A3":"1","A4":"2","A5":"3","A6":"4","A7":"5","A8":"6","A9":"7","A10":"8","A11":"9","A12":"10","A13":"11","A14":"12","A15":"13","A16":"14","A17":"15","A18":"16","A19":"17","A20":"18","A21":"19","A22":"20","E1":"r","F1":"0,5","E2":"K","F2":"1000","B3":"=ZAOKR(B2+$F$1*B2*(1-B2/$F$2);1)","B4":"=ZAOKR(B3+$F$1*B3*(1-B3/$F$2);1)","B5":"=ZAOKR(B4+$F$1*B4*(1-B4/$F$2);1)","B6":"=ZAOKR(B5+$F$1*B5*(1-B5/$F$2);1)","B7":"=ZAOKR(B6+$F$1*B6*(1-B6/$F$2);1)","B8":"=ZAOKR(B7+$F$1*B7*(1-B7/$F$2);1)","B9":"=ZAOKR(B8+$F$1*B8*(1-B8/$F$2);1)","B10":"=ZAOKR(B9+$F$1*B9*(1-B9/$F$2);1)","B11":"=ZAOKR(B10+$F$1*B10*(1-B10/$F$2);1)","B12":"=ZAOKR(B11+$F$1*B11*(1-B11/$F$2);1)","B13":"=ZAOKR(B12+$F$1*B12*(1-B12/$F$2);1)","B14":"=ZAOKR(B13+$F$1*B13*(1-B13/$F$2);1)","B15":"=ZAOKR(B14+$F$1*B14*(1-B14/$F$2);1)","B16":"=ZAOKR(B15+$F$1*B15*(1-B15/$F$2);1)","B17":"=ZAOKR(B16+$F$1*B16*(1-B16/$F$2);1)","B18":"=ZAOKR(B17+$F$1*B17*(1-B17/$F$2);1)","B19":"=ZAOKR(B18+$F$1*B18*(1-B18/$F$2);1)","B20":"=ZAOKR(B19+$F$1*B19*(1-B19/$F$2);1)","B21":"=ZAOKR(B20+$F$1*B20*(1-B20/$F$2);1)","B22":"=ZAOKR(B21+$F$1*B21*(1-B21/$F$2);1)"},"formats":{"A1":{"bold":true,"fill":"#e0e7ff"},"B1":{"bold":true,"fill":"#e0e7ff"},"E1":{"bold":true},"E2":{"bold":true}},"cols":{"B":100},"charts":[{"type":"line","range":"A1:B22","at":"E5","width":440,"height":260,"title":"Populacja","legend":false}]}]}

Ładowanie interaktywnego edytora... Jeśli się nie pojawi, włącz JavaScript.

Wszystkie lekcje kursu Arkusz kalkulacyjny w liceum i technikum·Zaloguj się, aby zapisać postęp na koncie.