Curva Característica

Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Está en la página 1de 34

H

44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

Distancia
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.8
2

log(x)
1.650890078
1.699837726
1.723455672
1.734399743
1.742410881
1.748032894
1.749349761
1.751817788
1.754424789
1.757775491

log(y)
-0.69897
-0.39794001
-0.22184875
-0.09691001
0
0.07918125
0.14612804
0.20411998
0.25527251
0.30103

0.4
0.2
0
1.64
-0.2
-0.4
-0.6
-0.8
-1

1.66

1.68

log(y) vs log(x)

1.68

1.7

1.72

1.74

1.76

1.78
Series1
Linear (Series1)
y = 9.2974x - 16.139
R = 0.9394

H
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25
Clculo de
Puntos

Distancia
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.8
2
x1, y1
x2,y2
x3,y3

log(x)
1.65089008
1.69983773
1.72345567
1.73439974
1.74241088
1.74803289
1.74934976
1.75181779
1.75442479
1.75777549
x
44.76
56.15
50.1325643
0.15

log(y-)
-1.30103
-0.60205999
-0.34678749
-0.18708664
-0.07058107
0.0211893
0.09691001
0.161368
0.21748394
0.26717173
y
0.2
1.4
0.4

0.4
0.2
0
-0.2
-0.4
-0.6
-0.8
-1
-1.2
-1.4
-1.6

1.64

1.66

1.68

log(y-) vs log(x)

1.68

1.7

1.72

1.74

1.76

1.78

Series1
Linear (Series1)
y = 14.358x - 25.031
R = 0.9891

H
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

Distancia
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.8
2

x
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

log(y)
-0.69897
-0.39794001
-0.22184875
-0.09691001
0
0.07918125
0.14612804
0.20411998
0.25527251
0.30103

0.4
0.2
0
0
-0.2
-0.4
-0.6
-0.8
-1

10

20

log(y) vs x

20

30

40

50

60

70
Series1
Linear (Series1)
y = 0.0798x - 4.3522
R = 0.9536

H
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25
Clculo de
Puntos

Distancia
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.8
2
x1, y1
x2,y2
x3,y3

x
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25
x
44.76
55.26
50.01
0.1

log(y-)
-1
-0.52287875
-0.30103
-0.15490196
-0.04575749
0.04139269
0.11394335
0.17609126
0.23044892
0.2787536
y
0.2
1
0.4

0.4
0.2
0
0
-0.2
-0.4
-0.6
-0.8
-1
-1.2

10

20

log(y-) vs x

20

30

40

50

60

70
log(x-d) vs x
Linear (log(x-d) vs x)
y = 0.1012x - 5.5834
R = 0.9807

H
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

Distancia
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.8
2

x
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

y-y1/x-x1
#DIV/0!
0.03745318
0.04914005
0.06322445
0.07619048
0.08912656
0.10535558
0.11955594
0.13278008
0.14411529

0.16
0.14
0.12
0.1
0.08
0.06
0.04
0.02
0
49

50

51

y-y1/x-x1 vs x

y-y1/x-x1 vs x
Linear (y-y1/x-x1 vs x)
y = 0.0148x - 0.7235
R = 0.818

52

53

54

55

56

57

58

H
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

Distancia
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.8
2

1/x
0.02234138
0.01996008
0.01890359
0.01843318
0.01809627
0.01786352
0.01780944
0.01770852
0.01760253
0.01746725

1/y
5
2.5
1.66666667
1.25
1
0.83333333
0.71428571
0.625
0.55555556
0.5

0
0

0.005

1/y vs 1/x

1/y vs 1/x
Linear (1/y vs 1/x)
y = 917.61055430860400x - 15.62011797398780
R = 0.99589099362473

0.01

0.015

0.02

0.025

H
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

Distancia
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.8
2

x
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

x-x1/y-y1
#DIV/0!
26.7
20.35
15.8166667
13.125
11.22
9.49166667
8.36428571
7.53125
6.93888889

30

25

20

15

10

0
49

50

51

x-x1/y-y1 vs x

x-x1/y-y1 vs x
Linear (x-x1/y-y1 vs x)
y = -2.8885x + 172.2
R = 0.9899

52

53

54

55

56

57

58

H
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

Distancia
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.8
2

x
6.690291473
7.078135348
7.273238618
7.365459931
7.433707016
7.481978348
7.493330368
7.514652354
7.537240874
7.566372975

y
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.8
2

2.5

1.5

0.5

0
5
-0.5

10

y vs raiz de x

y = 1.9046x - 12.886
R = 0.7351

y vs raiz de x
Linear (y vs raiz de x)

10

15

20

25

H
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

Distancia
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.8
2

x
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

log(y/x)
-2.34986008
-2.09777773
-1.94530442
-1.83130976
-1.74241088
-1.66885165
-1.60322172
-1.54769781
-1.49915228
-1.4567455

0
0
-0.5

-1

-1.5

-2

-2.5

-3

10

20

log(y/x) vs x
20

30

40

50

60

70
y = 0.0713x - 5.6237
R = 0.9409

log(y/x) vs x
Linear (log(y/x) vs x)

H
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

Distancia
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.8
2

1/x2
0.00049914
0.0003984
0.00035735
0.00033978
0.00032748
0.00031911
0.00031718
0.00031359
0.00030985
0.0003051

1/y
5
2.5
1.66666667
1.25
1
0.83333333
0.71428571
0.625
0.55555556
0.5

0
0

0.0001

0.0002

1/y vs 1/x2
y = 23,154.89561730340000x - 6.60956317841478
R = 0.99867122396622

1/y vs 1/x2
Linear (1/y vs 1/x2)

0.0002

0.0003

0.0004

0.0005

0.0006

H
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

Distancia
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.8
2

x
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

y2
0.04
0.16
0.36
0.64
1
1.44
1.96
2.56
3.24
4

5
4
3
2
1
0
0
-1
-2

10

20

y2 vs x
y = 0.2609x - 12.549
R = 0.5529

y2 vs x
Linear (y2 vs x)

20

30

40

50

60

70

H
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

Distancia
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.8
2

x2
2003.4576
2510.01
2798.41
2943.0625
3053.6676
3133.7604
3152.8225
3188.8609
3227.3761
3277.5625

xy
8.952
20.04
31.74
43.4
55.26
67.176
78.61
90.352
102.258
114.5

140
120
100
80
60
40
20
0
0
-20

500

1000

xy vs x2

xy vs x2
Linear (xy vs x2)

1000

1500

2000

2500

3000

3500

y = 0.07804x - 167.32904
R = 0.76930

H
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

Distancia
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.8
2

1/x
log(y)
0.02234138
-0.69897
0.01996008 -0.39794001
0.01890359 -0.22184875
0.01843318 -0.09691001
0.01809627
0
0.01786352 0.07918125
0.01780944 0.14612804
0.01770852 0.20411998
0.01760253 0.25527251
0.01746725
0.30103

0.4
0.2
0
0
-0.2
-0.4
-0.6
-0.8
-1

0.005

log(y) vs 1/x

0.01

0.015

0.02

0.025
Series1
Linear (Series1)
y = -202.89984x + 3.73471
R = 0.92339

H
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

Distancia
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.8
2

x
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

log(y)
-0.69897
-0.39794001
-0.22184875
-0.09691001
0
0.07918125
0.14612804
0.20411998
0.25527251
0.30103

0.4
0.2
0
0
-0.2
-0.4
-0.6
-0.8
-1

10

20

log(y) vs x

20

30

40

50

60

70
Series1
Linear (Series1)
y = 0.07981x - 4.35218
R = 0.95358

La mejor linealizacin se logro con el modelo 11:

Donde:

a = 1/C
b = P/C

Con la ecuacin obtenida en la linealizacin:


Tenemos entonces:

a
b

y = 23.154,89561730340000x 6,60956317841478
-0.151295929
-3503.241439

,
=
,
H/pixeles
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

Distancia
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.8
2

Ya/uA
Error absoluto
0.20210578 0.002105777
0.3823422
0.017657799
0.60069403 0.000694034
0.79487704 0.005122964
1.0276565
0.027656496
1.28321927 0.083219275
1.36125408 0.038745924
1.5346423
0.065357703
1.77002616 0.029973845
2.19728906 0.197289059

Error relativo
0.010528886
0.044144498
0.001156723
0.006403705
0.027656496
0.069349396
0.02767566
0.040848565
0.016652136
0.09864453
Er(%) promedio

Er(%)
1.05288862
4.41444977
0.11567233
0.64037047
2.76564964
6.93493957
2.76756599
4.08485647
1.66521358
9.86445297
3.43060594

D/m
2.5

1.5

0.5

6317841478

D/m
2.5

1.5
Modelo
Curva de calibracin

0.5

0
0

10

20

30

40

50

60

70

H/pixeles

va de calibracin

La mejor linealizacin se logro con el modelo 6:

=
+
Donde:

a=C
b=P

Con la ecuacin obtenida en la linealizacin:


Tenemos entonces:

a
b

y = 917,61055430860400x 15,62011797398780
-15.62011797
917.6105543
i/uA
3

=
, + ,
H
44.76
50.1
52.9
54.25
55.26
55.98
56.15
56.47
56.81
57.25

Distancia
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.8
2

Ya/uA
Error absoluto
0.20489433 0.004894325
0.37099392 0.029006078
0.57936848 0.020631521
0.77258122 0.027418778
1.0150096
0.015009596
1.29594282 0.095942825
1.38502003 0.014979974
1.58880248 0.011197518
1.87915631
0.07915631
2.45089642 0.450896419

Error relativo
0.024471625
0.072515196
0.034385868
0.034273472
0.015009596
0.079952354
0.010699982
0.006998449
0.043975728
0.225448209
Er(%) promedio

2.5

Er(%)
2.44716252
7.25151962
3.43858677
3.42734721
1.50095955
7.9952354
1.06999818
0.69984489
4.39757277
22.5448209
5.47730478

2
1.5
1
0.5
0

1797398780

/uA
3
2.5
2
Modelo

1.5

Curva de calibracin
1
0.5
0
0

10

20

30

40

50

60

70

p/hPa

rva de calibracin

También podría gustarte