Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Get this document free

gs

VIEWS: 21 PAGES: 18

									                                                 modelling (2)


Building a simple ecological model.

     time         fox      rabbit        met        filled fox    hungry fox   escape rabbit    diefox     newfox
        0       1000        1000         500              250           750             750         75         25
        1        950         825     391.875       195.9375        754.0625        629.0625    75.406    19.59375
        2   894.1875    691.9688    309.3749   154.6874517       739.500048    537.2812983      73.95    15.46875
        3   835.7062    591.0094    246.9551   123.4775668       712.228674    467.5318614     71.223    12.34776
        4   776.8311     514.285    199.7563   99.87815861       676.952971    414.4068889     67.695    9.987816
        5   719.1236    455.8476    163.9054   81.95269332       637.170955    373.8948845     63.717    8.195269
        6   663.6018    411.2844    136.4645   68.23226483       595.369557    343.0521081     59.537    6.823226
        7   610.8881    377.3573    115.2615   57.63077323        553.25732    319.7265457     55.326    5.763077
        8   561.3254    351.6992    98.70885   49.35442693       511.971011    302.3447733     51.197    4.935443
        9   515.0638    332.5793    85.64976   42.82488149       472.238898    289.7543691     47.224    4.282488
       10   472.1224    318.7298    75.23974   37.61986851        434.50251    281.1099376      43.45    3.761987
       11   432.4341    309.2209    66.85884   33.42941987       399.004694    275.7915114        39.9   3.342942
       12   395.8766    303.3707    60.04867    30.0243356       365.852251     273.346327     36.585    3.002434
       13   362.2938     300.681    54.46742    27.2337115       335.060084    273.4472482     33.506    2.723371
       14   331.5112     300.792    49.85795   24.92897381       306.582184    275.8629992     30.658    2.492897
       15   303.3458    303.4493    46.02504    23.0125204       280.333316    280.4367787     28.033    2.301252
       16   277.6138    308.4805    42.81921   21.40960465       256.204153    287.0708519      25.62     2.14096
       17   254.1343    315.7779      40.125   20.06250145       234.071801    295.7154357     23.407     2.00625
       18   232.7334     325.287    37.85257   18.92628393       213.807089    306.3606953     21.381    1.892628
       19   213.2453    336.9968    35.93149   17.96574338       195.279549    319.0310215     19.528    1.796574
       20   195.5139    350.9341    34.30625    17.1531258       178.360786    333.7809978     17.836    1.715313
       21   179.3931    367.1591    32.93291   16.46645636       162.926689    350.6926412     16.293    1.646646
       22   164.7471    385.7619    31.77658   15.88829094       148.858831    369.8736144     14.886    1.588829
       23   151.4501     406.861    30.80956   15.40478064       136.045288    391.4561952     13.605    1.540478
       24    139.386    430.6018    30.00994   15.00496802       124.381049    415.5968467     12.438    1.500497
       25   128.4484    457.1565    29.36051   14.68025732       113.768152    442.4762741     11.377    1.468026
       26   118.5396    486.7239    28.84803   14.42401657       104.115603    472.2998849     10.412    1.442402
       27   109.5705    519.5299    28.46256   14.23128196       95.3391793    505.2985915     9.5339    1.423128
       28   101.4597    555.8285    28.19709     14.098543       87.3611285    541.7299076     8.7361    1.409854
       29   94.13341    595.9029    28.04719    14.0235934       80.1098195     581.879305      8.011    1.402359
       30   87.52479    640.0672    28.01088   14.00543764       73.5193527    626.0617978     7.3519    1.400544
       31    81.5734     688.668    28.08849    14.0442469       67.5291519    674.6237307     6.7529    1.404425
       32   76.22491    742.0861    28.28272   14.14136131        62.083547    727.9447425     6.2084    1.414136
       33   71.43069    800.7392    28.59868   14.29933864       57.1313511    786.4398781     5.7131    1.429934
       34   67.14749    865.0839     29.0441   14.52205223       52.6254363    850.5618136     5.2625    1.452205
       35   63.33715     935.618    29.62969   14.81484435       48.5223058    920.8031507     4.8522    1.481484
       36    59.9664    1012.883    30.36949   15.18474477       44.7816592     997.698721     4.4782    1.518474
       37   57.00671    1097.469    31.28154   15.64076914       41.3659434    1081.827824     4.1366    1.564077
       38    54.4342    1190.011    32.38863   16.19431738       38.2398777    1173.816289      3.824    1.619432
       39   52.22964    1291.198     33.7194    16.8597003       35.3699388    1274.338218      3.537     1.68597
       40   50.37862    1401.772    35.30967   17.65483355       32.7237817    1384.117206     3.2724    1.765483
       41   48.87172    1522.529     37.2043     18.602152       30.2695684    1503.926774      3.027    1.860215
       42   47.70498    1654.319    39.45964   19.72981858       27.9751602    1634.589633     2.7975    1.972982
       43   46.88044    1798.049    42.14666    21.0733294       25.8071152    1776.975267     2.5807    2.107333
       44   46.40707    1954.673    45.35531   22.67765735       23.7294087    1931.995136     2.3729    2.267766
       45   46.30189    2125.195    49.20027    24.6001327       21.7017582    2100.594517     2.1702    2.460013
       46   46.59173    2310.654    53.82868    26.9143405       19.6773878    2283.739629     1.9677    2.691434
       47   47.31542    2512.114    59.43086   29.71542968       17.5999939    2482.398162        1.76   2.971543
       48   48.52697    2730.638    66.25479   33.12739488       15.3995723    2697.510583        1.54   3.312739


                                                     Page 1
                                         modelling (2)


 49   50.29975   2967.262   74.62626   37.31312927    12.9866202    2929.948512   1.2987    3.731313
 50    52.7324   3222.943   84.97677   42.48838494    10.2440154    3180.454978   1.0244    4.248838
 51   55.95684     3498.5   97.88251   48.94125549    7.01558181    3449.559221   0.7016    4.894126
 52    60.1494   3794.515   114.1189   57.05945671    3.08994796    3737.455686    0.309    5.705946
 53   65.54636   4111.201   134.7371   67.36856479   -1.82220924     4043.83269   -0.182    6.736856
 54   72.46543   4448.216   161.1709   80.58547383   -8.12004088    4367.630485   -0.812    8.058547
 55   81.33598   4804.394    195.385    97.6925194    -16.356535    4706.701014   -1.636    9.769252
 56   92.74089   5177.371    240.077   120.0385011   -27.2976112    5057.332615     -2.73   12.00385
 57   107.4745   5563.066   298.9439   149.4719324   -41.9974313    5413.593944      -4.2   14.94719
 58   126.6214   5954.953   377.0124   188.5061879   -61.8847505     5766.44715   -6.188    18.85062
 59   151.6605   6343.092   480.9983   240.4991706   -88.8386393    6102.592694   -8.884    24.04992
 60   184.5943   6712.852   619.5771   309.7885729   -125.194261    6403.063391   -12.52    30.97886
 61   228.0926    7043.37   803.2702   401.6351209   -173.542525    6641.734609   -17.35    40.16351
 62   285.6104   7305.908   1043.322    521.660759   -236.050399    6784.247311   -23.61    52.16608
 63   361.3815   7462.672   1348.436   674.2178594   -312.836383    6788.454183   -31.28    67.42179
 64   460.0869     7467.3   1717.803   858.9016818   -398.814781    6608.397919   -39.88    85.89017
 65   585.8585   7269.238   2129.373    1064.68626   -478.827714    6204.551451   -47.88    106.4686
 66   740.2099   6825.007   2525.969   1262.984438   -522.774494    5562.022158   -52.28    126.2984
 67   918.7858   6118.224   2810.669   1405.334476   -486.548639    4712.889898   -48.65    140.5334
 68   1107.974   5184.179   2871.968   1435.984047   -328.009899    3748.194841     -32.8   143.5984
 69   1284.374   4123.014   2647.745   1323.872629   -39.4990861    2799.141696     -3.95   132.3873
 70   1420.711   3079.056   2187.224   1093.611915       327.0988    1985.44395    32.71    109.3612
 71   1497.362   2183.988   1635.111   817.5553035    679.806723    1366.433042   67.981    81.75553
 72   1511.137   1503.076   1135.677   567.8385266    943.298358    935.2378194    94.33    56.78385
 73   1473.591   1028.762   757.9869   378.9934338    1094.59747    649.7681676   109.46    37.89934
 74    1402.03    714.745   501.0471   250.5235665    1151.50693    464.2214178   115.15    25.05236
 75   1311.932   510.6436   334.9649   167.4824272    1144.44973    343.1611323   114.44    16.74824
 76   1214.235   377.4772   229.1731   114.5865615    1099.64887    262.8906841   109.96    11.45866
 77   1115.729   289.1798   161.3231   80.66157348    1035.06763     208.518179   103.51    8.066157
 78   1020.289     229.37   117.0118   58.50589796    961.782697     170.864099   96.178     5.85059
 79   929.9609   187.9505   87.39331   43.69665679    886.264258    144.2538521   88.626    4.369666
 80   845.7042   158.6792   67.09785   33.54892256    812.155232    125.1303147   81.216    3.354892
 81   767.8435   137.6433   52.84428   26.42213799    741.421386    111.2212082   74.142    2.642214
 82   696.3436   122.3433    42.5965   21.29824851     675.04535    101.0450805   67.505    2.129825
 83   630.9689   111.1496   35.06597    17.5329831    613.435906    93.61660549   61.344    1.753298
 84   571.3786   102.9783   29.41979   14.70989428    556.668702    88.26837176   55.667    1.470989
 85   517.1827   97.09521   25.10798   12.55399096    504.628725    84.54121798   50.463    1.255399
 86   467.9752   92.99534   21.75976   10.87987917    457.095363    82.11546061    45.71    1.087988
 87   423.3537   90.32701   19.12014   9.560067984    413.793626    80.76693869   41.379    0.956007
 88   382.9303   88.84363   17.01046   8.505230564    374.425108    80.33840199   37.443    0.850523
 89   346.3384   88.37224   15.30335   7.651674146    338.686676    80.72056805   33.869    0.765167
 90   313.2349   88.79262   13.90647   6.953236136    306.281614    81.83938872   30.628    0.695324
 91    283.302   90.02333   12.75189   6.375947467    276.926065    83.64738012   27.693    0.637595
 92    256.247   92.01212   11.78891   5.894457324    250.352543    86.11766081   25.035    0.589446
 93   231.8012   94.72943    10.9792   5.489598519    226.311594    89.23982837   22.631     0.54896
 94    209.719   98.16381   10.29341   5.146703898    204.572289    93.01710731   20.457     0.51467
 95   189.7764   102.3188    9.70885   4.854425107    184.922009    97.46439293   18.492    0.485443
 96   171.7697   107.2108   9.207785   4.603892471    167.165783    102.6069398   16.717    0.460389
 97   155.5135   112.8676    8.77622   4.388109812    151.125377    108.4795239   15.113    0.438811
 98   140.8398   119.3275   8.403027   4.201513279    136.638247     115.125963   13.664    0.420151
 99   127.5961   126.6386   8.079292   4.039646145     123.55644    122.5989132   12.356    0.403965
100   115.6444   134.8588   7.797833   3.898916624    111.745491    130.9598879   11.175    0.389892


                                           Page 2
                                          modelling (2)


101   104.8597   144.0559   7.552832    3.776415795    101.083334   140.2794609   10.108    0.377642
102   95.12906   154.3074   7.339559    3.669779565    91.4592784   150.6376274   9.1459    0.366978
103   86.35011   165.7014   7.154166    3.577083236    82.7730248   162.1243069   8.2773    0.357708
104   78.43051   178.3367   6.993521    3.496760494    74.9337534   174.8399771   7.4934    0.349676
105   71.28681    192.324   6.855082    3.427540885    67.8592737   188.8964339   6.7859    0.342754
106   64.84364   207.7861   6.736803    3.368401468    61.4752399   204.4176759   6.1475     0.33684
107   59.03296   224.8594   6.637059    3.318529491     55.714428   221.5409139   5.5714    0.331853
108   53.79337    243.695   6.554588    3.277293754    50.5160739   240.4177116   5.0516    0.327729
109   49.06949   264.4595   6.488446    3.244222961    45.8252667   261.2152598   4.5825    0.324422
110   44.81139   287.3368    6.43798    3.218989851    41.5923954   284.1177959   4.1592    0.321899
111   40.97404   312.5296      6.4028   3.201400199    37.7726445   309.3281753   3.7773     0.32014
112   37.51692    340.261   6.382772    3.191386135    34.3255341   337.0696067   3.4326    0.319139
113   34.40351   370.7766   6.378007    3.189003416    31.2145021    367.587564   3.1215       0.3189
114   31.60096   404.3463   6.388865     3.19443253    28.4065231   401.1518878   2.8407    0.319443
115   29.07975   441.2671   6.415967    3.207983687    25.8717629   438.0590929   2.5872    0.320798
116   26.81337    481.865   6.460212    3.230105984    23.5832626   478.6348962   2.3583    0.323011
117   24.77805   526.4984   6.522802    3.261401223    21.5166517   523.2369846   2.1517     0.32614
118   22.95253   575.5607   6.605286    3.302643161    19.6498848   572.2580399    1.965    0.330264
119    21.3178   629.4838   6.709607    3.354803263    17.9630005   626.1290407   1.7963     0.33548
120   19.85698   688.7419   6.838169     3.41908445    16.4378996   685.3228603   1.6438    0.341908
121    18.5551   753.8551    6.99393    3.496964881    15.0581376   750.3581814   1.5058    0.349696
122   17.39899    825.394   7.180509    3.590254505    13.8087307    821.803745   1.3809    0.359025
123   16.37714   903.9841   7.402336    3.701168083    12.6759695   900.2829515   1.2676    0.370117
124   15.47966   990.3112   7.664839    3.832419723    11.6472378   986.4788269   1.1647    0.383242
125   14.69818   1085.127   7.974692    3.987345751    10.7108299   1081.139364   1.0711    0.398735
126   14.02583   1189.253   8.340131    4.170065338    9.85576192   1185.083235   0.9856    0.417007
127   13.45726   1303.592   8.771384    4.385691851    9.07156575   1299.205867   0.9072    0.438569
128   12.98867   1429.126   9.281226    4.640613046    8.34805716    1424.48584   0.8348    0.464061
129   12.61793   1566.934   9.885731    4.942865573    7.67506022   1561.991559   0.7675    0.494287
130   12.34471   1718.191   10.60528    5.302639948    7.04206638   1712.888074   0.7042    0.530264
131   12.17076   1884.177   11.46594    5.732967894    6.43779579   1878.443914   0.6438    0.573297
132   12.10028   2066.288   12.50133    6.250667228    5.84961367   2060.037638    0.585    0.625067
133   12.14039   2266.041   13.75531    6.877654472    5.26273178   2259.163748   0.5263    0.687765
134   12.30188    2485.08   15.28558    7.642788446    4.65909008   2477.437334   0.4659    0.764279
135   12.60025   2725.181   17.16898    8.584489568    4.01575879   2716.596578   0.4016    0.858449
136   13.05712   2988.256   19.50901    9.754506138     3.3026153   2978.501729   0.3303    0.975451
137   13.70231   3276.352    22.4468    11.22339778    2.47891274   3265.128504   0.2479     1.12234
138   14.57676   3591.641   26.17725    13.08862263    1.48813639   3578.552732   0.1488    1.308862
139   15.73681   3936.408   30.97325     15.4866239    0.25018375   3920.921382    0.025    1.548662
140   17.26045   4313.014   37.22228    18.61114035   -1.35068868   4294.402379   -0.135    1.861114
141   19.25663   4723.843   45.48266    22.74132776   -3.48469319    4701.10129   -0.348    2.274133
142   21.87924   5171.211   56.57108    28.28553962   -6.40630295   5142.925879   -0.641    2.828554
143   25.34842   5657.218   71.70078    35.85038873   -10.5019678   5621.368078     -1.05   3.585039
144   29.98366   6183.505   92.70204    46.35102173   -16.3673652   6137.153864   -1.637    4.635102
145    36.2555   6750.869   122.3781    61.18902704   -24.9335318   6689.680224   -2.493    6.118903
146   44.86775   7358.648    165.083    82.54149956   -37.6737484   7276.106746   -3.767     8.25415
147   56.88928   8003.717   227.6628    113.8314222   -56.9421463   7889.885999   -5.694    11.38314
148   73.96663   8678.875   320.9736    160.4867826   -86.5201498   8518.387816   -8.652    16.04868
149   98.66733   9370.227   462.2676    231.1338007   -132.466475   9139.092797   -13.25    23.11338
150   135.0274      10053   678.7151    339.3575665   -204.330213    9713.64451   -20.43    33.93576
151   189.3961   10685.01    1011.85    505.9248406   -316.528709   10179.08412   -31.65    50.59248
152   271.6415   11196.99   1520.784    760.3919239   -488.750437   10436.60061   -48.88    76.03919


                                            Page 3
                                         modelling (2)


153   396.5557   11480.26   2276.282   1138.140766    -741.585044    10342.1199    -74.16   113.8141
154   584.5283   11376.33   3324.894   1662.446996    -1077.91869   9713.884898    -107.8   166.2447
155   858.5649   10685.27       4587   2293.500096    -1434.93522   8391.773292    -143.5      229.35
156   1231.408   9230.951   5683.535   2841.767544    -1610.35914   6389.183077      -161   284.1768
157   1676.621   7028.101   5891.731   2945.865721    -1269.24465   4082.235664    -126.9   294.5866
158   2098.132   4490.459   4710.788   2355.394175    -257.262065   2135.065056    -25.73   235.5394
159   2359.398   2348.572   2770.607   1385.303605     974.094129   963.2679569    97.409   138.5304
160   2400.519   1059.595   1271.788   635.8942495     1764.62443   423.7005031    176.46   63.58942
161   2287.646   466.0706   533.1021      266.55107    2021.09459   199.5194834    202.11   26.65511
162   2112.191   219.4714   231.7828   115.8914127      1996.2999    103.580019    199.63   11.58914
163    1924.15    113.938   109.6169   54.80847387     1869.34199   59.12954699    186.93   5.480847
164   1742.697    65.0425   56.67469   28.33734494     1714.35977   36.70515675    171.44   2.833734
165   1574.095   40.37567   31.77757   15.88878469     1558.20608   24.48688773    155.82   1.588878
166   1419.863   26.93558   19.12242   9.561208048     1410.30193   17.37436845    141.03   0.956121
167   1279.789   19.11181   12.22954   6.114769865      1273.6743   12.99703543    127.37   0.611477
168   1153.033   14.29674   8.242307   4.121153365     1148.91196   10.17558561    114.89   0.412115
169   1038.554   11.19314   5.812343   2.906171256     1035.64786   8.286972918    103.56   0.290617
170   935.2799    9.11567   4.262851   2.131425698     933.148438   6.984244511    93.315   0.213143
171   842.1782   7.682669   3.235088   1.617544008     840.560619   6.065124954    84.056   0.161754
172   758.2839   6.671637   2.529497   1.264748742     757.019107   5.406888708    75.702   0.126475
173   682.7084   5.947578   2.030231   1.015115322     681.693304   4.932462257    68.169   0.101512
174   614.6406   5.425708    1.66743    0.83371518     613.806885   4.591993303    61.381   0.083372
175   553.3433   5.051193   1.397522   0.698760879     552.644523   4.352431753    55.264   0.069876
176   498.1487   4.787675   1.192487   0.596243519     497.552464   4.191431409    49.755   0.059624
177   448.4531   4.610575   1.033813   0.516906596     447.936179   4.093667955    44.794   0.051691
178   403.7112   4.503035   0.908963   0.454481344     403.256677   4.048553407    40.326   0.045448
179   363.4309   4.453409   0.809253    0.40462663     363.026312   4.048782117    36.303   0.040463
180   327.1688    4.45366   0.728549   0.364274643     326.804495   4.089385686     32.68   0.036427
181   294.5247   4.498324   0.662434   0.331216954     294.193531      4.1671073   29.419   0.033122
182   265.1385   4.583818   0.607673   0.303836678      264.83468   4.279981352    26.483   0.030384
183   238.6854   4.707979   0.561863    0.28093153     238.404501   4.427047957     23.84   0.028093
184   214.8731   4.869753   0.523189   0.261594688     214.611481   4.608158066    21.461   0.026159
185   193.4381   5.068974   0.490266   0.245133152     193.192954    4.82384072    19.319   0.024513
186   174.1433   5.306225   0.462022    0.23101088     173.912294   5.075213912    17.391   0.023101
187   156.7752   5.582735   0.437617   0.218808578     156.556368   5.363926725    15.656   0.021881
188   141.1414   5.900319    0.41639   0.208194865     140.933226   5.692124533    14.093   0.020819
189   127.0689   6.261337   0.397811   0.198905328     126.870012   6.062431658    12.687   0.019891
190   114.4018   6.668675   0.381454   0.190727112      114.21108   6.477947712    11.421   0.019073
191   102.9998   7.125742   0.366975   0.183487462     102.816284   6.942255021    10.282   0.018349
192   92.73649   7.636481    0.35409   0.177045103     92.5594467    7.45943542    9.2559   0.017705
193   83.49825   8.205379   0.342567   0.171283699      83.326968   8.034095262    8.3327   0.017128
194   75.18268   8.837505   0.332214   0.166106831     75.0165764   8.671397958    7.5017   0.016611
195   67.69764   9.538538   0.322868   0.161434115     67.5362022   9.377103638    6.7536   0.016143
196   60.96016   10.31481   0.314396   0.157198177     60.8029613   10.15761583    6.0803    0.01572
197   54.89558   11.17338   0.306685   0.153342267     54.7422409   11.02003514    5.4742   0.015334
198   49.43669   12.12204   0.299637   0.149818377     49.2868749   11.97222028    4.9287   0.014982
199   44.52299   13.16944   0.293171   0.146585729     44.3764019   13.02285658    4.4376   0.014659
200   40.10001   14.32514   0.287219   0.143609572     39.9563965   14.18153266    3.9956   0.014361




                            15000

                                            Page 4
              modelling (2)


15000

10000
                                       Series1
 5000                                  Series2

    0
        1   29 57 85 113 141 169 197




                Page 5
             modelling (2)




 newrabbit
       75
 62.90625
 53.72813
46.753186
41.440689
37.389488
34.305211
31.972655
30.234477
28.975437
28.110994
27.579151
27.334633
27.344725
  27.5863
28.043678
28.707085
29.571544
 30.63607
31.903102
  33.3781
35.069264
36.987361
 39.14562
41.559685
44.247627
47.229988
50.529859
54.172991
 58.18793
 62.60618
67.462373
72.794474
78.643988
85.056181
92.080315
99.769872
108.18278
117.38163
127.43382
138.41172
150.39268
163.45896
177.69753
193.19951
210.05945
228.37396
248.23982
269.75106


               Page 6
            modelling (2)


292.99485
 318.0455
344.95592
373.74557
404.38327
436.76305
 470.6701
505.73326
541.35939
576.64472
610.25927
640.30634
664.17346
678.42473
678.84542
660.83979
620.45515
556.20222
471.28899
374.81948
279.91417
 198.5444
 136.6433
93.523782
64.976817
46.422142
34.316113
26.289068
20.851818
 17.08641
14.425385
12.513031
11.122121
10.104508
9.3616605
8.8268372
8.4541218
8.2115461
8.0766939
8.0338402
8.0720568
8.1839389
 8.364738
8.6117661
8.9239828
9.3017107
9.7464393
10.260694
10.847952
11.512596
12.259891
13.095989


              Page 7
            modelling (2)


14.027946
15.063763
16.212431
17.483998
18.889643
20.441768
22.154091
24.041771
26.121526
 28.41178
30.932818
33.706961
36.758756
40.115189
43.805909
 47.86349
52.323698
57.225804
62.612904
68.532286
75.035818
82.180375
90.028295
98.647883
108.11394
118.50832
129.92059
142.44858
156.19916
171.28881
187.84439
206.00376
225.91637
247.74373
271.65966
297.85017
326.51285
357.85527
392.09214
429.44024
470.11013
514.29259
562.13681
613.71539
668.96802
727.61067
 788.9886
851.83878
913.90928
971.36445
1017.9084
1043.6601


              Page 8
            modelling (2)


 1034.212
971.38849
839.17733
638.91831
408.22357
213.50651
96.326796
 42.37005
19.951948
10.358002
5.9129547
3.6705157
2.4486888
1.7374368
1.2997035
1.0175586
0.8286973
0.6984245
0.6065125
0.5406889
0.4932462
0.4591993
0.4352432
0.4191431
0.4093668
0.4048553
0.4048782
0.4089386
0.4167107
0.4279981
0.4427048
0.4608158
0.4823841
0.5075214
0.5363927
0.5692125
0.6062432
0.6477948
0.6942255
0.7459435
0.8034095
0.8671398
0.9377104
1.0157616
1.1020035
 1.197222
1.3022857
1.4181533




              Page 9
                                         functions&parameters


Student can just change parameters in the function and see the effect on the graph

        x          y
      -10        -35
       -8        -29
                                               30
       -6        -23
                                               20
       -4        -17                           10
       -2        -11                            0
        0         -5             -20    -10   -10 0       10    20
        2          1                          -20
        4          7                          -30
        6         13                          -40
        8         19
       10         25




                                                Page 10
                                                         graphs


    You can change the values of sales on the table or move the points on the chart and
                               see how the values change

year           sales                                           sales
       1986              10
       1988              17               25
       1990              19               20
       1992              22
                                          15
       1994              18
                                          10
       1996              15
       1998            16.7                5
                                           0
                                           1985   1990        1995     2000



x              y              x+y=4                                y
          -3             7            4                   8

          -2             6            4                   6
          -1             5            4                   4
           0             4            4                   2
           1             3            4
                                                          0
           2             2            4
                                           -4     -2           0        2     4
           3             1            4




                                                         Page 11
                                                trial&check


guess and check a pathway to equation writing

   Entrance fee is $12 per adult and $4 per child. 14 people paid $120 in
       total. How many adults and how many children were there?


adults:            4            cost               48
                                                        total cost          88
children:         10            cost               40


tot peole:        14




                                                 Page 12
                                 busRoutes


example: a bus route database.

place A   place B   bus route
yyy       xxx                1




                                 Page 13
                                              relation


exploring relations

person    foot length height
tom                  10      130
joe                  13      140   145
mary                 12      130   140
                                   135
alice                10      115   130
george               13      125   125
                                   120
nancy                10      110   115
                                   110
                                   105
                                   100
                                         10        12    14




                                              Page 14
                                            modelling


Building a simple ecological model.

     time        fox     rabbit       met   filled fox   hungry fox escape rabbit
        0      1000       1000        500
        1
        2




                                            Page 15
計數/student         hostel next year
hostel this year   A                      B       C       總計
A                                     4       2       1     7
B                                     2       1       2     5
C                                     1       1             2
總計                                    7       4       3    14
                                                      pivot


steps for pivot table: 1.Data|pivot; 2. selectA3..C17; 3. Finish; 4. Drag rows/column/content.

student     hostel this year    hostel next year
student1    A                   A
student2    A                   B
student3    B                   C
student4    B                   C
student5    C                   B
student6    A                   A
student7    A                   A
student8    A                   B
student9    B                   A
student10   C                   A
student11   B                   B
student12   A                   A
student13   A                   C
student14   B                   A




                                                     Page 17
                                                    other ideas


     write a macro to colour the cell where the value is between 0.1 and -0.1


      -5   -4   -3   -2 -1   0    1    2   3    4     5
 5
 4
 3
 2
 1
 0
-1
-2
-3
-4
-5




                                                     Page 18

								
To top