Planeacion
a. Determine los índices estacionales por hora de las 12 lecturas de cada día
Indices de estacionalidad | 0.73 |
| 0.83 |
| 0.96 |
| 1.39 |
| 1.60 |
| 1.60 |
| 1.24 |
| 1.00 |
| 0.88 |
| 0.63 |
| 0.59 |
| 0.54 |
B)Mediante los índicesestacionales del inciso a, desestacionalice los datos; determine la ecuación de tendencia obtenida para los datos desestacionalizados.
DIA | PERIODO | DR. | |
15-jul | I | 25 | 34.19 |
| II | 28 | 33.86 |
| III | 35 | 36.55 |
| IV | 50 | 35.94 |
| V | 60 | 37.39 |
| VI | 60 | 37.39 |
| VII | 40 | 32.14 |
| VIII | 35 | 34.93 |
| IX | 30 | 34.27 |
| X | 25 | 39.52|
| XI | 25 | 42.50 |
| XII | 20 | 36.90 |
DIA | PERIODO | DR | |
16 DE JULIO | I | 28 | 38.30 |
| II | 30 | 36.28 |
| III | 35 | 36.55 |
| IV | 48 | 34.50 |
| V | 60 | 37.39 |
| VI | 60 | 37.39 |
| VII | 50 | 40.17 |
| VIII | 40 | 39.92 |
| IX | 35 | 39.98 |
| X | 25 | 39.52 |
| XI | 20 | 34.00 |
| XII | 20 | 36.90 |
DIA | PERIODO | DR | |17 DE JULIO | I | 35 | 47.87 |
| II | 42 | 50.79 |
| III | 45 | 47.00 |
| IV | 70 | 50.31 |
| V | 72 | 44.87 |
| VI | 72 | 44.87 |
| VII | 60 | 48.20 |
| VIII | 45 | 44.92 |
| IX | 40 | 45.69 |
| X | 25 | 39.52 |
| XI | 25 | 42.50 |
| XII | 25 | 46.12 |
C) Use la ecuación con componente de tendencia y estacionalidad determineel pronostico para las 12 horas dejulio 18.
x | y | x2 | y2 | xy |
1 | 34.19 | 1.00 | 1168.96 | 34.19 |
2 | 33.86 | 4.00 | 1146.50 | 67.72 |
3 | 36.55 | 9.00 | 1335.90 | 109.65 |
4 | 35.94 | 16.00 | 1291.68 | 143.76 |
5 | 37.39 | 25.00 | 1398.01 | 186.95 |
6 | 37.39 | 36.00 | 1398.01 | 224.34 |
7 | 32.14 | 49.00 | 1032.98 | 224.98 |
8 | 34.93 | 64.00 | 1220.10 | 279.44 |
9 | 34.27 | 81.00 | 1174.43 | 308.43 |10 | 39.52 | 100.00 | 1561.83 | 395.20 |
11 | 42.5 | 121.00 | 1806.25 | 467.50 |
12 | 36.9 | 144.00 | 1361.61 | 442.80 |
13 | 38.30 | 169.00 | 1466.89 | 497.90 |
14 | 36.28 | 196.00 | 1316.24 | 507.92 |
15 | 36.55 | 225.00 | 1335.90 | 548.25 |
16 | 34.50 | 256.00 | 1190.25 | 552.00 |
17 | 37.39 | 289.00 | 1398.01 | 635.63 |
18 | 37.39 | 324.00 | 1398.01 | 673.02 |
19 | 40.17 |361.00 | 1613.63 | 763.23 |
20 | 39.92 | 400.00 | 1593.61 | 798.40 |
21 | 39.98 | 441.00 | 1598.40 | 839.58 |
22 | 39.52 | 484.00 | 1561.83 | 869.44 |
23 | 34.00 | 529.00 | 1156.00 | 782.00 |
24 | 36.90 | 576.00 | 1361.61 | 885.60 |
25 | 47.87 | 625.00 | 2291.54 | 1196.75 |
26 | 50.79 | 676.00 | 2579.62 | 1320.54 |
27 | 47.00 | 729.00 | 2209.00 | 1269.00 |
28 | 50.31 | 784.00 |2531.10 | 1408.68 |
29 | 44.87 | 841.00 | 2013.32 | 1301.23 |
30 | 44.87 | 900.00 | 2013.32 | 1346.10 |
31 | 48.20 | 961.00 | 2323.24 | 1494.20 |
32 | 44.92 | 1024.00 | 2017.81 | 1437.44 |
33 | 45.69 | 1089.00 | 2087.58 | 1507.77 |
34 | 39.52 | 1156.00 | 1561.83 | 1343.68 |
35 | 42.50 | 1225.00 | 1806.25 | 1487.50 |
36 | 46.12 | 1296.00 | 2127.05 | 1660.32 |
666 | 1439.14 |16206.00 | 58448.30 | 28011.14 |
SCX | 3885 |
SCY | 917.08 |
SCXY | 1387.05 |
B | 0.36 |
A | 33.32 |
Y | 33.68 |
18 DE JULIO | 46.64 |
| 47 |
| 47.36 |
| 47.72 |
| 48.08 |
| 48.44 |
| 48.8 |
| 49.16 |
| 49.52 |
| 49.88 |
| 50.24 |
| 50.6 |
5.- Se realiza un estudio sobre la cantidad de azúcar transformada en cierto proceso a varias temperaturas....
Regístrate para leer el documento completo.