Informesfisica

CÁLCULOS Y GRÁFICAS EN EXCEL
1. PARTE EXPERIMENTAL
V vs. I
TABLA Nº 1
I (A) | V (V) |
0.50 | 2.18 |
1.00 | 4.36 |
2.00 | 8.72 |
4.00 | 17.44 |
GRÁFICA Nº 1

CALCULANDO LA ECUACIÓN DE LA GRÁFICA GENERADA:

Se sabe que la ecuación de la recta está dado por:
y=b+mx
Donde:
m=pxiyi- xi yipxi2- (xi)2 , b=xi2yi- xi xiyipxi2- (xi)2

| Xi | Yi | Xi Yi | Xi 2 |
1 |0.50 | 2.18 | 1.09 | 0.25 |
2 | 1.00 | 4.36 | 4.36 | 1.00 |
3 | 2.00 | 8.72 | 17.44 | 4.00 |
4 | 4.00 | 17.44 | 69.76 | 16.00 |
p=4 | xi=7.50 | yi=32.70 | xi yi=92.65 | xi2=21.25 |

m=4×92.65- 7.50 ×32.74×21.25- 7.502 →m=4.36

b=21.25×32.7-7.50×92.654×21.25- 7.502 → b=0

* La Ec. De la grafica generada es:

y=4.36x

t vs. h
TABLA Nº 2.1
h (cm) | tTiempo de vaciado (s) |
30.00 | 73.00 | 41.20 | 18.40 | 6.80 | 3.20 |
20.00 | 59.90 | 33.70 | 14.90 | 5.30 | 2.70 |
10.00 | 43.00 | 23.70 | 10.50 | 3.90 | 2.00 |
4.00 | 26.70 | 15.00 | 6.80 | 2.60 | 1.30 |
1.00 | 13.50 | 7.80 | 3.70 | 1.50 | 0.80 |
GRÁFICA Nº 2.1

CALCULANDO LA ECUACIÓN DE LA CADA CURVA GENERADA:
La ecuación de la función Potencial: y=kxn, k=10b yn=m
Donde:
m=plogxilogyi- logxi logyip(logxi)2- logxi2
b=(logxi)2logyi- logxi logxilogyip(logxi)2- (logxi)2
Para D=1.5 cm
  | xi | yi | logxi= X | logyi= Y | logxilogyi= XY | (logxi)2= X2 |
1 | 30.00 | 73.00 | 1.48 | 1.86 | 2.75 | 2.18 |
2 | 20.00 | 59.90 | 1.30 | 1.78 | 2.31 | 1.69 |
3 | 10.00 | 43.00 | 1.00 | 1.63 | 1.63 | 1.00 |
4 | 4.00 | 26.70 | 0.60 | 1.43 | 0.86| 0.36 |
5 | 1.00 | 13.50 | 0.00 | 1.13 | 0.00 | 0.00 |
 P= 5 | | | logxi=4.38 | logyi=7.83 | logxilogyi=7.56 | (logxi)2=5.24 |
Calculando: m=0.497 b=1.13
k=101.13 y n=0.497
* y=13.489x0.497
Para D= 2 cm
  | xi | yi | logxi.= X | logyi.= Y | logxilogyi= XY | (logxi)2= X2 |
1 | 30.00 | 41.20 | 1.48 | 1.61 | 2.39 | 2.18 |
2 | 20.00 | 33.70 | 1.30 | 1.53 | 1.99| 1.69 |
3 | 10.00 | 23.70 | 1.00 | 1.37 | 1.37 | 1.00 |
4 | 4.00 | 15.00 | 0.60 | 1.18 | 0.71 | 0.36 |
5 | 1.00 | 7.80 | 0.00 | 0.89 | 0.00 | 0.00 |
 P= 5 | | | logxi=4.38 | logyi=6.59 | logxilogyi=6.46 | (logxi)2=5.24 |

Calculando: m=0.490 b=0.887
k=100.887 y n=0.887
* y= 7.7 x0.49
Para D= 3 cm
  | xI | yi | logxi= X | logyi= Y | logxilogyi= XY |(logxi)2= X2 |
1 | 30.00 | 18.40 | 1.48 | 1.26 | 1.87 | 2.18 |
2 | 20.00 | 14.90 | 1.30 | 1.17 | 1.53 | 1.69 |
3 | 10.00 | 10.50 | 1.00 | 1.02 | 1.02 | 1.00 |
4 | 4.00 | 6.80 | 0.60 | 0.83 | 0.50 | 0.36 |
5 | 1.00 | 3.70 | 0.00 | 0.57 | 0.00 | 0.00 |
  P= 5 | | | logxi=4.38 | logyi=4.86 | logxilogyi=4.92 | (logxi)2=5.24 |
Calculando: m=0.47 b=0.559
k=100.559 y n=0.47* y=3.624x0.47
Para D= 5 cm
  | xI | yI | logxi= X | logyi= Y | logxilogyi= XY | (logxi)2= X2 |
1 | 30.00 | 6.80 | 1.48 | 0.83 | 1.23 | 2.18 |
2 | 20.00 | 5.30 | 1.30 | 0.72 | 0.94 | 1.69 |
3 | 10.00 | 3.90 | 1.00 | 0.59 | 0.59 | 1.00 |
4 | 4.00 | 2.60 | 0.60 | 0.41 | 0.25 | 0.36 |
5 | 1.00 | 1.50 | 0.00 | 0.18 | 0.00 | 0.00 |
  P= 5  | | | logxi=4.38 | logyi=2.74 |logxilogyi=3.01 | (logxi)2=5.24 |
Calculando: m= 0.438 b=0.163
k=100.163 y n=0.438
* y=1.45x0.438
Para D= 7 cm
  | xi | yi | logxi= X | logyi= Y | logxilogyi= XY | (logxi)2= X2 |
1 | 30.00 | 3.20 | 1.48 | 0.51 | 0.75 | 2.18 |
2 | 20.00 | 2.70 | 1.30 | 0.43 | 0.56 | 1.69 |
3 | 10.00 | 2.00 | 1.00 | 0.30 | 0.30 | 1.00 |
4 | 4.00 | 1.30 | 0.60 | 0.11 | 0.07 | 0.36 |
5 |1.00 | 0.80 | 0.00 | -0.10 | 0.00 | 0.00 |
  P= 5  | | | logxi=4.38 | logyi=1.25 | logxilogyi=1.68 | (logxi)2=5.24 |
Calculando: m= 0.412 b= - 0.11
k=10-0.11 y n=0.412
* y=0.77 x0.412
t vs. D
TABLA Nº 2.2

D (cm) | Tiempo de vaciado (s) |
1.50 | 73.00 | 59.90 | 43.00 | 26.70 | 13.50 |
2.00 | 41.20 | 33.70 | 23.70 | 15.00 | 7.80 |
3.00 | 18.40 | 14.90 |...