visual basic excel coding (programming)

profiledbsq88
hw3_problem_1.xlsm
Home>Mathematics homework help>Numerical analysis homework help>visual basic excel coding (programming)

Sheet1

t u1 u2 uexact m Heuns h=0.1 h=0.05 h=0.025
0.025 1.9975624619 -0.1950030469 1.9975416615 2 t Uexact Ucalc ΔU Ucalc ΔU Ucalc ΔU error ratioΔU (0.05/0.1) error ratioΔU (0.025/0.05)
0.05 1.9903746211 -0.3800242194 1.9903331694 2 1 0.3011487303 0.2954191763 -0.005729554 0.2999322585 -0.0012164718 0.3008713586 -0.0002773717 0.2123152771 0.2280132628
0.075 1.978685579 -0.5550991453 1.978623766 2 2 -0.3062455368 -0.2978633973 0.0083821396 -0.3041655712 0.0020799656 -0.3057296298 0.000515907 0.2481425637 0.248036326
0.1 1.9627432652 -0.7202859599 1.962661511 2 3 -0.004578988 -0.0037687321 0.000810256 -0.0044549755 0.0001240125 -0.0045578548 0.0000211332 0.1530535011 0.1704119495
0.125 1.9427938899 -0.875664067 1.9426927347 2 4 0.0419867464 0.0396223918 -0.0023643547 0.0414061857 -0.0005805607 0.0418438965 -0.00014285 0.2455472327 0.2460551478
0.15 1.9190814277 -1.0213329085 1.9189615219 2 5 -0.0043402335 -0.0041717978 0.0001684357 -0.0042824702 0.0000577633 -0.0043239096 0.0000163238 0.3429394733 0.2825991483
0.175 1.891847132 -1.1574107451 1.8917092258 2 6 -0.0051695725 -0.0047201584 0.0004494141 -0.005060302 0.0001092705 -0.0051429114 0.0000266611 0.2431399172 0.2439921155
0.2 1.8613290796 -1.2840334508 1.8611740134 2
0.225 1.8277617449 -1.4013533227 1.8275904399 2
0.25 1.7913756045 -1.5095379093 1.7911890531 2
0.275 1.7523967699 -1.6087688589 1.7521960267 2
0.3 1.7110466493 -1.6992407886 1.7108328222 2 Newton h=0.1 h=0.05 h=0.025
0.325 1.6675416372 -1.7811601788 1.667315879 2 t Uexact Ucalc ΔU Ucalc ΔU Ucalc ΔU error ratio(0.05/0.1) error ratio (0.025/0.05)
0.35 1.6220928313 -1.8547442905 1.6218563314 2 1 0.3011487303 0.3031844946 0.0020357643 0.3016524054 0.0005036751 0.301274319 0.0001255887 0.2474132478 0.2493447439
0.375 1.5749057763 -1.9202201108 1.5746597526 2 2 -0.3062455368 -0.3103393002 -0.0040937634 -0.3072670183 -0.0010214814 -0.306500783 -0.0002552462 0.2495213674 0.249878417
0.4 1.5261802334 -1.9778233254 1.5259259248 2 3 -0.004578988 -0.0046833003 -0.0001043123 -0.0046026716 -0.0000236836 -0.0045847609 -0.0000057729 0.2270451097 0.2437516007
0.425 1.4761099753 -2.0277973197 1.4758486347 2 4 0.0419867464 0.0431187048 0.0011319583 0.0422674261 0.0002806796 0.0420567723 0.0000700259 0.2479593258 0.2494868836
0.45 1.4248826062 -2.0703922105 1.4246154932 2 5 -0.0043402335 -0.0044842377 -0.0001440042 -0.004376363 -0.0000361295 -0.0043492732 -0.0000090398 0.2508920218 0.2502041337
0.475 1.3726794047 -2.1058639081 1.3724077792 2 6 -0.0051695725 -0.0053804245 -0.000210852 -0.0052215206 -0.000051948 -0.0051825122 -0.0000129397 0.2463720685 0.2490887086
0.5 1.3196751907 -2.1344732099 1.3194003068 2
0.525 1.266038214 -2.1564849267 1.2657613139 2
0.55 1.2119300644 -2.1721670415 1.2116523731 2
0.575 1.1575056026 -2.1817899012 1.1572283228 2
0.6 1.1029129108 -2.1856254433 1.102637218 2
0.625 1.0482932621 -2.1839464545 1.0480203004 2
0.65 0.9937811081 -2.177025865 0.9935119859 2
0.675 0.9395040838 -2.1651360761 0.9392398704 2
0.7 0.8855830289 -2.1485483218 0.8853247509 2
0.725 0.832132024 -2.1275320648 0.8318806626 2
0.75 0.7792584429 -2.1023544258 0.7790149309 2
0.775 0.727063017 -2.073279647 0.7268282367 2
0.8 0.6756399141 -2.0405685877 0.6754146953 2
0.825 0.6250768285 -2.0044782538 0.6248619468 2
0.85 0.5754550834 -1.9652613591 0.5752512585 2
0.875 0.5268497424 -1.9231659184 0.5266576374 2
0.9 0.4793297325 -1.8784348724 0.479149953 2
0.925 0.4329579748 -1.8313057424 0.4327910681 2
0.95 0.3877915241 -1.7820103159 0.3876379791 2
0.975 0.3438817157 -1.730774361 0.3437419627 2
1 0.301274319 -1.6778173694 0.3011487303 2
1.025 0.2600096978 -1.6233523278 0.2598985874 2
1.05 0.2201229748 -1.5675855154 0.2200265996 2
1.075 0.1816442017 -1.5107163281 0.1815627622 2
1.1 0.1445985335 -1.4529371285 0.1445321745 2
1.125 0.1090064054 -1.3944331192 0.1089552173 2
1.15 0.0748837134 -1.3353822412 0.0748477338 2
1.175 0.0422419967 -1.2759550933 0.0422212115 2
1.2 0.0110886221 -1.216314875 0.0110829674 2
1.225 -0.0185730307 -1.156617349 -0.0185636672 2
1.25 -0.0467433828 -1.097010824 -0.0467191598 2
1.275 -0.0734264701 -1.0376361568 -0.0733875905 2
1.3 -0.0986297567 -0.9786267723 -0.098576466 2
1.325 -0.1223639501 -0.9201087001 -0.1222965341 2
1.35 -0.1446428167 -0.8622006286 -0.1445615994 2
1.375 -0.1654829992 -0.8050139727 -0.1653883403 2
1.4 -0.1849038359 -0.7486529577 -0.184796129 2
1.425 -0.2029271818 -0.693214715 -0.2028068518 2
1.45 -0.2195772331 -0.6387893916 -0.2194447339 2
1.475 -0.2348803539 -0.5854602707 -0.2347361662 2
1.5 -0.2488649061 -0.5333039033 -0.2487095348 2
1.525 -0.261561083 -0.4823902501 -0.2613950552 2
1.55 -0.2730007465 -0.4327828315 -0.2728246089 2
1.575 -0.283217268 -0.3845388878 -0.2830315846 2
1.6 -0.2922453734 -0.3377095449 -0.2920507233 2
1.625 -0.3001209926 -0.2923399883 -0.2999179677 2
1.65 -0.306881113 -0.2484696423 -0.3066703158 2
1.675 -0.3125636379 -0.2061323548 -0.3123456793 2
1.7 -0.3172072497 -0.1653565869 -0.3169827469 2
1.725 -0.3208512771 -0.1261656057 -0.3206208515 2
1.75 -0.3235355682 -0.0885776813 -0.3232998433 2
1.775 -0.3253003678 -0.0526062853 -0.3250599674 2
1.8 -0.3261862 -0.0182602925 -0.3259417463 2
1.825 -0.3262337559 0.0144558172 -0.3259858675 2
1.85 -0.3254837863 0.045541755 -0.3252330766 2
1.875 -0.3239769991 0.0750012199 -0.3237240748 2
1.9 -0.3217539627 0.1028416951 -0.3214994218 2
1.925 -0.3188550134 0.1290742454 -0.3185994441 2
1.95 -0.3153201689 0.1537133155 -0.3150641479 2
1.975 -0.3111890458 0.1767765301 -0.3109331372 2
2 -0.306500783 0.1982844959 -0.3062455368 2
2.025 -0.3012939692 0.2182606059 -0.3010399204 2
2.05 -0.2956065761 0.2367308469 -0.2953542433 2
2.075 -0.2894758954 0.2537236091 -0.2892257802 2
2.1 -0.2829384815 0.2692695002 -0.2826910672 2
2.125 -0.2760300982 0.2834011626 -0.2757858493 2
2.15 -0.26878567 0.2961530946 -0.2685450312 2
2.175 -0.2612392379 0.3075614757 -0.2610026336 2
2.2 -0.2534239195 0.3176639968 -0.2531917532 2
2.225 -0.2453718733 0.3264996941 -0.2451445271 2
2.25 -0.2371142673 0.3341087891 -0.2368921015 2
2.275 -0.2286812508 0.340532532 -0.2284646035 2
2.3 -0.220101931 0.3458130515 -0.219891118 2
2.325 -0.2114043527 0.3499932091 -0.2111996672 2
2.35 -0.2026154819 0.3531164591 -0.2024171942 2
2.375 -0.1937611922 0.3552267135 -0.1935695502 2
2.4 -0.1848662556 0.3563682128 -0.1846814843 2
2.425 -0.1759543354 0.356585402 -0.1757766372 2
2.45 -0.1670479828 0.3559228125 -0.1668775375 2
2.475 -0.1581686357 0.3544249494 -0.1580056011 2
2.5 -0.1493366216 0.3521361839 -0.1491811332 2
2.525 -0.1405711611 0.3491006522 -0.140423333 2
2.55 -0.131890376 0.3453621587 -0.1317503007 2
2.575 -0.1233112979 0.3409640863 -0.1231790472 2
2.6 -0.1148498805 0.3359493103 -0.1147255056 2
2.625 -0.1065210126 0.3303601192 -0.1064045449 2
2.65 -0.0983385344 0.3242381401 -0.0982299858 2
2.675 -0.0903152542 0.3176242693 -0.0902146179 2
2.7 -0.0824629683 0.3105586085 -0.0823702189 2
2.725 -0.0747924806 0.3030804056 -0.0747075755 2
2.75 -0.0673136255 0.2952280007 -0.0672365051 2
2.775 -0.0600352908 0.2870387771 -0.059965879 2
2.8 -0.0529654421 0.2785491164 -0.0529036475 2
2.825 -0.0461111487 0.269794359 -0.0460568648 2
2.85 -0.0394786096 0.2608087688 -0.0394317161 2
2.875 -0.0330731812 0.2516255015 -0.0330335444 2
2.9 -0.0268994052 0.2422765789 -0.0268668788 2
2.925 -0.0209610372 0.2327928649 -0.0209354629 2
2.95 -0.0152610757 0.2232040477 -0.0152422845 2
2.975 -0.0098017923 0.2135386243 -0.0097896047 2
3 -0.0045847609 0.2038238891 -0.004578988 2
3.025 0.0003891118 0.1940859262 0.0003886676 2
3.05 0.0051195559 0.1843496046 0.0051131002 2
3.075 0.0096069082 0.1746385768 0.0095946537 2
3.1 0.0138520814 0.1649752809 0.0138342473 2
3.125 0.0178565342 0.1553809445 0.0178333452 2
3.15 0.0216222409 0.1458755923 0.0215939268 2
3.175 0.0251516615 0.136478056 0.0251184562 2
3.2 0.028447712 0.1272059863 0.028409853 2
3.225 0.0315137352 0.1180758675 0.0314714626 2
3.25 0.0343534715 0.1091030347 0.0343070277 2
3.275 0.0369710306 0.1003016914 0.0369206594 2
3.3 0.0393708634 0.0916849311 0.0393168095 2
3.325 0.0415577345 0.083264759 0.0415002427 2
3.35 0.0435366954 0.0750521156 0.0434760102 2
3.375 0.0453130581 0.0670569025 0.0452494229 2
3.4 0.0468923695 0.0592880083 0.0468260263 2
3.425 0.0482803863 0.0517533369 0.048211575 2
3.45 0.049483051 0.0444598357 0.0494120088 2
3.475 0.050506468 0.0374135258 0.0504334293 2
3.5 0.0513568812 0.0306195318 0.0512820768 2
3.525 0.0520406518 0.024082114 0.0519643084 2
3.55 0.052564237 0.0178046993 0.0524865772 2
3.575 0.0529341696 0.0117899136 0.0528554113 2
3.6 0.0531570387 0.006039615 0.0530773945 2
3.625 0.0532394705 0.000554926 0.0531591477 2
3.65 0.0531881104 -0.0046637329 0.0531073106 2
3.675 0.0530096061 -0.0096166101 0.0529285249 2
3.7 0.0527105911 -0.01430459 0.0526294179 2
3.725 0.0522976693 -0.0187291593 0.0522165868 2
3.75 0.0517774001 -0.0228923744 0.0516965847 2
3.775 0.0511562851 -0.0267968286 0.051075906 2
3.8 0.0504407545 -0.0304456194 0.050360974 2
3.825 0.0496371553 -0.0338423165 0.0495581286 2
3.85 0.0487517397 -0.03699093 0.0486736146 2
3.875 0.0477906546 -0.0398958795 0.0477135717 2
3.9 0.0467599315 -0.0425619628 0.0466840239 2
3.925 0.0456654779 -0.044994326 0.0455908711 2
3.95 0.0445130684 -0.0471984343 0.0444398805 2
3.975 0.0433083375 -0.0491800427 0.043236679 2
4 0.0420567723 -0.0509451679 0.0419867464 2
4.025 0.040763707 -0.0525000612 0.0406954092 2
4.05 0.0394343164 -0.0538511813 0.039367835 2
4.075 0.0380736121 -0.0550051689 0.0380090278 2
4.1 0.0366864372 -0.0559688216 0.0366238236 2
4.125 0.0352774635 -0.0567490694 0.0352168869 2
4.15 0.0338511883 -0.0573529515 0.0337927079 2
4.175 0.0324119315 -0.0577875938 0.0323555995 2
4.2 0.0309638342 -0.0580601876 0.0309096961 2
4.225 0.0295108572 -0.0581779682 0.0294589518 2
4.25 0.0280567802 -0.058148196 0.0280071396 2
4.275 0.026605201 -0.0579781367 0.0265578511 2
4.3 0.0251595363 -0.0576750441 0.0251144967 2
4.325 0.0237230214 -0.0572461423 0.0236803058 2
4.35 0.022298712 -0.0566986102 0.0222583281 2
4.375 0.0208894848 -0.0560395656 0.0208514349 2
4.4 0.0194980396 -0.0552760514 0.0194623204 2
4.425 0.0181269012 -0.0544150216 0.0180935043 2
4.45 0.0167784218 -0.053463329 0.0167473338 2
4.475 0.0154547838 -0.0524277132 0.0154259864 2
4.5 0.0141580025 -0.05131479 0.0141314731 2
4.525 0.0128899296 -0.0501310408 0.012865641 2
4.55 0.0116522566 -0.048882804 0.0116301777 2
4.575 0.0104465182 -0.047576266 0.010426614 2
4.6 0.0092740967 -0.0462174537 0.0092563284 2
4.625 0.0081362257 -0.0448122278 0.0081205513 2
4.65 0.0070339944 -0.0433662762 0.0070203686 2
4.675 0.0059683521 -0.0418851089 0.0059567266 2
4.7 0.0049401125 -0.0403740531 0.0049304364 2
4.725 0.0039499588 -0.0388382491 0.0039421785 2
4.75 0.0029984476 -0.037282647 0.0029925074 2
4.775 0.0020860144 -0.0357120038 0.0020818565 2
4.8 0.0012129784 -0.0341308814 0.001210543 2
4.825 0.0003795468 -0.0325436445 0.0003787725 2
4.85 -0.0004141795 -0.0309544602 -0.0004133554 1
4.875 -0.0011682015 -0.0293672972 -0.001165843 1
4.9 -0.0018826168 -0.0277859257 -0.0018787891 1
4.925 -0.0025576148 -0.0262139181 -0.0025523838 1
4.95 -0.0031934719 -0.0246546495 -0.0031869042 1
4.975 -0.0037905463 -0.0231112999 -0.0037827088 1
5 -0.0043492732 -0.021586855 -0.0043402335 1
5.025 -0.0048701603 -0.0200841093 -0.0048599857 1
5.05 -0.0053537825 -0.0186056677 -0.0053425406 1
5.075 -0.0058007777 -0.0171539493 -0.0057885358 1
5.1 -0.0062118419 -0.0157311898 -0.006198667 1
5.125 -0.0065877249 -0.0143394456 -0.0065736834 1
5.15 -0.0069292254 -0.012980597 -0.0069143832 1
5.175 -0.0072371873 -0.0116563526 -0.0072216095 1
5.2 -0.0075124949 -0.0103682534 -0.0074962457 1
5.225 -0.007756069 -0.0091176769 -0.0077392118 1
5.25 -0.007968863 -0.0079058423 -0.0079514599 1
5.275 -0.0081518587 -0.0067338148 -0.0081339707 1
5.3 -0.0083060628 -0.0056025106 -0.0082877496 1
5.325 -0.0084325029 -0.004512702 -0.0084138229 1
5.35 -0.0085322245 -0.0034650225 -0.0085132345 1
5.375 -0.0086062869 -0.0024599721 -0.0085870422 1
5.4 -0.0086557606 -0.0014979224 -0.0086363149 1
5.425 -0.0086817236 -0.000579122 -0.0086621291 1
5.45 -0.008685259 0.0002962977 -0.0086655658 1
5.475 -0.0086674513 0.0011283178 -0.0086477081 1
5.5 -0.0086293845 0.001917026 -0.008609638 1
5.525 -0.008572139 0.0026626113 -0.0085524341 1
5.55 -0.0084967894 0.0033653584 -0.0084771691 1
5.575 -0.0084044019 0.004025643 -0.0083849073 1
5.6 -0.0082960323 0.0046439255 -0.0082767026 1
5.625 -0.0081727239 0.0052207465 -0.0081535963 1
5.65 -0.0080355055 0.0057567212 -0.0080166154 1
5.675 -0.0078853898 0.0062525346 -0.0078667704 1
5.7 -0.0077233714 0.0067089359 -0.0077050541 1
5.725 -0.0075504256 0.007126734 -0.0075324397 1
5.75 -0.0073675065 0.0075067924 -0.0073498795 1
5.775 -0.0071755463 0.0078500247 -0.0071583038 1
5.8 -0.0069754536 0.0081573893 -0.0069586192 1
5.825 -0.0067681126 0.0084298857 -0.0067517081 1
5.85 -0.0065543822 0.0086685496 -0.0065384274 1
5.875 -0.0063350947 0.0088744485 -0.0063196076 1
5.9 -0.0061110556 0.0090486778 -0.0060960525 1
5.925 -0.0058830427 0.0091923569 -0.0058685381 1
5.95 -0.0056518054 0.0093066248 -0.005637812 1
5.975 -0.0054180647 0.0093926367 -0.0054045934 1
6 -0.0051825122 0.0094515606 -0.0051695725 1