Assignment

profileblacktar555
lab_4.xlsx
Home>Mathematics homework help>Numerical analysis homework help>Assignment

Sheet19

Bins Frequency
0.0439 0
0.0443314 1
0.0447628 1
0.0451942 2
0.0456256 3
0.046057 11
0.0464884 18
0.0469198 14
0.0473512 9
0.0477826 10
0.048214 29
0.0486454 63
0.0490768 20
0.0495082 13
0.0499396 3
More 0

Histogram

Frequency 0.0439 0.0443314 0.0447628 0.0451942 0.0456256 0.046057 0.0464884 0.0469198 0.0473512 0.0477826 0.048214 0.0486454 0.0490768 0.0495082 0.0499396 More 0 1 1 2 3 11 18 14 9 10 29 63 20 13 3 0

Bins

Frequency

Sheet1

xi di Di/Sigma xi adjusted
0.0441 0.0036643216 3.119523735 0.0443 Mean: 0.0477643216 Bins 4.3876314302 0.0917241532
0.0443 0.0034643216 2.9492590001 0.0443 Median: 0.0482 1 0.0439 4.3876314302 0.0917241532
0.0443 0.0034643216 2.9492590001 0.0445 Mode: 0.0485 2 0.0443314 7.1452607562 0.1493728456
0.0445 0.0032643216 2.7789942653 0.045 Standard Deviation 0.0011746414 3 0.0447628 21.3012788355 0.4453067205
0.045 0.0027643216 2.3533324281 0.0451 Dmax/Sigma 2.97335 4 0.0451942 25.9322692736 0.5421183336
0.0451 0.0026643216 2.2682000607 0.0452 5 0.0456256 31.3420796389 0.6552113047
0.0452 0.0025643216 2.1830676933 0.0453 New Mean: 0.04705 6 0.046057 37.6069003328 0.7861784067
0.0453 0.0024643216 2.0979353259 0.0455 New STDEV 0.0011483005 7 0.0464884 52.9790692145 1.1075361132
0.0455 0.0022643216 1.927670591 0.0457 8 0.0469198 72.5021485909 1.515669283
0.0457 0.0020643216 1.7574058562 0.0458 14.0712472795 9 0.0473512 83.8982334835 1.753906303
0.0458 0.0019643216 1.6722734887 0.0458 #bins 15 10 0.0477826 83.8982334835 1.753906303
0.0458 0.0019643216 1.6722734887 0.0458 step size 0.0004314 11 0.048214 83.8982334835 1.753906303
0.0458 0.0019643216 1.6722734887 0.0458 12 0.0486454 83.8982334835 1.753906303
0.0458 0.0019643216 1.6722734887 0.0458 13 0.0490768 83.8982334835 1.753906303
0.0458 0.0019643216 1.6722734887 0.0459 14 0.0495082 96.3844999043 2.0149337462
0.0459 0.0018643216 1.5871411213 0.0459 15 0.0499396 96.3844999043 2.0149337462
0.0459 0.0018643216 1.5871411213 0.046 109.9294416479 2.2980929703
0.046 0.0017643216 1.5020087539 0.046 109.9294416479 2.2980929703
0.046 0.0017643216 1.5020087539 0.046 109.9294416479 2.2980929703
0.046 0.0017643216 1.5020087539 0.0461 124.4724643468 2.6021172401
0.0461 0.0016643216 1.4168763865 0.0462 139.9216751272 2.9250855201
0.0462 0.0015643216 1.3317440191 0.0462 139.9216751272 2.9250855201
0.0462 0.0015643216 1.3317440191 0.0462 139.9216751272 2.9250855201
0.0462 0.0015643216 1.3317440191 0.0462 139.9216751272 2.9250855201
0.0462 0.0015643216 1.3317440191 0.0462 139.9216751272 2.9250855201
0.0462 0.0015643216 1.3317440191 0.0463 156.1525733886 3.2643951049
0.0463 0.0014643216 1.2466116516 0.0463 156.1525733886 3.2643951049
0.0463 0.0014643216 1.2466116516 0.0463 156.1525733886 3.2643951049
0.0463 0.0014643216 1.2466116516 0.0464 173.0078215933 3.6167568274
0.0464 0.0013643216 1.1614792842 0.0464 173.0078215933 3.6167568274
0.0464 0.0013643216 1.1614792842 0.0464 173.0078215933 3.6167568274
0.0464 0.0013643216 1.1614792842 0.0464 173.0078215933 3.6167568274
0.0464 0.0013643216 1.1614792842 0.0464 173.0078215933 3.6167568274
0.0464 0.0013643216 1.1614792842 0.0464 173.0078215933 3.6167568274
0.0464 0.0013643216 1.1614792842 0.0464 173.0078215933 3.6167568274
0.0464 0.0013643216 1.1614792842 0.0464 173.0078215933 3.6167568274
0.0464 0.0013643216 1.1614792842 0.0464 173.0078215933 3.6167568274
0.0464 0.0013643216 1.1614792842 0.0465 190.2982400914 3.9782158561
0.0465 0.0012643216 1.0763469168 0.0465 190.2982400914 3.9782158561
0.0465 0.0012643216 1.0763469168 0.0465 190.2982400914 3.9782158561
0.0465 0.0012643216 1.0763469168 0.0466 207.8051220678 4.3442000892
0.0466 0.0011643216 0.9912145494 0.0466 207.8051220678 4.3442000892
0.0466 0.0011643216 0.9912145494 0.0466 207.8051220678 4.3442000892
0.0466 0.0011643216 0.9912145494 0.0466 207.8051220678 4.3442000892
0.0466 0.0011643216 0.9912145494 0.0466 207.8051220678 4.3442000892
0.0466 0.0011643216 0.9912145494 0.0466 207.8051220678 4.3442000892
0.0466 0.0011643216 0.9912145494 0.0467 225.2839054066 4.7095969157
0.0467 0.0010643216 0.9060821819 0.0468 242.4691703809 5.0688576928
0.0468 0.0009643216 0.8209498145 0.0468 242.4691703809 5.0688576928
0.0468 0.0009643216 0.8209498145 0.0469 259.0808593141 5.4161277689
0.0469 0.0008643216 0.7358174471 0.0469 259.0808593141 5.4161277689
0.0469 0.0008643216 0.7358174471 0.0471 289.4344752251 6.0506750776
0.0471 0.0006643216 0.5655527122 0.0471 289.4344752251 6.0506750776
0.0471 0.0006643216 0.5655527122 0.0471 289.4344752251 6.0506750776
0.0471 0.0006643216 0.5655527122 0.0471 289.4344752251 6.0506750776
0.0471 0.0006643216 0.5655527122 0.0472 302.6121688823 6.3261569203
0.0472 0.0005643216 0.4804203448 0.0472 302.6121688823 6.3261569203
0.0472 0.0005643216 0.4804203448 0.0472 302.6121688823 6.3261569203
0.0472 0.0005643216 0.4804203448 0.0472 302.6121688823 6.3261569203
0.0472 0.0005643216 0.4804203448 0.0473 314.1050789558 6.5664180865
0.0473 0.0004643216 0.3952879774 0.0474 323.680079043 6.7665850305
0.0474 0.0003643216 0.31015561 0.0474 323.680079043 6.7665850305
0.0474 0.0003643216 0.31015561 0.0474 323.680079043 6.7665850305
0.0474 0.0003643216 0.31015561 0.0474 323.680079043 6.7665850305
0.0474 0.0003643216 0.31015561 0.0475 331.138308639 6.9225005409
0.0475 0.0002643216 0.2250232425 0.0475 331.138308639 6.9225005409
0.0475 0.0002643216 0.2250232425 0.0475 331.138308639 6.9225005409
0.0475 0.0002643216 0.2250232425 0.0476 336.3220356359 7.0308672023
0.0476 0.0001643216 0.1398908751 0.0477 339.1202016711 7.0893633212
0.0477 0.0000643216 0.0547585077 0.0477 339.1202016711 7.0893633212
0.0477 0.0000643216 0.0547585077 0.0478 339.4723780931 7.096725627
0.0478 0.0000356784 0.0303738597 0.0478 339.4723780931 7.096725627
0.0478 0.0000356784 0.0303738597 0.0478 339.4723780931 7.096725627
0.0478 0.0000356784 0.0303738597 0.0478 339.4723780931 7.096725627
0.0478 0.0000356784 0.0303738597 0.0478 339.4723780931 7.096725627
0.0478 0.0000356784 0.0303738597 0.0479 337.3709357426 7.0527946307
0.0479 0.0001356784 0.1155062272 0.0479 337.3709357426 7.0527946307
0.0479 0.0001356784 0.1155062272 0.0479 337.3709357426 7.0527946307
0.0479 0.0001356784 0.1155062272 0.048 332.861319739 6.95852037
0.048 0.0002356784 0.2006385946 0.048 332.861319739 6.95852037
0.048 0.0002356784 0.2006385946 0.048 332.861319739 6.95852037
0.048 0.0002356784 0.2006385946 0.048 332.861319739 6.95852037
0.048 0.0002356784 0.2006385946 0.0481 326.0404154491 6.8159282494
0.0481 0.0003356784 0.285770962 0.0481 326.0404154491 6.8159282494
0.0481 0.0003356784 0.285770962 0.0481 326.0404154491 6.8159282494
0.0481 0.0003356784 0.285770962 0.0481 326.0404154491 6.8159282494
0.0481 0.0003356784 0.285770962 0.0481 326.0404154491 6.8159282494
0.0481 0.0003356784 0.285770962 0.0481 326.0404154491 6.8159282494
0.0481 0.0003356784 0.285770962 0.0481 326.0404154491 6.8159282494
0.0481 0.0003356784 0.285770962 0.0482 317.0530876947 6.6280466917
0.0482 0.0004356784 0.3709033294 0.0482 317.0530876947 6.6280466917
0.0482 0.0004356784 0.3709033294 0.0482 317.0530876947 6.6280466917
0.0482 0.0004356784 0.3709033294 0.0482 317.0530876947 6.6280466917
0.0482 0.0004356784 0.3709033294 0.0482 317.0530876947 6.6280466917
0.0482 0.0004356784 0.3709033294 0.0482 317.0530876947 6.6280466917
0.0482 0.0004356784 0.3709033294 0.0482 317.0530876947 6.6280466917
0.0482 0.0004356784 0.3709033294 0.0482 317.0530876947 6.6280466917
0.0482 0.0004356784 0.3709033294 0.0482 317.0530876947 6.6280466917
0.0482 0.0004356784 0.3709033294 0.0482 317.0530876947 6.6280466917
0.0482 0.0004356784 0.3709033294 0.0483 306.0870658529 6.3988002103
0.0483 0.0005356784 0.4560356969 0.0483 306.0870658529 6.3988002103
0.0483 0.0005356784 0.4560356969 0.0483 306.0870658529 6.3988002103
0.0483 0.0005356784 0.4560356969 0.0483 306.0870658529 6.3988002103
0.0483 0.0005356784 0.4560356969 0.0483 306.0870658529 6.3988002103
0.0483 0.0005356784 0.4560356969 0.0483 306.0870658529 6.3988002103
0.0483 0.0005356784 0.4560356969 0.0483 306.0870658529 6.3988002103
0.0483 0.0005356784 0.4560356969 0.0483 306.0870658529 6.3988002103
0.0483 0.0005356784 0.4560356969 0.0483 306.0870658529 6.3988002103
0.0483 0.0005356784 0.4560356969 0.0483 306.0870658529 6.3988002103
0.0483 0.0005356784 0.4560356969 0.0483 306.0870658529 6.3988002103
0.0483 0.0005356784 0.4560356969 0.0483 306.0870658529 6.3988002103
0.0483 0.0005356784 0.4560356969 0.0483 306.0870658529 6.3988002103
0.0483 0.0005356784 0.4560356969 0.0483 306.0870658529 6.3988002103
0.0483 0.0005356784 0.4560356969 0.0483 306.0870658529 6.3988002103
0.0483 0.0005356784 0.4560356969 0.0484 293.3664270467 6.132873174
0.0484 0.0006356784 0.5411680643 0.0484 293.3664270467 6.132873174
0.0484 0.0006356784 0.5411680643 0.0484 293.3664270467 6.132873174
0.0484 0.0006356784 0.5411680643 0.0484 293.3664270467 6.132873174
0.0484 0.0006356784 0.5411680643 0.0484 293.3664270467 6.132873174
0.0484 0.0006356784 0.5411680643 0.0484 293.3664270467 6.132873174
0.0484 0.0006356784 0.5411680643 0.0484 293.3664270467 6.132873174
0.0484 0.0006356784 0.5411680643 0.0484 293.3664270467 6.132873174
0.0484 0.0006356784 0.5411680643 0.0484 293.3664270467 6.132873174
0.0484 0.0006356784 0.5411680643 0.0484 293.3664270467 6.132873174
0.0484 0.0006356784 0.5411680643 0.0484 293.3664270467 6.132873174
0.0484 0.0006356784 0.5411680643 0.0484 293.3664270467 6.132873174
0.0484 0.0006356784 0.5411680643 0.0484 293.3664270467 6.132873174
0.0484 0.0006356784 0.5411680643 0.0484 293.3664270467 6.132873174
0.0484 0.0006356784 0.5411680643 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0485 279.1439932266 5.8355508671
0.0485 0.0007356784 0.6263004317 0.0486 263.6930019219 5.512545365
0.0486 0.0008356784 0.7114327991 0.0486 263.6930019219 5.512545365
0.0486 0.0008356784 0.7114327991 0.0486 263.6930019219 5.512545365
0.0486 0.0008356784 0.7114327991 0.0486 263.6930019219 5.512545365
0.0486 0.0008356784 0.7114327991 0.0486 263.6930019219 5.512545365
0.0486 0.0008356784 0.7114327991 0.0486 263.6930019219 5.512545365
0.0486 0.0008356784 0.7114327991 0.0486 263.6930019219 5.512545365
0.0486 0.0008356784 0.7114327991 0.0486 263.6930019219 5.512545365
0.0486 0.0008356784 0.7114327991 0.0486 263.6930019219 5.512545365
0.0486 0.0008356784 0.7114327991 0.0486 263.6930019219 5.512545365
0.0486 0.0008356784 0.7114327991 0.0486 263.6930019219 5.512545365
0.0486 0.0008356784 0.7114327991 0.0486 263.6930019219 5.512545365
0.0486 0.0008356784 0.7114327991 0.0486 263.6930019219 5.512545365
0.0486 0.0008356784 0.7114327991 0.0486 263.6930019219 5.512545365
0.0486 0.0008356784 0.7114327991 0.0487 247.2984326192 5.1698142103
0.0487 0.0009356784 0.7965651666 0.0487 247.2984326192 5.1698142103
0.0487 0.0009356784 0.7965651666 0.0487 247.2984326192 5.1698142103
0.0487 0.0009356784 0.7965651666 0.0487 247.2984326192 5.1698142103
0.0487 0.0009356784 0.7965651666 0.0487 247.2984326192 5.1698142103
0.0487 0.0009356784 0.7965651666 0.0487 247.2984326192 5.1698142103
0.0487 0.0009356784 0.7965651666 0.0487 247.2984326192 5.1698142103
0.0487 0.0009356784 0.7965651666 0.0487 247.2984326192 5.1698142103
0.0487 0.0009356784 0.7965651666 0.0487 247.2984326192 5.1698142103
0.0487 0.0009356784 0.7965651666 0.0487 247.2984326192 5.1698142103
0.0487 0.0009356784 0.7965651666 0.0488 230.2483705197 4.8133798715
0.0488 0.0010356784 0.881697534 0.0488 230.2483705197 4.8133798715
0.0488 0.0010356784 0.881697534 0.0488 230.2483705197 4.8133798715
0.0488 0.0010356784 0.881697534 0.0488 230.2483705197 4.8133798715
0.0488 0.0010356784 0.881697534 0.0488 230.2483705197 4.8133798715
0.0488 0.0010356784 0.881697534 0.0489 212.825767858 4.4491575112
0.0489 0.0011356784 0.9668299014 0.0489 212.825767858 4.4491575112
0.0489 0.0011356784 0.9668299014 0.0489 212.825767858 4.4491575112
0.0489 0.0011356784 0.9668299014 0.049 195.3009224857 4.0827977503
0.049 0.0012356784 1.0519622688 0.049 195.3009224857 4.0827977503
0.049 0.0012356784 1.0519622688 0.0491 177.9249376796 3.7195499439
0.0491 0.0013356784 1.1370946362 0.0491 177.9249376796 3.7195499439
0.0491 0.0013356784 1.1370946362 0.0491 177.9249376796 3.7195499439
0.0491 0.0013356784 1.1370946362 0.0492 160.9243605856 3.3641500972
0.0492 0.0014356784 1.2222270037 0.0492 160.9243605856 3.3641500972
0.0492 0.0014356784 1.2222270037 0.0493 144.4971242858 3.0207360337
0.0493 0.0015356784 1.3073593711 0.0493 144.4971242858 3.0207360337
0.0493 0.0015356784 1.3073593711 0.0493 144.4971242858 3.0207360337
0.0493 0.0015356784 1.3073593711 0.0493 144.4971242858 3.0207360337
0.0493 0.0015356784 1.3073593711 0.0493 144.4971242858 3.0207360337
0.0493 0.0015356784 1.3073593711 0.0493 144.4971242858 3.0207360337
0.0493 0.0015356784 1.3073593711 0.0493 144.4971242858 3.0207360337
0.0493 0.0015356784 1.3073593711 0.0494 128.8098451038 2.6927908948
0.0494 0.0016356784 1.3924917385 0.0496 100.1581033816 2.0938215445
0.0496 0.0018356784 1.5627564734 0.0497 87.3641532816 1.8263619236
0.0497 0.0019356784 1.6478888408 0.0498 75.6541740671 1.5815628915
0.0498 0.0020356784 1.7330212082

Histogram

Frequency

Bins

Frequency