physices lab report

profilemashan669
CopyofLab4PhysII.xlsx

Sheet1

Column1 Column2 Column4
RC Circuit Trendline equation time constant
RC circuit with 10 Ω resistor y = 38.827e-0.071x
RC circuit with 50 Ω resistor y = 35.666e-0.015x
RC circuit with 100 Ω resistor y = 37.004e-0.008x
Run #1 Run #1
Time (s) Voltage (V) Run #1 Run #1
0 0.691 Time (s) Voltage (V)
1 1.054 33 4.625
2 1.311 34 4.033
3 1.55 35 3.446
4 1.778 36 3.091
5 1.998 37 2.792
6 2.208 38 2.537
7 2.41 39 2.319
8 2.602 40 2.13
9 2.785 41 1.965
10 2.957 42 1.818
11 3.118 43 1.69
12 3.268 44 1.574
13 3.408 45 1.469
14 3.536 46 1.374
15 3.654 47 1.286
16 3.763 48 1.206
17 3.863 49 1.132
18 3.954 50 1.063
19 4.037 51 0.998
20 4.113 52 0.938
21 4.183 53 0.882
22 4.247 54 0.829
23 4.305 55 0.78
24 4.357 56 0.735
25 4.406 57 0.691
26 4.45 58 0.65
27 4.49 59 0.612
28 4.527 60 0.576
29 4.56 61 0.542
30 4.59 62 0.511
31 4.618 63 0.481
32 4.644 64 0.453
65 0.426
66 0.401
67 0.378

discharge 10Ω

Voltage (V)

V= 38.827e-0.071t

33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 4.625 4.0330000000000004 3.4460000000000002 3.0910000000000002 2.7919999999999998 2.5369999999999999 2.319 2.13 1.9650000000000001 1.8180000000000001 1.69 1.5740000000000001 1.4690000000000001 1.3 740000000000001 1.286 1.206 1.1319999999999999 1.0629999999999999 0.998 0.93799999999999994 0.88200000000000001 0.82899999999999996 0.78 0.73499999999999999 0.69099999999999995 0.65 0.61199999999999999 0.57599999999999996 0.54200000000000004 0.51100000000000001

Time (s)

Voltage (v)

Sheet2

charging 50 discharging 50
Run #1 Run #1 Run #1 Run #1
Time (s) Voltage (V) Time (s) Voltage (V)
0 0.307 150 4.103
5 0.766 155 3.632
10 1.076 160 3.237
15 1.374 165 2.909
20 1.652 170 2.638
25 1.923 175 2.406
30 2.182 180 2.204
35 2.431 185 2.026
40 2.66 190 1.867
45 2.875 195 1.73
50 3.075 200 1.606
55 3.259 205 1.486
60 3.417 210 1.381
65 3.571 215 1.283
70 3.705 220 1.196
75 3.832 225 1.115
80 3.94 230 1.039
85 4.037 235 0.971
90 4.125 240 0.905
95 4.206 245 0.839
100 4.272 250 0.785
105 4.338 255 0.737
110 4.396 260 0.685
115 4.443 265 0.641
120 4.487 270 0.597
125 4.531 275 0.558
130 4.565 280 0.519
135 4.594
140 4.623

Discharge 50 Ω

T vs. V

V= 35.666e-0.015t

150 155 160 165 170 175 180 185 190 195 200 205 210 215 220 225 230 235 240 245 250 255 260 265 270 275 280 4.1029999999999998 3.6320000000000001 3.2370000000000001 2.9089999999999998 2.6379999999999999 2.4060000000000001 2.2040000000000002 2.0259999999999998 1.867 1.73 1.6060000000000001 1.486 1.381 1.2829999999999999 1.196 1.115 1.0389999999999999 0.97099999999999997 0.90500000000000003 0.83899999999999997 0.78500000000000003 0.73699999999999999 0.68500000000000005 0.64100000000000001 0.59699999999999998 0.55800000000000005 0.51900000000000002

Time (s)

voltage (V)

Sheet3

charge 100 discharge 100
Run #2 Run #2 Run #2 Run #2
Time (s) Voltage (V) Time (s) Voltage (V)
0 0.043 300 4.15
10 0.475 310 3.664
20 0.81 320 3.276
30 1.127 330 2.951
40 1.42 340 2.673
50 1.706 350 2.436
60 1.979 360 2.233
70 2.236 370 2.055
80 2.475 380 1.894
90 2.707 390 1.755
100 2.914 400 1.618
110 3.11 410 1.503
120 3.29 420 1.398
130 3.451 430 1.301
140 3.6 440 1.208
150 3.73 450 1.12
160 3.849 460 1.042
170 3.954 470 0.971
180 4.054 480 0.907
190 4.137 490 0.846
200 4.211 500 0.79
210 4.277 510 0.741
220 4.338 520 0.685
230 4.394 530 0.636
240 4.438 540 0.593
250 4.484 550 0.556
260 4.521 560 0.519
270 4.562
280 4.594
290 4.621

Discharge 100 Ω T vs.V Graph

V = 37.004e-0.008t

300 310 320 330 340 350 360 370 380 390 400 410 420 430 440 450 460 470 480 490 500 510 520 530 540 550 560 4.1500000000000004 3.6640000000000001 3.2759999999999998 2.9510000000000001 2.673 2.4359999999999999 2.2330000000000001 2.0550000000000002 1.8939999999999999 1.7549999999999999 1.6180000000000001 1.5029999999999999 1.3979999999999999 1.3009999999999999 1.208 1.1200000000000001 1.042 0.97099999999999997 0.90700000000000003 0.84599999999999997 0.79 0.74099999999999999 0.68500000000000005 0.63600000000000001 0.59299999999999997 0.55600000000000005 0.51900000000000002

time (s)

voltage (V)

Sheet5

Time (s) charging 10 charging 50 charging 100 charging 50
0 0.691 Run #1 Run #1 charge 100
1 1.054 Time (s) Voltage (V) Run #2 Run #2
2 1.311 0 0.307 Time (s) Voltage (V)
3 1.55 5 0.766 0 0.043
4 1.778 10 1.076 10 0.475
5 1.998 15 1.374 20 0.81
6 2.208 20 1.652 30 1.127
7 2.41 25 1.923 40 1.42
8 2.602 30 2.182 50 1.706
9 2.785 35 2.431 60 1.979
10 2.957 40 2.66 70 2.236
11 3.118 45 2.875 80 2.475
12 3.268 50 3.075 90 2.707
13 3.408 55 3.259 100 2.914
14 3.536 60 3.417 110 3.11
15 3.654 65 3.571 120 3.29
16 3.763 70 3.705 130 3.451
17 3.863 75 3.832 140 3.6
18 3.954 80 3.94 150 3.73
19 4.037 85 4.037 160 3.849
20 4.113 90 4.125 170 3.954
21 4.183 95 4.206 180 4.054
22 4.247 100 4.272 190 4.137
23 4.305 105 4.338 200 4.211
24 4.357 110 4.396 210 4.277
25 4.406 115 4.443 220 4.338
26 4.45 120 4.487 230 4.394
27 4.49 125 4.531 240 4.438
28 4.527 130 4.565 250 4.484
29 4.56 135 4.594 260 4.521
30 4.59 140 4.623 270 4.562
31 4.618 280 4.594
32 4.644 290 4.621
series 1

Charging Graph

0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 0.69099999999999995 1.054 1.3109999999999999 1.55 1.778 1.998 2.2080000000000002 2.41 2.6019999999999999 2.7850000000000001 2.9569999999999999 3.1179999999999999 3.2679999999999998 3.4079999999999999 3.536 3.6539999999999999 3.7629999999999999 3.863 3.9540000000000002 4.0369999999999999 4.1130000000000004 4.1829999999999998 4.2469999999999999 4.3049999999999997 4.3570000000000002 4.4059999999999997 4.45 4.49 4.5270000000000001 4.5599999999999996 4.59 4.6180000000000003 4.6440000000000001 charging 50 0 5 10 15 20 25 30 35 40 45 50 55 60 65 70 75 80 85 90 95 100 105 110 115 120 125 130 135 140 0.307 0.76600000000000001 1.0760000000000001 1.3740000000000001 1.6519999999999999 1.923 2.1819999999999999 2.431 2.66 2.875 3.0750000000000002 3.2589999999999999 3.4169999999999998 3.5710000000000002 3.7050000000000001 3.8319999999999999 3.94 4.0369999999999999 4.125 4.2060000000000004 4.2720000000000002 4.3380000000000001 4.3959999999999999 4.4429999999999996 4.4870000000000001 4.5309999999999997 4.5650000000000004 4.5940000000000003 4.6230000000000002 charging 100 0 10 20 30 40 50 60 70 80 90 100 110 120 130 140 150 160 170 180 190 200 210 220 230 240 250 260 270 280 290 4.2999999999999997E-2 0.47499999999999998 0.81 1.127 1.42 1.706 1.9790000000000001 2.2360000000000002 2.4750000000000001 2.7069999999999999 2.9140000000000001 3.11 3.29 3.4510000000000001 3.6 3.73 3.8490000000000002 3.9540000000000002 4.0540000000000003 4.1369999999999996 4.2110000000000003 4.2770000000000001 4.3380000000000001 4.3940000000000001 4.4379999999999997 4.484 4.5209999999999999 4.5620000000000003 4.5940000000000003 4.6210000000000004