Course Work

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 20

4 2

-14 8
2 -2
1 15
Err:502 Err:502
Err:502 Err:502 Err:502 Err:502
Err:502 Err:502 Err:502 Err:502
Err:502 Err:502 Err:502 Err:502
Err:502 Err:502
Err:502

Err:502 Err:502
Err:502 Err:502
Err:502 Err:502
Err:502 Err:502
-2 1 3 -1.923077
-4 0 5 1.769231
3 5 2 -1.538462

-1.923077 1 0.384615
1.769231 -1 -0.153846
-1.538462 1 0.307692
1 0.384615
-1 -0.153846
1 0.307692

D 13
matrix method
5 1 8X 46
4 -2 0Y 12
6 7 4Z 50

-0.030303 0.19697 0.060606


-0.060606 -0.106061 0.121212
0.151515 -0.109848 -0.05303

x 4
y 2
z 3
3 1 -1 181.08
1 2 -1 108.35
1 1 5 142.55

equation n x1 x2 x3
x1=(181.08-x2+x3)/3 1 0 0 0
x2=(108.35-x1+x3)/2 60.36 54.175 28.51
x3=(142.55-x1-x2)/5 51.805 38.25 5.603
49.47767 31.074 10.499
53.50167 34.68567 12.39967
52.93133 33.624 10.87253
52.77618 33.1456 11.19893
53.04444 33.38638 11.32564
53.00642 33.3156 11.22384
52.99608 33.28371 11.2456
53.01396 33.29976 11.25404
53.01143 33.29504 11.24726
53.01074 33.29291 11.24871
53.01193 33.29398 11.24927
53.01176 33.29367 11.24882
53.01172 33.29353 11.24891
53.0118 33.2936 11.24895
53.01178 33.29358 11.24892
53.01178 33.29357 11.24893
53.01179 33.29357 11.24893
53.01179 33.29357 11.24893
h 0.05

n x y k1 k2 k3 k4 yn+1
0 0 1 0.05 0.0525 0.052563 0.055128 1.052542
1 0.05 1.052542 0.055517 0.055265 0.055259 0.05789 1.108285
2 0.1 1.108285 0.061915 0.058212 0.05812 0.06082 1.167518
3 0.15 1.167518 0.06928 0.061358 0.06116 0.063934 1.230559
4 0.2 1.230559 0.077714 0.064721 0.064396 0.067248 1.297758
5 0.25 1.297758 0.087334 0.068321 0.067846 0.07078 1.3695
6 0.3 1.3695 0.098276 0.072182 0.07153 0.074551 1.446208
7 0.35 1.446208 0.110701 0.076328 0.075469 0.078584 1.528355
8 0.4 1.528355 0.124793 0.080788 0.079687 0.082902 1.616462
9 0.45 1.616462 0.140773 0.085592 0.084213 0.087534 1.711115
10 0.5 1.711115 0.158896 0.090778 0.089075 0.09251 1.812967
11 0.55 1.812967 0.179467 0.096385 0.094308 0.097864 1.922753
12 0.6 1.922753 0.202849 0.102459 0.099949 0.103635 2.041303
13 0.65 2.041303 0.229471 0.109052 0.106041 0.109867 2.169557
14 0.7 2.169557 0.259849 0.116224 0.112633 0.11661 2.308586
15 0.75 2.308586 0.294604 0.124044 0.11978 0.123918 2.459615
16 0.8 2.459615 0.334485 0.132593 0.127546 0.131858 2.624052
17 0.85 2.624052 0.380407 0.141963 0.136002 0.140503 2.803525
18 0.9 2.803525 0.433488 0.152263 0.145233 0.149938 2.999928
19 0.95 2.999928 0.495103 0.163624 0.155337 0.160263 3.215476
20 1 3.215476 0.566964 0.176198 0.166429 0.171595 3.452778
3 1 -1 181.08 n x1 x2
1 2 -1 108.35 0 0
1 1 5 142.55 69.86333 50.59833
44.96644 51.00061
46.46533 52.70063
equation 45.68539 52.77071
x1=(181.08-x2+x3)/3 45.70936 52.82971
x2=(108.35-x1+x3)/2 45.68416 52.83401
x3=(142.55-x1-x2)/5 45.68412 52.83612
45.68328 52.83634
45.68325 52.83642
45.68322 52.83643
45.68322 52.83643
45.68321 52.83643
45.68321 52.83643
45.68321 52.83643
45.68321 52.83643
45.68321 52.83643
x3
28.51
4.417667
9.316589
8.676809
8.81878
8.802186
8.806366
8.805952
8.806077
8.806068
8.806071
8.806071
8.806071
8.806071
8.806071
8.806071
8.806071
2 9 4
7 5 3
6 1 8

determinant
-360

-0.102778 0.188889 -0.019444


0.105556 0.022222 -0.061111
0.063889 -0.144444 0.147222
f(x)=2x^3-20x^2+11x+30 f'(x)=(f(x+h)-f(x))/dh
dh 1E-05
2.5
x f(x) x+h f(x+h) f'(x)
-5 -775 -4.99999 -774.9964 360.999499980608
-2.5 -153.75 -2.49999 -153.7485 148.499650001099
0 30 1E-05 30.00011 10.9998000002776 Char
2.5 -36.25 2.50001 -36.25052 -51.5000500001861 400
5 -165 5.00001 -165 -38.9998999992258 350
f(x) = 3.0948356957E-11 x³ + 5.999999999
7.5 -168.75 7.50001 -168.7495 48.5002499942766 300
10 140 10.00001 140.0021 211.00039999169 250
200
150
100
50
0
-6 -4 -2 0 2
-50
-100

360.999499980
Polynomial (Co
Chart Title
400
350
.0948356957E-11 x³ + 5.9999999994995 x² − 39.999939999145 x + 10.999800002722
300
250
200
150
100
50
0
-4 -2 0 2 4 6 8 10 12
-50
-100

360.999499980608 Column F
Polynomial (Column F)
y=(1-sin^2x/2)^0.5
dx 1
h 0.001
x f(x) x+h f(x+h) f'(x)
1 0.803718 1.001 0.803436 -0.282761
2 0.765891 2.001 0.766138 0.247207 Chart Title
3 0.995009 3.001 0.995079 0.069961 0.3
4 0.844763 4.001 0.84447 -0.292799
0.2
5 0.735005 5.001 0.73519 0.185302
6 0.980287 6.001 0.980424 0.136616 0.1
7 0.885542 7.001 0.885262 -0.279744
8 0.714552 8.001 0.714653 0.101056 0
0 2 4 6
9 0.956598 9.001 0.956794 0.196072
-0.1
10 0.92305 10.001 0.922802 -0.247407
-0.2

-0.3

-0.4
Chart Title

4 6 8 10 12
dx 1
x f(x) multiplier product of the sum
0 #DIV/0! #NAME? #NAME?
1 0.581977 2 1.163953
2 1.252141 2 2.504282
3 1.414684 2 2.829368
4 1.194071 2 2.388142
5 0.847957 2 1.695914
Chart Title
6 0.536741 2 1.073482
3
7 0.313061 2 0.626122
8 0.171815 2 0.343629 2.5
9 0.089977 2 0.179954
10 0.045402 2 0.090804 2

11 0.02223 2 0.044461 1.5


12 0.010617 2 0.021235
13 0.004966 2 0.009932 1
14 0.002282 2 0.004563
0.5
15 0.001032 1 0.001032
0
0 2 4 6 8 10
area 6.488436
#NAME? Colum
Chart Title

4 6 8 10 12 14 16

#NAME? Column E
h 0.1
X f(x) I
0 0
0.1 0.01 0.00025
0.2 0.04 0.00065
0.3 0.09 0.00125
0.4 0.16 0.00205
0.5 0.25 0.00305
0.6 0.36 0.00425
0.7 0.49 0.00565
0.8 0.64 0.00725
0.9 0.81 0.00905
1 1 #VALUE!

h 0.1
x f(x) I
0 0 0
0.1 0.01 5E-05
0.2 0.04 0.0004
0.3 0.09 0.00135
0.4 0.16 0.0032
0.5 0.25 0.00625
0.6 0.36 0.0108
0.7 0.49 0.01715
0.8 0.64 0.0256
0.9 0.81 0.03645
1 1 0.05
A 1200
Q 500
a 300
h 0.5

t y dy/dt new y t y dy/dt


0 0 -0.25 -0.125 0 0 -0.25
0.5 -0.125 0.082689 -0.083655 0.5 -0.125 0.082689
1 -0.083655 0.665797 0.249243 1 -0.083655 0.665797
1.5 0.249243 0.894677 0.696582 1.5 0.249243 0.894677
2 0.696582 0.481066 0.937114 2 0.696582 0.481066
2.5 0.937114 -0.226309 0.82396 2.5 0.937114 -0.226309
3 0.82396 -0.590939 0.52849 3 0.82396 -0.590939
3.5 0.52849 -0.318615 0.369183 3.5 0.52849 -0.318615
4 0.369183 0.31541 0.526888 4 0.369183 0.31541
4.5 0.526888 0.722773 0.888274 4.5 0.526888 0.722773
5 0.888274 0.500729 1.138639 5 0.888274 0.500729
5.5 1.138639 -0.159657 1.05881 5.5 1.138639 -0.159657
6 1.05881 -0.640933 0.738344 6 1.05881 -0.640933
6.5 0.738344 -0.51514 0.480774 6.5 0.738344 -0.51514
7 0.480774 0.089062 0.525305 7 0.480774 0.089062
7.5 0.525305 0.628855 0.839732 7.5 0.525305 0.628855
8 0.839732 0.599699 1.139582 8 0.839732 0.599699
8.5 1.139582 0.014569 1.146866 8.5 1.139582 0.014569
9 1.146866 -0.574105 0.859814 9 1.146866 -0.574105
9.5 0.859814 -0.627021 0.546303 9.5 0.859814 -0.627021
10 0.546303 -0.11076 0.490923 10 0.546303 -0.11076
new y
-0.125
-0.083655
0.249243
0.696582
0.937114
0.82396
0.52849
0.369183
0.526888
0.888274
1.138639
1.05881
0.738344
0.480774
0.525305
0.839732
1.139582
1.146866
0.859814
0.546303
0.490923
y= x^3/exp(x)-1
x
n x f(x) muitipler product
0 #DIV/0! 1 #DIV/0!
1 0.581977 2 1.163953
2 1.252141 2 2.504282
Chart Title
3 1.414684 2 2.829368
4 1.194071 2 2.388142 3

5 0.847957 2 1.695914
2.5
6 0.536741 2 1.073482
7 0.313061 2 0.626122 2
8 0.171815 2 0.343629
9 0.089977 2 0.179954 1.5
10 0.045402 2 0.090804
11 0.02223 2 0.044461 1
12 0.010617 2 0.021235
0.5
13 0.004966 2 0.009932
14 0.002282 2 0.004563
0
15 0.001032 1 0.001032 0 2 4 6 8 10 12
12.97687
area 6.488436
Chart Title

6 8 10 12 14 16

You might also like