Semana 5 (Calculo 2)

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 18

TIME [RADI] FORMULA MIN

2021-04-04T12:00:00-05:00 307.96 12:00


2021-04-04T12:01:00-05:00 354.71 12:01
2021-04-04T12:02:00-05:00 1496.94 12:02
2021-04-04T12:03:00-05:00 1010.14 12:03
2021-04-04T12:04:00-05:00 337.07 12:04
2021-04-04T12:05:00-05:00 349.72 12:05
2021-04-04T12:06:00-05:00 342.81 12:06
2021-04-04T12:07:00-05:00 1461.21 12:07
2021-04-04T12:08:00-05:00 409.99 12:08
2021-04-04T12:09:00-05:00 403.53 12:09
2021-04-04T12:10:00-05:00 389.85 12:10
2021-04-04T12:11:00-05:00 411.76 12:11
2021-04-04T12:12:00-05:00 420.43 12:12
2021-04-04T12:13:00-05:00 384.85 12:13
2021-04-04T12:14:00-05:00 356.18 12:14
2021-04-04T12:15:00-05:00 334.13 12:15
2021-04-04T12:16:00-05:00 314.72 12:16
2021-04-04T12:17:00-05:00 343.39 12:17
2021-04-04T12:18:00-05:00 397.35 12:18
2021-04-04T12:19:00-05:00 463.51 12:19
2021-04-04T12:20:00-05:00 399.56 12:20
2021-04-04T12:21:00-05:00 422.93 12:21
2021-04-04T12:22:00-05:00 370 12:22
2021-04-04T12:23:00-05:00 332.81 12:23
2021-04-04T12:24:00-05:00 313.55 12:24
2021-04-04T12:25:00-05:00 312.52 12:25
2021-04-04T12:26:00-05:00 334.28 12:26
2021-04-04T12:27:00-05:00 640.53 12:27
2021-04-04T12:28:00-05:00 1424.6 12:28
2021-04-04T12:29:00-05:00 576.72 12:29
2021-04-04T12:30:00-05:00 1440.48 12:30
2021-04-04T12:31:00-05:00 1427.54 12:31
2021-04-04T12:32:00-05:00 1090.71 12:32
2021-04-04T12:33:00-05:00 394.41 12:33
2021-04-04T12:34:00-05:00 382.94 12:34
2021-04-04T12:35:00-05:00 373.83 12:35
2021-04-04T12:36:00-05:00 375.15 12:36
2021-04-04T12:37:00-05:00 303.84 12:37
2021-04-04T12:38:00-05:00 289.44 12:38
2021-04-04T12:39:00-05:00 289.14 12:39
2021-04-04T12:40:00-05:00 306.93 12:40
2021-04-04T12:41:00-05:00 1436.07 12:41
2021-04-04T12:42:00-05:00 1009.7 12:42
2021-04-04T12:43:00-05:00 447.93 12:43
2021-04-04T12:44:00-05:00 492.03 12:44
2021-04-04T12:45:00-05:00 461.16 12:45
2021-04-04T12:46:00-05:00 664.35 12:46
2021-04-04T12:47:00-05:00 1443.86 12:47
2021-04-04T12:48:00-05:00 518.35 12:48
2021-04-04T12:49:00-05:00 1198.33 12:49
2021-04-04T12:50:00-05:00 437.78 12:50
2021-04-04T12:51:00-05:00 391.91 12:51
2021-04-04T12:52:00-05:00 397.06 12:52
2021-04-04T12:53:00-05:00 348.69 12:53
2021-04-04T12:54:00-05:00 1457.24 12:54
2021-04-04T12:55:00-05:00 1444.31 12:55
2021-04-04T12:56:00-05:00 1070.72 12:56
2021-04-04T12:57:00-05:00 1381.67 12:57
2021-04-04T12:58:00-05:00 454.25 12:58
2021-04-04T12:59:00-05:00 1504.14 12:59
2021-04-04T13:00:00-05:00 453.81 13:00
2021-04-04T13:01:00-05:00 378.97 13:01
2021-04-04T13:02:00-05:00 451.46 13:02
2021-04-04T13:03:00-05:00 1200.54 13:03
2021-04-04T13:04:00-05:00 1343.01 13:04
2021-04-04T13:05:00-05:00 724.04 13:05
2021-04-04T13:06:00-05:00 1240.97 13:06
2021-04-04T13:07:00-05:00 431.17 13:07
2021-04-04T13:08:00-05:00 383.09 13:08
2021-04-04T13:09:00-05:00 358.54 13:09
2021-04-04T13:10:00-05:00 335.6 13:10
2021-04-04T13:11:00-05:00 321.93 13:11
2021-04-04T13:12:00-05:00 314.72 13:12
2021-04-04T13:13:00-05:00 330.6 13:13
2021-04-04T13:14:00-05:00 365.01 13:14
2021-04-04T13:15:00-05:00 355.45 13:15
2021-04-04T13:16:00-05:00 382.5 13:16
2021-04-04T13:17:00-05:00 1357.56 13:17
2021-04-04T13:18:00-05:00 817.4 13:18
2021-04-04T13:19:00-05:00 344.42 13:19
2021-04-04T13:20:00-05:00 333.69 13:20
2021-04-04T13:21:00-05:00 388.53 13:21
2021-04-04T13:22:00-05:00 1001.47 13:22
2021-04-04T13:23:00-05:00 755.94 13:23
2021-04-04T13:24:00-05:00 1025.88 13:24
2021-04-04T13:25:00-05:00 594.66 13:25
2021-04-04T13:26:00-05:00 1339.62 13:26
2021-04-04T13:27:00-05:00 1339.18 13:27
2021-04-04T13:28:00-05:00 1023.08 13:28
2021-04-04T13:29:00-05:00 436.46 13:29
2021-04-04T13:30:00-05:00 1303.02 13:30
2021-04-04T13:31:00-05:00 1365.21 13:31
2021-04-04T13:32:00-05:00 1301.99 13:32
2021-04-04T13:33:00-05:00 1279.05 13:33
2021-04-04T13:34:00-05:00 1285.37 13:34
2021-04-04T13:35:00-05:00 681.55 13:35
2021-04-04T13:36:00-05:00 293.85 13:36
2021-04-04T13:37:00-05:00 237.68 13:37
2021-04-04T13:38:00-05:00 234.74 13:38
2021-04-04T13:39:00-05:00 221.8 13:39
2021-04-04T13:40:00-05:00 218.42 13:40
2021-04-04T13:41:00-05:00 228.27 13:41
2021-04-04T13:42:00-05:00 236.21 13:42
2021-04-04T13:43:00-05:00 238.42 13:43
2021-04-04T13:44:00-05:00 240.33 13:44
2021-04-04T13:45:00-05:00 241.65 13:45
2021-04-04T13:46:00-05:00 227.24 13:46
2021-04-04T13:47:00-05:00 228.13 13:47
2021-04-04T13:48:00-05:00 245.62 13:48
2021-04-04T13:49:00-05:00 275.32 13:49
2021-04-04T13:50:00-05:00 350.3 13:50
2021-04-04T13:51:00-05:00 324.43 13:51
2021-04-04T13:52:00-05:00 306.05 13:52
2021-04-04T13:53:00-05:00 301.2 13:53
2021-04-04T13:54:00-05:00 286.49 13:54
2021-04-04T13:55:00-05:00 271.94 13:55
2021-04-04T13:56:00-05:00 258.56 13:56
2021-04-04T13:57:00-05:00 247.83 13:57
2021-04-04T13:58:00-05:00 237.54 13:58
2021-04-04T13:59:00-05:00 224.16 13:59
FORMULA [RADI] VALORES MIN VALORES [RADI]
307,96 12:00 307.96
354,71 12:01 354.71
1496,94 12:02 1496.94
1010,14 12:03 1010.14
337,07 12:04 337.07
349,72 12:05 349.72
342,81 12:06 342.81
1461,21 12:07 1461.21
409,99 12:08 409.99
403,53 12:09 403.53
389,85 12:10 389.85
411,76 12:11 411.76
420,43 12:12 420.43
384,85 12:13 384.85
356,18 12:14 356.18
334,13 12:15 334.13
314,72 12:16 314.72
343,39 12:17 343.39
397,35 12:18 397.35
463,51 12:19 463.51
399,56 12:20 399.56
422,93 12:21 422.93
370 12:22 370
332,81 12:23 332.81
313,55 12:24 313.55
312,52 12:25 312.52
334,28 12:26 334.28
640,53 12:27 640.53
1424,6 12:28 1424.6
576,72 12:29 576.72
1440,48 12:30 1440.48
1427,54 12:31 1427.54
1090,71 12:32 1090.71
394,41 12:33 394.41
382,94 12:34 382.94
373,83 12:35 373.83
375,15 12:36 375.15
303,84 12:37 303.84
289,44 12:38 289.44
289,14 12:39 289.14
306,93 12:40 306.93
1436,07 12:41 1436.07
1009,7 12:42 1009.7
447,93 12:43 447.93
492,03 12:44 492.03
461,16 12:45 461.16
664,35 12:46 664.35
1443,86 12:47 1443.86
518,35 12:48 518.35
1198,33 12:49 1198.33
437,78 12:50 437.78
391,91 12:51 391.91
397,06 12:52 397.06
348,69 12:53 348.69
1457,24 12:54 1457.24
1444,31 12:55 1444.31
1070,72 12:56 1070.72
1381,67 12:57 1381.67
454,25 12:58 454.25
1504,14 12:59 1504.14
453,81 13:00 453.81
378,97 13:01 378.97
451,46 13:02 451.46
1200,54 13:03 1200.54
1343,01 13:04 1343.01
724,04 13:05 724.04
1240,97 13:06 1240.97
431,17 13:07 431.17
383,09 13:08 383.09
358,54 13:09 358.54
335,6 13:10 335.6
321,93 13:11 321.93
314,72 13:12 314.72
330,6 13:13 330.6
365,01 13:14 365.01
355,45 13:15 355.45
382,5 13:16 382.5
1357,56 13:17 1357.56
817,4 13:18 817.4
344,42 13:19 344.42
333,69 13:20 333.69
388,53 13:21 388.53
1001,47 13:22 1001.47
755,94 13:23 755.94
1025,88 13:24 1025.88
594,66 13:25 594.66
1339,62 13:26 1339.62
1339,18 13:27 1339.18
1023,08 13:28 1023.08
436,46 13:29 436.46
1303,02 13:30 1303.02
1365,21 13:31 1365.21
1301,99 13:32 1301.99
1279,05 13:33 1279.05
1285,37 13:34 1285.37
681,55 13:35 681.55
293,85 13:36 293.85
237,68 13:37 237.68
234,74 13:38 234.74
221,8 13:39 221.8
218,42 13:40 218.42
228,27 13:41 228.27
236,21 13:42 236.21
238,42 13:43 238.42
240,33 13:44 240.33
241,65 13:45 241.65
227,24 13:46 227.24
228,13 13:47 228.13
245,62 13:48 245.62
275,32 13:49 275.32
350,3 13:50 350.3
324,43 13:51 324.43
306,05 13:52 306.05
301,2 13:53 301.2
286,49 13:54 286.49
271,94 13:55 271.94
258,56 13:56 258.56
247,83 13:57 247.83
237,54 13:58 237.54
224,16 13:59 224.16
REGLA TRAPECIO SUMA
307.96
709.42
2993.88
2020.28
674.14

1496.94

1461.21
699.44
685.62
2922.42
819.98
807.06
779.7
823.52
840.86

1010.14
769.7
712.36

Radiación (W* min/m^2)


668.26
629.44
686.78
794.7
927.02
799.12
845.86
740

420.43
411.76
409.99
403.53
389.85

384.85
665.62

356.18
354.71

349.72
342.81
337.07

334.13
314.72
627.1
307.96
625.04
668.56
1281.06
2849.2
1153.44
2880.96
2855.08 1 2 :0 0 1 2 :0 3 1 2 :0 6 1 2 :0 9 1 2 :1 2 1 2 :1 5
2181.42
788.82
765.88
747.66
750.3
607.68
578.88
578.28
613.86
1496.94

1461.21

2872.14
2019.4
895.86
984.06
922.32
1010.14
^2)
14
1328.7
2887.72
1036.7

1010.14
2396.66

Radiación (W* min/m^2)


875.56
783.82
794.12
697.38 f(x) = 1.703073390248
2914.48
2888.62 R² = 0.6981171245177
2141.44
2763.34
908.5

420.43
411.76
409.99
403.53
389.85

384.85
3008.28

356.18
354.71

349.72

343.39
342.81
337.07

334.13
314.72
907.62

307.96
757.94
902.92
2401.08
2686.02
1448.08
2481.94 0 20
862.34
766.18
717.08
671.2
643.86
629.44
661.2
730.02
710.9
765
1496.94

2715.12
1634.8 1461.21

688.84
667.38
777.06
2002.94
1511.88
2051.76
1010.14

1189.32
Radiación (W* min/m^2)

2679.24
2678.36
2046.16
872.92
2606.04
2730.42
2603.98
2558.1
f(x) = 589.6426267472
R² = 0.0301624214670
420.43
411.76
409.99
403.53
389.85

384.85
356.18
354.71

349.72

43.39
42.81
37.07

34.13
4.72
7.96
Radiación (
2570.74
f(x) = 589.6426267472
R² = 0.0301624214670

420.43
411.76
409.99
1363.1

403.53
389.85

384.85
356.18
354.71

349.72
587.7

343.39
342.81
337.07

334.13
314.72
307.96
475.36
469.48
443.6
436.84
456.54
472.42
0 20
476.84
480.66
483.3
454.48
456.26
491.24
550.64
700.6
648.86
612.1
602.4
572.98
543.88
517.12
495.66
475.08
448.32
1461.21 1461.21
409.99
403.53
389.85
411.76
420.43
384.85
356.18
334.13
314.72
343.39
397.35
463.51
399.56
422.93
370
332.81
313.55
1424.6 312.52
334.28
1440.48
640.53
1427.54
1090.71 1424.6
576.72
1440.48
1427.54
1090.71
394.41
382.94
373.83
1436.07 375.15
1009.7 303.84
289.44
289.14
306.93
1443.86 1436.07
1009.7
1198.33 447.93
492.03
461.16
664.35
1457.24 1443.86
1444.31 518.35
1070.72 1198.33
1381.67 437.78
391.91
1504.14
397.06
348.69
1457.24
1200.54 1444.31
1343.01 1070.72
1381.67
1240.97
454.25
1504.14
453.81
378.97
451.46
1200.54
6 1 2 :0 9 1 2 :1 2 1 2 :1 5 1 2 :1 8 1 2 :2 1 1 2 :2 4 1 2 :2 7 1 2 :3 0 1 2 :3 3 1 2 :3 6 1 2 :3 9 1 2 :4 2 1 2 :4 5 1 2 :4 8 1 2 :5 1 1 2 :5 4 1 2 :5 7 1 3 :0 0 1 3 :0 3

1343.01
Tiempo de exposición del dia 4 de abril del 2
Medición de la radiación por la EMA en

Medición de la radiación por la EMA en


1461.21 14
409.99 409.99
403.53 403.53
389.85 389.85
411.76 411.76
420.43 420.43
384.85 384.85
356.18 356.18
34.13 334.13
4.72 314.72
43.39 343.39

20
397.35 397.35
463.51 463.51

98117124517713
399.56 399.56

301624214670538
422.93 422.93
370 370
32.81 332.81
3.55 313.55
2.52 312.52
34.28 334.28
640.53 640.53
1424.6 142
576.72 576.72
1440.48 144
1427.54 1427
1090.71 1090.71
394.41 394.41
382.94 382.94
373.83 373.83
375.15 375.15
.84 303.84

40
.44 289.44
.14 289.14
.93 306.93
1436.07 143
1009.7 1009.7
447.93 447.93
492.03 492.03
461.16 461.16
664.35 664.35

89.642626747258 exp( − 0.00307414715137409 x )


1443.86 144
518.35 518.35
1198.33 1198.33
437.78 437.78
391.91 391.91
397.06 397.06
348.69 348.69
1457.24 14
1444.31 144
1070.72 1070.72
1381.67 1381.67
60

454.25 454.25
1504.14
453.81 453.81
378.97 378.97
451.46 451.46
1200.54 1200.54
1343.01 1343.01
724.04 724.04
1240.97 1240.97
431.17 431.17
383.09 383.09
358.54 358.54
35.6 335.6
1.93 321.93
4.72 314.72
30.6 330.6
Tiempo de exposición del dia 4 de abril del

Medición de la radiación por la EMA e

365.01 365.01
70307339024836E-06 x⁵ − 0.000540569135305101 x⁴ + 0.0609354980315396 x³ − 3
409.99
403.53
389.85
411.76
420.43
384.85
356.18
334.13
314.72
343.39

20
397.35
463.51
399.56
301624214670538

422.93
370
332.81
313.55
312.52
334.28
640.53

576.72

394.41
382.94
373.83
375.15
303.84
40

289.44
289.14
306.93

447.93
492.03
461.16
664.35
89.642626747258 exp( − 0.00307414715137409 x )

518.35

437.78
391.91
397.06
348.69
60

454.25

453.81
378.97
451.46

724.

431.17
383.09
358.54
335.6
321.93
314.72
330.6
Tiempo de exposición del dia 4 de abril del

365.01
1200.54 1444.31
1343.01 1070.72
1381.67
1240.97
454.25
1504.14
453.81
378.97
451.46
1200.54
1343.01
724.04
1240.97
1357.56 431.17
383.09
358.54
335.6
1001.47 321.93

ón del dia 4 de abril del 2021 (horas:min)


314.72
1025.88 330.6
365.01
1339.62
1339.18 355.45
1023.08 382.5
1357.56
1303.02 817.4
1365.21 344.42
1301.99
333.69
1279.05
1285.37 388.53
1001.47
or la EMA en el campus de Bogotá

or la EMA en el campus de Bogotá


755.94
1025.88
594.66
1339.62
1339.18
1023.08
436.46
1303.02
1365.21
1301.99
1279.05
1285.37
681.55
293.85
237.68
234.74
221.8
218.42
228.27
236.21
238.42
240.33
241.65
227.24
228.13
245.62
275.32
350.3
324.43
4 1 2 :5 7 1 3 :0 0 1 3 :0 3 1 3 :0 6 1 3 :0 9 1 3 :1 2 1 3 :1 5 1 3 :1 8 1 3 :2 1 1 3 :2 4 1 3 :2 7 1 3 :3 0 1 3 :3 3 1 3 :3 6 1 3 :3 9 1 3 :4 2 1 3 :4 5 1 3 :4 8 1 3 :5 1

306.05
1200.54 1200.54
1343.01 1343.01
724.04 724.04
1240.97 1240.97
431.17 431.17
383.09 383.09
358.54 358.54
35.6 335.6
1.93 321.93
4.72 314.72
30.6 330.6
365.01 365.01
355.45 355.45
382.5 382.5
1357.56 1357.56

80
817.4 817.4
44.42 344.42
33.69 333.69
388.53 388.53
1001.47 1001.47

ón del dia 4 de abril del 2021 (horas:min)


755.94 755.94
1025.88 1025.88
594.66 594.66
1339.62 1339.62
1339.18 1339.18
1023.08 1023.08
436.46 436.46
1303.02 1303.02
1365.21 1365.21
1301.99 1301.99
1279.05 1279.05
1285.37 1285.37
681.55 681.55

or la EMA en el campus de Bogotá


.85 293.85
237.68
234.74

100
221.8
218.42
228.27
236.21
238.42
240.33
241.65
227.24
228.13
245.62
2 275.32
350.3 350.3
80315396 x³ − 3.04270318616202 x² + 70.3278894971765 x

4.43 324.43
.05 306.05
1.2 301.2
49 286.49
4 271.94
258.56
247.83
237.54
120

224.16
724.

431.17
383.09
358.54
335.6
321.93
314.72
330.6
365.01
355.45
382.5

80
344.42
333.69
388.53

ón del dia 4 de abril del 2021 (horas:min)


75

594.66

436.46

681.55
293.85
237.68
234.74
100

221.8
218.42
228.27
236.21
238.42
240.33
241.65
227.24
228.13
245.62
275.32
350.3
324.43
306.05
301.2
286.49
271.94
258.56
247.83
237.54
120

224.16
238.42
240.33
241.65
227.24
228.13
245.62
275.32
350.3
324.43
306.05
301.2
286.49
271.94
258.56
247.83

2 1 3 :4 5 1 3 :4 8 1 3 :5 1 1 3 :5 4 1 3 :5 7
237.54
224.16
224.16

140
224.16

140

You might also like