El crecimiento de Yt primer año en el segundo la diferencia de la diferencia OFFSET
Enviado por Juanlauraanahi • 19 de Marzo de 2015 • Informe • 234 Palabras (1 Páginas) • 187 Visitas
Año Ganancia Yt 1er Diferencia 2da Diferencia DESFASE COEFICIENTE DE AUTOCORRELACION DESFASE COEFICIENTE DE AUTOCORRELACION DESFASE COEFICIENTE DE AUTOCORRELACION
1955 3,307 1 -0.561862354 1 -0.08214183 1 0.957322012
1956 3,556 249 2 -0.065699771 2 0.050142633 2 0.915919872
1957 3,601 45 -204 3 0.256070197 3 0.324999116 3 0.870327365
1958 3,721 120 75 4 -0.099783484 4 0.051342364 4 0.810475616
1959 4,036 315 195 5 -0.031952917 5 -0.006329432 5 0.750322721
1960 4,134 98 -217 6 -0.037355579 6 -0.03232636 6 0.692166522
1961 4,268 134 36 7 0.104341503 7 0.060488646 7 0.611866882
1962 4,578 310 176 8 -0.062484093 8 -0.080592341 8 0.530835643
1963 5,093 515 205 9 -0.030321028 9 -0.09203991 9 0.449108524
1964 5,716 623 108 10 0.044934151 10 -0.027916459 10 0.363432696
1965 6,357 641 18 11 0.064373034 11 -0.05967612 11 0.277934084
1966 6,769 412 -229 12 -0.159660078 12 -0.22825299 12 0.194558561
1967 7,296 527 115 13 0.054514605 13 -0.054068809 13 0.12145679
1968 8,178 882 355 14 0.149846777 14 0.005885933 14 0.050775389
1969 8,844 666 -216 15 -0.262944881 15 -0.259314563 15 -0.017370933
1970 9,251 407 -259 16 0.156185395 16 0.041641214 16 -0.073724729
1971 10,006 755 348 17 0.025074632 17 0.006868974 17 -0.130904235
1972 10,991 985 230 18 -0.055456194 18 -0.07700488 18 -0.186009621
1973 12,306 1,315 330 19 -0.000378144 19 -0.046642329 19 -0.232020498
1974 13,101 795 -520 20 0.01770735 20 -0.016504253 20 -0.274002726
1975 13,639 538 -257 21 0.005719737 21 -0.014866178 21 -0.313868963
1976 14,950 1,311 773 22 -0.014441144 22 -0.037831823 22 -0.344424001
1977 17,224 2,274 963 23 0.001418433 23 -0.029228966 23 -0.371981766
1978 17,946 722 -1,552 24 -0.002116296 24 -0.022274235 24 -0.397691177
...