rizki syahfina tgs-9 pde j 2015 2016
DESCRIPTION
pengolahan data experimentTRANSCRIPT
DATA (1)Concentration(mg/ml) absorbance
0 0.0025 0.131
10 0.25515 0.39220 0.50025 0.62230 0.765
X Y X^2 XY0 0.002 0 05 0.131 25 0.655
10 0.255 100 2.5515 0.392 225 5.8820 0.500 400 1025 0.622 625 15.5530 0.765 900 22.95
105 2.667 2275 57.585
N = 7W = 4900b = 0.025114a = 0.004286
Y = a + bX
X Y0 0.0042865 0.129857
10 0.25542915 0.38120 0.50657125 0.63214330 0.757714
RIZKI SYAHFINA.B4133240028
FISIKA NONDIK 2013
PENGOLAHAN DATA EXPERIMENT
1 2 3 4 5 6 70
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
Y
Y
1 2 3 4 5 6 70
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8Y
Y
metode least square
1 2 3 4 5 6 70
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8Y
Y
1 2 3 4 5 6 70
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
Y
Y
1 2 3 4 5 6 70
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8Y
Y
1 2 3 4 5 6 70
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8Y
Y
DATA (2)V(mV) I (mA)
10 10.49420 6.6730 10.5740 10.1150 10.4460 12.970 10.8780 9.7390 7.03
100 5.61110 3.8120 2.36
V I V^2 VI10 10.494 100 104.9420 6.67 400 133.430 10.57 900 317.140 10.11 1600 404.450 10.44 2500 52260 12.9 3600 77470 10.87 4900 760.980 9.73 6400 778.490 7.03 8100 632.7
100 5.61 10000 561110 3.8 12100 418120 2.36 14400 283.2780 100.584 65000 5690.04
N= 12W= 171600b= -0.059295a= 12.23618
Y= a + bX
X Y
RIZKI SYAHFINA.B4133240028
FISIKA NONDIK 2013PENGOLAHAN DATA EXPERIMENT
1 2 3 4 5 6 7 8 9 10 11 120
2
4
6
8
10
12
14
I
I
metode least square
1 2 3 4 5 6 7 8 9 10 11 120
2
4
6
8
10
12
14
Y
Y
10 11.6432320 11.0502830 10.4573340 9.86437850 9.27142760 8.67847670 8.08552480 7.49257390 6.899622
100 6.306671110 5.71372120 5.120769 1 2 3 4 5 6 7 8 9 10 11 12
0
2
4
6
8
10
12
14
Y
Y
1 2 3 4 5 6 7 8 9 10 11 120
2
4
6
8
10
12
14
I
I
1 2 3 4 5 6 7 8 9 10 11 120
2
4
6
8
10
12
14
Y
Y
1 2 3 4 5 6 7 8 9 10 11 120
2
4
6
8
10
12
14
Y
Y
DATA (1)Concentration(mg/ml) absorbance
0 0.0025 0.131
10 0.25515 0.39220 0.50025 0.62230 0.765
X Y X^2 Y^2 XY0 0.002 0 0.000004 05 0.131 25 0.017161 0.655
10 0.255 100 0.065025 2.5515 0.392 225 0.153664 5.8820 0.500 400 0.25 1025 0.622 625 0.386884 15.5530 0.765 900 0.585225 22.95
105 2.667 2275 1.457963 57.585
N = 7a = 123.06b = 70c = 1.758651
a / bc 0.99963
(dengan Ms. Excel) 0.99963
r xy =
RIZKI SYAHFINA.B4133240028
FISIKA NONDIK 2013
PENGOLAHAN DATA EXPERIMENT
pengujian kolerasi
1 2 3 4 5 6 70
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
0.002
0.131
0.255
0.392
0.500
0.622
0.765
Y
Y
1 2 3 4 5 6 70
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
0.002
0.131
0.255
0.392
0.500
0.622
0.765
Y
Y
DATA (2)V(mV) I (mA)
10 10.49420 6.6730 10.5740 10.1150 10.4460 12.970 10.8780 9.7390 7.03
100 5.61110 3.8120 2.36
V I V^2 I^2 VI10 10.494 100 110.124 104.9420 6.67 400 44.4889 133.430 10.57 900 111.7249 317.140 10.11 1600 102.2121 404.450 10.44 2500 108.9936 52260 12.9 3600 166.41 77470 10.87 4900 118.1569 760.980 9.73 6400 94.6729 778.490 7.03 8100 49.4209 632.7
100 5.61 10000 31.4721 561110 3.8 12100 14.44 418120 2.36 14400 5.5696 283.2780 100.584 65000 957.6859 5690.04
N 12a -10175.04b 414.2463
RIZKI SYAHFINA.B4133240028
FISIKA NONDIK 2013PENGOLAHAN DATA EXPERIMENT
pengujian kolerasi
1 2 3 4 5 6 7 8 9 10 11 120
2
4
6
8
10
12
14
I
I
c 37.08221
a / bc -0.662387
(dengan Ms. Excel) -0.662387
r xy =
1 2 3 4 5 6 7 8 9 10 11 120
2
4
6
8
10
12
14
I
I
DATA (1)Concentration(mg/ml) absorbance
0 0.0025 0.131
10 0.25515 0.39220 0.50025 0.62230 0.765
pada concentration 23 , berapa nilai absorbance?
23
0.500a = 0.6b = 0.122
y0.5732
x =
yk =
yk + ab
RIZKI SYAHFINA.B4133240028
FISIKA NONDIK 2013
PENGOLAHAN DATA EXPERIMENT
INTERPOLASI
1 2 3 4 5 6 70
5
10
15
20
25
30
35
absorbanceConcentration(mg/ml)
1 2 3 4 5 6 70
5
10
15
20
25
30
35
absorbanceConcentration(mg/ml)
I V10.494 10
6.67 2010.57 3010.11 4010.44 50
12.9 6010.87 70
9.73 807.03 905.61 100
3.8 1102.36 120
1 2 3 4 5 6 7 8 9 10 11 120
2
4
6
8
10
12
14
f(x) = − 0.0065982906 x³ − 0.05199267399 x² + 1.0595007215 x + 7.65684848485
Chart Title
Column CPolynomial (Column C)
Axis Title
1 2 3 4 5 6 7 8 9 10 11 120
2
4
6
8
10
12
14
f(x) = − 0.0065982906 x³ − 0.05199267399 x² + 1.0595007215 x + 7.65684848485
Chart Title
Column CPolynomial (Column C)
Axis Title