Graficas Lab 2

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

Datos Resorte Amarillo

G 9.78
ΔL (mm)
N m(g) w(N) (mm)
1 5.10 49.88 13
2 10.30 100.73 28
3 15.40 150.61 38
4 20.77 203.13 60
5 25.87 253.01 70
6 31.06 303.77 101

100
Peso vs Alargamiento
i W(N) ΔL (mm)
120.00
1 49.878 13.00
2 100.734 28.00 100.00
3 150.612 38.00 f(x) = 0.330645638387573 x − 6.80966771036762
80.00 R² = 0.972549558910968
4 203.131 60.00 Peso (N)
5 253.009 70.00 60.00
6 303.767 101.00 40.00

20.00

0.00
0.000 50.000 100.000 150.000 200.000 250.000

Alargamiento (mm)

Con la Ecu. De Linealizado


i W(N) ΔL (mm)
Campo Magneticio vs Corriente (linealizado)
1 49.88 9.682
2 100.73 26.498 100.000
f(x)f(x)
= 0.0777602169536855 x^1.24963697330602
= 0.330645638387573 x − 6.80966771036768
3 150.61 42.990 80.000 R² = 1
4 203.13 60.355 60.000
Peso (N)

5 253.01 76.847
40.000
6 303.77 93.629
7 20.000

8 0.000
2.50 52.50 102.50 152.50 202.50 252.50 302.50
9
Alargamiento (mm)
10 0.00 -6.810
i Log(D) Log(Bc) Log (Bc) vs Log (D)
1 1.70 1.11
2 2.00 1.45 1.70 f(x) = 1.09509022635985 x − 0.757832
3 2.18 1.58 1.50
4 2.31 1.78 1.30
5 2.40 1.85 Log (Bc) 1.10
6 2.48 2.00 0.90
7 0.70
8 0.50
0.40 0.90 1.40 1.90 2.40
9
Log (D)
10
Peso(W) vs Alargamiento(mm):
miento
N Xi= Yi X*Y X²
1 49.88 13.00 648.414 2487.815
2 100.73 28.00 2820.552 10147.339
3 x − 6.80966771036762 3 150.61 38.00 5723.256 22683.975
4 203.13 60.00 12187.836 41262.041
5 253.01 70.00 17710.602 64013.352
6 303.77 101.00 30680.447 92274.269
Σ 1061.13 310.00 69771.107 232868.789
6
0 200.000 250.000 300.000

(mm)

iente (linealizado)
4963697330602
6.80966771036768
𝑦=𝐴+𝐵𝑥
A =-6.81
B = 0.33

202.50 252.50 302.50 352.50


nto (mm)
Log (D)
9509022635985 x − 0.757832840300122

1.90 2.40 2.90


Y² Y'=a+b(Xi) di di²
169.000 9.6823 3.32 11.007
784.000 26.4976 1.50 2.257
1444.000 42.9895 -4.99 24.895
3600.000 60.3546 -0.35 0.126
4900.000 76.8465 -6.85 46.875
10201.000 93.6295 7.37 54.324
21098.000 310.0000 0.00 139.485

N= -1846889.8768
D= 271215.8589
A= -6.8097
N= 89676.3408
D= 271215.8589
B= 0.3306

𝐴+𝐵𝑥
=-6.81
= 0.33
N= 139.4848
D= 4.0000
σ²= 34.8712
σ= 5.9052

5.4718

0.028
Datos Resorte Rojo
G 9.78
ΔL (mm)
N m(g) w(N) (mm)
1 5.10 49.88 33
2 10.30 100.73 77
3 15.40 150.61 125
4 20.77 203.13 174
5 25.87 253.01 221
6 31.06 303.77 315

100
Peso vs Alargamiento
i W(N) ΔL (mm)
350.00
1 49.878 33.00
2 100.734 77.00 300.00
f(x) = 1.06292863990756 x − 30.4842446108523
3 150.612 125.00 250.00 R² = 0.97935141551385
4 203.131 174.00 Peso (N) 200.00
5 253.009 221.00
150.00
6 303.767 315.00
100.00
50.00
0.00
0.000 50.000 100.000 150.000 200.000 250.000

Alargamiento (mm)

Con la Ecu. De Linealizado


i W(N) ΔL (mm)
Campo Magneticio vs Corriente (linealizado)
1 49.88 22.533
2 100.73 76.589 350.000
300.000 f(x) = 0.103286497924215 x^1.40577749005054
3 150.61 129.606 f(x) = 1.06292863990757 x − 30.4842446108523
250.000
4 203.13 185.429 R² = 1
Peso (N)

200.000
5 253.01 238.446 150.000
6 303.77 292.398 100.000
7 50.000
8 0.000
2.50 52.50 102.50 152.50 202.50 252.50 302.50
9
Alargamiento (mm)
10 0.00 -30.484
i Log(D) Log(Bc) Log (Bc) vs Log (D)
1 1.70 1.52
2 2.00 1.89 1.70 f(x) = 1.21301375315303 x − 0.545304
3 2.18 2.10 1.50
4 2.31 2.24 1.30

Log (Bc)
5 2.40 2.34 1.10
6 2.48 2.50 0.90
7 0.70
8 0.50
0.40 0.90 1.40 1.90 2.40
9
Log (D)
10
Peso(W) vs Alargamiento(mm):
miento
N Xi= Yi X*Y X²
1 49.88 33.00 1645.974 2487.815
2 100.73 77.00 7756.518 10147.339
x − 30.4842446108523
3 150.61 125.00 18826.500 22683.975
4 203.13 174.00 35344.724 41262.041
5 253.01 221.00 55914.901 64013.352
6 303.77 315.00 95686.542 92274.269
Σ 1061.13 945.00 215175.159 232868.789
6
0 200.000 250.000 300.000

(mm)

iente (linealizado)

577749005054
30.4842446108523 𝑦=𝐴+𝐵𝑥
𝐵=𝑎+𝑏𝐼
A = a=-30.484
B = b = 1.063

202.50 252.50 302.50 352.50


nto (mm)
Log (D)
1301375315303 x − 0.545304821400695

1.90 2.40 2.90


Y² Y'=a+b(Xi) di di²
1089.000 22.5325 10.47 109.568
5929.000 76.5888 0.41 0.169
15625.000 129.6056 -4.61 21.211
30276.000 185.4291 -11.43 130.624
48841.000 238.4458 -17.45 304.357
99225.000 292.3982 22.60 510.842
200985.000 945.0000 0.00 1076.772

N= -8267810.5844
D= 271215.8589
A= -30.4842
N= 288283.1040
D= 271215.8589
B= 1.0629

𝐴+𝐵𝑥
=𝑎+𝑏𝐼
a=-30.484
b = 1.063
N= 1076.7721
D= 4.0000
σ²= 269.1930
σ= 16.4071

15.2030

0.077
Datos Resorte Azul
G 9.78
ΔL (mm)
N m(g) w(N) (mm)
1 5.10 49.88 6
2 10.30 100.73 26
3 15.40 150.61 45
4 20.77 203.13 66
5 25.87 253.01 87
6 31.06 303.77 125

100
Peso vs Alargamiento
i W(N) ΔL (mm)
140.00
1 49.878 6.00
2 100.734 26.00 120.00
f(x) = 0.449123842917247 x − 20.2631305724631
3 150.612 45.00 100.00 R² = 0.982235213676109
4 203.131 66.00 Peso (N) 80.00
5 253.009 87.00
60.00
6 303.767 125.00
40.00
20.00
0.00
0.000 50.000 100.000 150.000 200.000 250.000

Alargamiento (mm)

Con la Ecu. De Linealizado


i W(N) ΔL (mm)
Campo Magneticio vs Corriente (linealizado)
1 49.88 2.138
2 100.73 24.979 140.000
f(x) = 0.000757562231930219 x^2.1429175089764
120.000
3 150.61 47.380 f(x) = 0.449123842917248 x − 20.2631305724633
100.000
4 203.13 70.968 R² = 1
Peso (N)

80.000
5 253.01 93.369 60.000
6 303.77 116.166 40.000
7 20.000
8 0.000
2.50 52.50 102.50 152.50 202.50 252.50 302.50
9
Alargamiento (mm)
10 0.00 -20.263
i Log(D) Log(Bc) Log (Bc) vs Log (D)
1 1.70 0.78
2 2.00 1.41 1.70 f(x) = 1.62129807142366 x − 1.91532
3 2.18 1.65 1.50
4 2.31 1.82 1.30

Log (Bc)
5 2.40 1.94 1.10
6 2.48 2.10 0.90
7 0.70
8 0.50
0.40 0.90 1.40 1.90 2.40
9
Log (D)
10
Peso(W) vs Alargamiento(mm):
miento
N Xi= Yi X*Y X²
1 49.88 6.00 299.268 2487.815
2 100.73 26.00 2619.084 10147.339
7 x − 20.2631305724631
3 150.61 45.00 6777.540 22683.975
4 203.13 66.00 13406.620 41262.041
5 253.01 87.00 22011.748 64013.352
6 303.77 125.00 37970.850 92274.269
Σ 1061.13 355.00 83085.110 232868.789
6
0 200.000 250.000 300.000

(mm)

iente (linealizado)
2.1429175089764
8 x − 20.2631305724633 𝑦=𝐴+𝐵𝑥
𝐵=𝑎+𝑏𝐼
A = a=-20.263
B = b = 0.449

202.50 252.50 302.50 352.50


nto (mm)
Log (D)
62129807142366 x − 1.91532325094316

1.90 2.40 2.90


Y² Y'=a+b(Xi) di di²
36.000 2.1383 3.86 14.913
676.000 24.9789 1.02 1.043
2025.000 47.3803 -2.38 5.666
4356.000 70.9677 -4.97 24.678
7569.000 93.3691 -6.37 40.565
15625.000 116.1658 8.83 78.043
30287.000 355.0000 0.00 164.908

N= -5495682.3618
D= 271215.8589
A= -20.2631
N= 121809.5088
D= 271215.8589
B= 0.4491

𝐴+𝐵𝑥
=𝑎+𝑏𝐼
a=-20.263
b = 0.449
N= 164.9076
D= 4.0000
σ²= 41.2269
σ= 6.4208

5.9496

0.030
x y
i L(cm)+-0,1 T=t/5
1 80.000 1.56
2 76.000 1.55
3 72.500 1.53
Periodo vs la longuitud
4 69.500 1.48
5 66.000 1.47 1.80
1.60
6 63.000 1.37 f(x) = 0.0140357833003018 x + 0.510098972689725 1.55
1.53
1.48
1.47
1.40 R² = 0.984470685671527 1.370
1.37
7 60.000 1.370 1.330
1.320
1.20 1.210
8 56.500 1.330 1.120
1.070
1.130
1.120
T=Periodo

1.00 1.020
9 53.500 1.320 0.960
0.940
0.880
0.80 0.850
10 50.500 1.210 0.760
0.740
0.670
0.60
11 47.200 1.130 0.530
0.40
12 44.000 1.120
0.20
13 41.000 1.120
0.00
14 37.800 1.070 0.000 10.000 20.000 30.000 40.000 50.000 60.000 70.000 80.00
15 34.500 1.020 L=longitud
16 31.500 0.960
17 28.200 0.940
18 25.000 0.880
19 21.700 0.850
20 18.200 0.760
21 16.500 0.740
22 13.000 0.670
23 9.000 0.530

Con la Ecu. De Linealizado


i L(cm)+-0,1 ΔL (mm)
1 80.00 1.734
2 76.00 1.648
3 72.50 1.573 Periodo vs longitud
4 69.50 1.508 2.000
1
1.800 1.64
1.573
1.600 1.508
f(x) = 0.0215482715316245 x + 0.0103258340553538
1.433
R² = 1 1.368
1.400 1.303
1.228
1.163
1.099
(s)
Periodo vs longitud
2.000
5 66.00 1.433 1
1.800 1.64
1.573
6 63.00 1.368 1.600 f(x) = 0.0215482715316245 x + 0.0103258340553538 1.508
1.433
R² = 1 1.368
7 60.00 1.303 1.400 1.303
1.228
1.163
8 56.50 1.228 1.099

T=Periodo (s)
1.200 1.027
0.958
9 53.50 1.163 1.000 0.894
0.825
0.754
10 50.50 1.099 0.800 0.689
0.618
0.549
11 47.20 1.027 0.600 0.478
0.403
0.366
12 44.00 0.958 0.400 0.290
0.204
13 41.00 0.894 0.200
0.000
14 37.80 0.825 0.00 10.00 20.00 30.00 40.00 50.00 60.00 70.00 8
15 34.50 0.754 L=lontitud(cm)
16 31.50 0.689
17 28.20 0.618
18 25.00 0.549
19 21.70 0.478
20 18.20 0.403
21 16.50 0.366
22 13.00 0.290
23 9.00 0.204

N log(T)(s) log(L) (cm)


1 0.1931246 1.90308999
2 0.1903317 1.88081359
LOG(T) VS LOG(L)
3 0.18469143 1.86033801
2
4 0.17026172 1.8419848 1.77811
1.799
1.75204
1.72835
1.8 1.7032913781
1.6739419986340
f(x) = 2.0396425737839 x + 1.5068378243334
1.64345267648619
5 0.16731733 1.81954394 1.61278385671974
1.57749179983723
1.53781909507327
R² = 0.992128630632465 1.4983105537896
1.6
1.45024910831936
1.39794000867204
6 0.13672057 1.79934055 1.33645973384853
1.26007138798507
1.21748394421391 1.4
LOG(T) (s)

7 0.13672057 1.77815125 1.11394335230684 1.2


8 0.12385164 1.75204845 0.954242509439325
1
9 0.12057393 1.72835378 0.8
10 0.08278537 1.70329138 0.6
11 0.05307844 1.673942 0.4
12 0.04921802 1.64345268 0.2
13 0.04921802 1.61278386 0
-0.3 -0.2 -0.1 0 0.1
14 0.02938378 1.5774918
15 0.00860017 1.5378191 LOG(L) (cm)
16 -0.01772877 1.49831055
17 -0.02687215 1.45024911
18 -0.05551733 1.39794001
19 -0.07058107 1.33645973
20 -0.11918641 1.26007139
21 -0.13076828 1.21748394
22 -0.1739252 1.11394335
23 -0.27572413 0.95424251
𝑇=2𝜋/√(2&𝐺)⋅√𝐿

Periodo vs longitud
N Xi= Yi X*Y X²
1 80.00 1.56 124.80000 6400.0000
2 76.00 1.55 117.80000 5776.0000
guitud
3 72.50 1.53 110.92500 5256.2500
4 69.50 1.48 102.86000 4830.2500
0.510098972689725 1.48
1.47
1.551.56
1.53 5 66.00 1.47 97.02000 4356.0000
1.370
1.330
1.320 1.37 6 63.00 1.37 86.31000 3969.0000
1.210
1.130
0120 7 60.00 1.37 82.20000 3600.0000
8 56.50 1.33 75.14500 3192.2500
r 9 53.50 1.32 70.62000 2862.2500
10 50.50 1.21 61.10500 2550.2500
11 47.20 1.13 53.33600 2227.8400
12 44.00 1.12 49.28000 1936.0000
.000 60.000 70.000 80.000 90.000 13 41.00 1.12 45.92000 1681.0000
d 14 37.80 1.07 40.44600 1428.8400
15 34.50 1.02 35.19000 1190.2500
16 31.50 0.96 30.24000 992.2500
17 28.20 0.94 26.50800 795.2400
18 25.00 0.88 22.00000 625.0000
19 21.70 0.85 18.44500 470.8900
20 18.20 0.76 13.83200 331.2400
21 16.50 0.74 12.21000 272.2500
22 13.00 0.67 8.71000 169.0000
23 9.00 0.53 4.77000 81.0000
Σ 647.50 14.19 928.78500 42792.2500
23

ngitud

1.734
1.648
1.573
1.508
x + 0.0103258340553538
1.433
1.368
1.303
1.228
1.163
1.099
ngitud

1.734
1.648
1.573
1.508
x + 0.0103258340553538
1.433
1.368
1.303
1.228
1.163
1.099
1.027
58

𝒚=𝒎𝒙+𝒂
𝒚=𝒃𝒙+𝒂

50.00 60.00 70.00 80.00 90.00


ud(cm)

G(T) VS LOG(L)
2 1.90308998699194
1.88081359228079
1.86033800657099
1.84198480459011
1.81954393554187
1.79934054945358
1.77815125038364
1.75204844781944
1.72835378202123
1.70329137811866
1.67394199863409
1.8
+ 1.5068378243334
1.64345267648619
1.61278385671974
1.57749179983723
1.53781909507327
1.4983105537896
1.6
.45024910831936
94000867204
973384853
8507
91 1.4
1.2
1
0.8
0.6
0.4
0.2
0
0 0.1 0.2 0.3
LOG(L) (cm)
Y² Y'=a+b(Xi) di di² i
2.4336 1.7342 -0.17 0.030 1
2.4025 1.6480 -0.10 0.010 2
2.3409 1.5726 -0.04 0.002 3
2.1904 1.5079 -0.03 0.001 4
2.1609 1.4325 0.04 0.001 5
1.8769 1.3679 0.00 0.000 6
1.8769 1.3032 0.07 0.004 7
1.7689 1.2278 0.10 0.010 8
1.7424 1.1632 0.16 0.025 9
1.4641 1.0985 0.11 0.012 10
1.2769 1.0274 0.10 0.011 11
1.2544 0.9584 0.16 0.026 12
1.2544 0.8938 0.23 0.051 13
1.1449 0.8249 0.25 0.060 14
1.0404 0.7537 0.27 0.071 15
0.9216 0.6891 0.27 0.073 16
0.8836 0.6180 0.32 0.104 17
0.7744 0.5490 0.33 0.110 18
0.7225 0.4779 0.37 0.138 19
0.5776 0.4025 0.36 0.128 20
0.5476 0.3659 0.37 0.140 21
0.4489 0.2905 0.38 0.144 22
0.2809 0.2043 0.33 0.106 23
20.2575 14.0558 0.13 0.096
i
1
2
3
N= 5833.7400 4
D= 564965.5000 5
A= 0.0103 6
N= 12174.0300 7
D= 564965.5000 8
B= 0.0215 9
10
11
12
13
N= 0.0959 14
D= 21.0000 15
σ²= 0.0046 16
σ= 0.0676 17
18
19
20
0.0186 21
22
23

0.000
x y
T=5/t (s) √(2&𝐿)(cm)
1.56 8.940
1.55 8.720
1.53 8.330
1.48 8.120
1.47 7.940
Periodo vs la Raiz de la longitud
1.37 7.740
1.37 7.740 10.000
9.000 8.1
1.33 7.520 7.7407.9
7.520
f(x) = 5.56194412940966 x + 0.103508326866829
8.000 7.110 7.310
1.32 7.310 R² = 0.986748482436689 6.630 6.870
6.400
7.000 6.140
1.21 7.110 5.870
5.610
T= Periodo (s)

6.000 5.310
5.000
1.13 6.870 5.000 4.260
4.660
4.060
1.12 6.630 4.000 3.600
3.00
1.12 6.400 3.000
1.07 6.140 2.000
1.02 5.870 1.000
0.96 5.610 0.000
0.40 0.60 0.80 1.00 1.20 1.40
0.94 5.310
0.88 5.000 l= Longitud (cm)
0.85 4.660
0.76 4.260
0.74 4.060
0.67 3.600
0.53 3.00

T=5/t (s) √(2 (cm)


&𝐿)
1.56 0.04
1.55 0.04
1.53 0.04
1.48 0.04 Periodo vs La raiz de la longitud
1.47 0.04 0.05
1.37 0.04
0.04 f(x) = 0.0277048220726017 x
R² = 1
odo (s)

0.03
Periodo vs La raiz de la longitud
0.05

1.37 0.04 0.04 f(x) = 0.0277048220726017 x


R² = 1
1.33 0.04

T=Periodo (s)
1.32 0.04 0.03
1.21 0.03
0.02
1.13 0.03
1.12 0.03
0.01
1.12 0.03
1.07 0.03
0.00
1.02 0.03 0.40 0.60 0.80 1.00 1.20 1.40

0.96 0.03 L=logitud (s)


0.94 0.03
0.88 0.02
0.85 0.02
0.76 0.02
0.74 0.02
0.67 0.02
0.53 0.01
𝑇=2𝜋/√(2&𝐺)⋅√𝐿

Periodo vs raiz de l
N Xi=T
1 1.56
2 1.55
3 1.53
4 1.48
5 1.47
a Raiz de la longitud
6 1.37
8.940
8.720 7 1.37
8.330
8.120
7.7407.940
7.520
2940966 x + 0.103508326866829
8 1.33
7.310
6.8707.110
2436689 6.630 9 1.32
6.400
6.140
5.870
5.610 10 1.21
5.310
000
60 11 1.13
12 1.12
13 1.12
14 1.07
15 1.02
16 0.96
1.00 1.20 1.40 1.60 1.80
17 0.94
l= Longitud (cm) 18 0.88
19 0.85
20 0.76
21 0.74
22 0.67
23 0.53
Σ 14.19
23

𝒚=𝒎𝒙+𝒂
𝒚=𝒃𝒙+𝒂
La raiz de la longitud

0726017 x
La raiz de la longitud

0726017 x

1.00 1.20 1.40 1.60 1.80


L=logitud (s)
I
𝑇=2𝜋/√(2&𝐺)⋅√𝐿

Yi=l X*Y X² Y² Y'=a+b(Xi) di di²


8.94 13.94640 2.43360 79.92360 8.72909 0.21 0.04448
8.72 13.51600 2.40250 76.03840 8.67316 0.05 0.00219
8.33 12.74490 2.34090 69.38890 8.56132 -0.23 0.05351
8.12 12.01760 2.19040 65.93440 8.28170 -0.16 0.02615
7.94 11.67180 2.16090 63.04360 8.22577 -0.29 0.08167
7.74 10.60380 1.87690 59.90760 7.66653 0.07 0.00540
7.74 10.60380 1.87690 59.90760 7.66653 0.07 0.00540
7.52 10.00160 1.76890 56.55040 7.44284 0.08 0.00595
7.31 9.64920 1.74240 53.43610 7.38691 -0.08 0.00592
7.11 8.60310 1.46410 50.55210 6.77175 0.34 0.11441
6.87 7.76310 1.27690 47.19690 6.32436 0.55 0.29772
6.63 7.42560 1.25440 43.95690 6.26843 0.36 0.13073
6.40 7.16800 1.25440 40.96000 6.26843 0.13 0.01731
6.14 6.56980 1.14490 37.69960 5.98881 0.15 0.02286
5.87 5.98740 1.04040 34.45690 5.70919 0.16 0.02586
5.61 5.38560 0.92160 31.47210 5.37365 0.24 0.05586
5.31 4.99140 0.88360 28.19610 5.26180 0.05 0.00232
5.00 4.40000 0.77440 25.00000 4.92626 0.07 0.00544
4.66 3.96100 0.72250 21.71560 4.75849 -0.10 0.00970
4.26 3.23760 0.57760 18.14760 4.25517 0.00 0.00002
4.06 3.00440 0.54760 16.48360 4.14332 -0.08 0.00694
3.60 2.41200 0.44890 12.96000 3.75186 -0.15 0.02306
3.00 1.59000 0.28090 9.00000 2.96892 0.03 0.00097
79.47 113.35820 20.25750 634.68270 79.40560 0.06 0.34507

N= 1.310667
𝒚=𝒎𝒙+𝒂 D= 264.5664
𝒚=𝒃𝒙+𝒂 A= 0.004954019104
N= 1479.5593
D= 264.5664
Correlación lineal (r) B= 5.592393062762
N= 0.34507
D= 21
σ²= 0.016432084027
σ= 0.128187690624

0.03547

0.03780
función potencial
Linealización de función potencial y=ax^b
y=ax^b → log⁡〖 (y) 〗 =log⁡〖 (a) 〗 +b Log(x)
Y = A+ BX
donde:
Y = log(y) → y = 10^(Y)
A= log(a) → a = 10^(A) a 1.01147236
B= b
X = log(x) → x = 10^(X) b 5.59239306

Linealización de función exponencial


y=ae^bx → log⁡〖 (y) 〗 =ln(a)+ 〖 ln⁡(e 〗 ^bx) función exponencial
= ln(a) + bx y=ae^bx
Y = A+ BX
donde:
Y = ln(y) → y = e^(Y)
A= ln(a) → a = e^(A) a 1.00496631
B= b b 5.59239306
X=x
donde:
Y = ln(y) → y = e^(Y)
A= ln(a) → a = e^(A)
B= b
X=x
otencial
x^b

exponencial
ae^bx

También podría gustarte