komputasi numerik (menggunakan excel)

A.    Metode Selisih Maju f'(x) = ((((6*((A4+0,05))^7))+COS(RADIANS(A4+0,05))+5)-(((6*((A4))^7))+COS(RADIANS(A4))+5))/0,05
x	f(x)	f'(x)	eksak	E
1	12,000	48,852	41,983	6,869
1,05	14,442	64,994	56,266	8,728
1,1	17,692	85,356	74,386	10,970
1,15	21,960	110,779	97,128	13,650
1,2	27,499	142,223	125,390	16,832
1,25	34,610	180,777	160,195	20,582
1,3	43,649	227,676	202,703	24,972
1,35	55,033	284,304	254,221	30,082
1,4	69,248	352,213	316,216	35,997
1,45	86,858	433,136	390,327	42,809
1,5	108,515	528,995	478,380	50,615
1,55	134,965	641,917	582,397	59,520
1,6	167,061	774,253	704,615	69,638
1,65	205,774	928,585	847,497	81,087
1,7	252,203	1107,744	1013,748	93,996
1,75	307,590	1314,831	1206,331	108,499
1,8	373,332	1553,223	1428,482	124,741
1,85	450,993	1826,597	1683,726	142,871
1,9	542,322	2138,945	1975,894	163,052
1,95	649,270	2494,593	2309,142	185,451
2	773,999	2898,213	2687,965	210,247

   B.     Metode Selisih Tengah

f’(x)= ((((6*((A4+0,05))^7))+COS(RADIANS(A4+0,05))+5)-(((6*((A4 0,05))^7))+COS(RADIANS(A4-0,05))+5))/(2*0,05)

x	f(x)	f'(x)	eksak	E
1	12,000	42,525	41,983	0,543
1,05	14,442	56,923	56,266	0,657
1,1	17,692	75,175	74,386	0,788
1,15	21,960	98,067	97,128	0,939
1,2	27,499	126,501	125,390	1,110
1,25	34,610	161,500	160,195	1,304
1,3	43,649	204,226	202,703	1,523
1,35	55,033	255,990	254,221	1,768
1,4	69,248	318,258	316,216	2,042
1,45	86,858	392,675	390,327	2,347
1,5	108,515	481,065	478,380	2,685
1,55	134,965	585,456	582,397	3,059
1,6	167,061	708,085	704,615	3,470
1,65	205,774	851,419	847,497	3,922
1,7	252,203	1018,165	1013,748	4,416
1,75	307,590	1211,288	1206,331	4,956
1,8	373,332	1434,027	1428,482	5,545
1,85	450,993	1689,910	1683,726	6,184
1,9	542,322	1982,771	1975,894	6,877
1,95	649,270	2316,769	2309,142	7,627
2	773,999	2696,403	2687,965	8,437

   C.    Metode Selisih Mundur

f'(x) = ((((6*((A4))^7))+COS(RADIANS(A4))+5)-(((6*((A4-0,05))^7))+COS(RADIANS(A4-0,05))+5))/0,05

x	f(x)	f'(x)	eksak	E
1	12,000	36,199	41,983	-5,783
1,05	14,442	48,852	56,266	-7,414
1,1	17,692	64,994	74,386	-9,393
1,15	21,960	85,356	97,128	-11,772
1,2	27,499	110,779	125,390	-14,611
1,25	34,610	142,223	160,195	-17,973
1,3	43,649	180,777	202,703	-21,926
1,35	55,033	227,676	254,221	-26,546
1,4	69,248	284,304	316,216	-31,913
1,45	86,858	352,213	390,327	-38,114
1,5	108,515	433,136	478,380	-45,244
1,55	134,965	528,995	582,397	-53,403
1,6	167,061	641,917	704,615	-62,698
1,65	205,774	774,253	847,497	-73,244
1,7	252,203	928,585	1013,748	-85,164
1,75	307,590	1107,744	1206,331	-98,587
1,8	373,332	1314,831	1428,482	-113,651
1,85	450,993	1553,223	1683,726	-130,503
1,9	542,322	1826,597	1975,894	-149,297
1,95	649,270	2138,945	2309,142	-170,196
2	773,999	2494,593	2687,965	-193,373