Download - Consumo Café.xlsx

Transcript
Page 1: Consumo Café.xlsx

Consumo de café en Estados Unidos, 1970-1980

"t" "y" "x"

Periodo

1970 2.57 0.771971 2.5 0.741972 2.35 0.721973 2.3 0.731974 2.25 0.761975 2.2 0.751976 2.11 1.081977 1.94 1.811978 1.97 1.391979 2.06 1.21980 2.02 1.17

Fuente: Los datos de Y provienendel Summary of NationalCoffee Drinking Study, DataGroup, Elkins Park, Pensilvania,1981, y los datos sobre Xnominal (es decir, X en precioscorrientes), de Nielsen FoodIndex, A. C. Nielsen, NuevaYork, 1981.

Tazas diarias per cápita

Precio por libra

Page 2: Consumo Café.xlsx

_cons 2.691124 .1216225 22.13 0.000 2.415995 2.966253

x -.479529 .1140218 -4.21 0.002 -.7374642 -.2215939

y Coef. Std. Err. t P>|t| [95% Conf. Interval]

Total .44205446 10 .044205446 Root MSE = .1287

Adj R-squared = 0.6253

Residual .1490797 9 .016564411 R-squared = 0.6628

Model .29297476 1 .29297476 Prob > F = 0.0023

F( 1, 9) = 17.69

Source SS df MS Number of obs = 11

Page 3: Consumo Café.xlsx

_cons 2.691124 .1216225 22.13 0.000 2.415995 2.966253

x -.479529 .1140218 -4.21 0.002 -.7374642 -.2215939

y Coef. Std. Err. t P>|t| [95% Conf. Interval]

Total .44205446 10 .044205446 Root MSE = .1287

Adj R-squared = 0.6253

Residual .1490797 9 .016564411 R-squared = 0.6628

Model .29297476 1 .29297476 Prob > F = 0.0023

F( 1, 9) = 17.69

Source SS df MS Number of obs = 11

Page 4: Consumo Café.xlsx

_cons .7774176 .0152421 51.00 0.000 .7429375 .8118977

lx -.2530461 .049374 -5.13 0.001 -.3647379 -.1413543

ly Coef. Std. Err. t P>|t| [95% Conf. Interval]

Total .088687496 10 .00886875 Root MSE = .05015

Adj R-squared = 0.7164

Residual .02263302 9 .00251478 R-squared = 0.7448

Model .066054476 1 .066054476 Prob > F = 0.0006

F( 1, 9) = 26.27

Source SS df MS Number of obs = 11

Page 5: Consumo Café.xlsx

_cons .7774176 .0152421 51.00 0.000 .7429375 .8118977

lx -.2530461 .049374 -5.13 0.001 -.3647379 -.1413543

ly Coef. Std. Err. t P>|t| [95% Conf. Interval]

Total .088687496 10 .00886875 Root MSE = .05015

Adj R-squared = 0.7164

Residual .02263302 9 .00251478 R-squared = 0.7448

Model .066054476 1 .066054476 Prob > F = 0.0006

F( 1, 9) = 26.27

Source SS df MS Number of obs = 11

Page 6: Consumo Café.xlsx

Periodo2000/01 10,158,429 2,237,858 6,167,592 1,224,965 1,963,832 250,4152000/02 10,241,667 2,384,012 6,323,421 1,214,114 1,936,235 212,9252000/03 10,313,099 2,531,640 6,447,181 1,199,933 2,187,930 61,8422000/04 10,442,732 2,670,629 6,745,387 1,227,692 2,127,286 100,8622001/01 10,166,156 2,393,676 6,328,826 1,170,999 1,924,734 111,4742001/02 10,184,473 2,490,199 6,473,671 1,180,567 1,841,615 160,3262001/03 10,205,865 2,385,773 6,540,893 1,165,430 2,112,800 17,2832001/04 10,350,236 2,495,184 6,857,460 1,197,212 2,065,087 92,2622002/01 9,937,775 2,254,010 6,346,594 1,165,332 1,867,906 116,5862002/02 10,330,191 2,570,750 6,671,344 1,165,898 1,939,393 182,6592002/03 10,238,402 2,554,883 6,651,734 1,149,209 2,100,378 73,8132002/04 10,454,325 2,652,656 6,896,498 1,177,661 2,078,929 90,6832003/01 10,254,207 2,385,948 6,467,847 1,160,624 2,007,224 241,2392003/02 10,371,648 2,543,041 6,610,149 1,173,911 1,994,270 159,3942003/03 10,279,764 2,590,141 6,702,423 1,125,755 2,104,022 -15,4332003/04 10,637,808 2,753,370 7,080,047 1,172,503 2,117,930 133,9452004/01 10,684,338 2,569,641 6,796,784 1,176,713 2,132,912 149,5452004/02 10,799,644 2,791,525 6,913,723 1,196,397 2,150,022 248,5952004/03 10,703,823 2,827,873 7,112,723 1,156,607 2,230,467 94,5262004/04 11,140,211 3,080,915 7,532,313 1,213,719 2,328,540 156,1702005/01 10,842,388 2,705,895 7,058,499 1,197,943 2,212,085 137,4362005/02 11,179,683 3,000,902 7,302,926 1,220,326 2,278,412 171,4082005/03 11,067,885 3,057,452 7,409,928 1,204,361 2,365,301 8,4582005/04 11,552,014 3,374,546 7,831,669 1,265,395 2,508,181 113,9052006/01 11,468,506 3,098,917 7,466,661 1,269,209 2,414,424 146,1632006/02 11,724,725 3,356,095 7,696,736 1,278,916 2,464,438 324,1382006/03 11,665,772 3,394,620 7,822,650 1,230,249 2,595,063 93,8822006/04 12,015,684 3,526,421 8,249,812 1,275,750 2,703,636 137,9992007/01 11,803,386 3,220,434 7,743,659 1,267,167 2,520,864 101,7152007/02 12,047,121 3,541,011 7,929,225 1,296,269 2,581,325 229,6962007/03 12,034,406 3,634,247 8,042,372 1,274,961 2,729,905 29,6372007/04 12,465,495 3,773,329 8,469,548 1,339,696 2,955,249 134,4682008/01 12,057,761 3,466,553 8,000,373 1,296,848 2,669,378 105,4002008/02 12,418,263 3,796,961 8,222,048 1,344,471 2,857,642 300,2362008/03 12,225,329 3,938,853 8,254,145 1,312,784 2,904,138 56,5582008/04 12,326,102 3,590,642 8,318,773 1,381,124 2,890,522 196,6202009/01 11,427,108 2,747,291 7,367,933 1,356,621 2,478,207 12,3342009/02 11,432,390 2,813,175 7,384,443 1,360,205 2,476,035 69,4252009/03 11,666,168 3,181,611 7,716,762 1,341,704 2,576,350 -33,7002009/04 12,197,332 3,449,247 8,208,163 1,396,653 2,741,818 63,0462010/01 11,849,742 3,297,382 7,710,605 1,367,806 2,409,663 67,8932010/02 12,203,014 3,640,842 7,929,859 1,393,529 2,524,863 221,5182010/03 12,300,786 3,812,397 8,133,087 1,365,670 2,633,674 6,7552010/04 12,757,093 3,935,164 8,642,127 1,421,507 2,835,090 153,5782011/01 12,377,541 3,567,692 8,076,011 1,398,565 2,590,905 -32,597

Unidad de medida: Millones de pesos a precios de 2008, Periodicidad: TrimestralProducto interno bruto r1/ p1/Importación de bienes y servicios r1/p1/Consumo privado r1/p1/Consumo de gobiernor1/ p1/Formación bruta de capital fijor1/ p1/Variación de existenciasr1/ p1/

Page 7: Consumo Café.xlsx

2011/02 12,597,518 3,970,178 8,262,132 1,401,756 2,718,489 128,3842011/03 12,814,036 4,181,333 8,637,049 1,403,553 2,861,752 36,3432011/04 13,307,876 4,148,766 8,997,559 1,480,504 3,045,470 92,4602012/01 12,976,161 3,862,050 8,680,592 1,459,903 2,748,454 19,9002012/02 13,161,692 4,176,769 8,657,166 1,465,022 2,859,805 234,0502012/03 13,225,488 4,270,890 8,930,699 1,441,892 2,985,344 -22,3212012/04 13,781,276 4,425,642 9,378,934 1,515,447 3,159,166 128,3412013/01 13,108,936 3,894,845 8,830,596 1,467,372 2,732,769 -15,0302013/02 13,399,229 4,383,813 8,968,914 1,471,213 2,890,406 165,5312013/03 13,437,797 4,418,406 9,156,989 1,475,850 2,882,115 2,4452013/04 13,937,805 4,457,533 9,467,826 1,547,702 3,063,791 144,9012014/01 13,361,700 4,096,457 8,973,938 1,509,505 2,717,898 111,4882014/02 13,616,281 4,536,836 9,083,094 1,499,647 2,872,973 191,6152014/03 13,727,122 4,664,717 9,357,888 1,522,339 3,004,741 43,666

Cifras preliminares:

Cifras revisadas:p1/ A partir de 2014/03

r1/ A partir de 2011/01Fuente: INEGI. Sistema de Cuentas Nacionales de México.

Page 8: Consumo Café.xlsx

2,579,1882,713,8452,736,6792,797,2752,626,1692,637,8572,554,5952,640,6982,526,7812,707,0282,701,5272,739,0952,549,4872,617,4302,718,5002,883,7272,782,8002,980,2552,966,4663,023,1082,885,6253,165,3363,051,4473,321,7233,279,0933,398,8703,280,5433,418,3553,240,4043,467,4183,525,9923,630,8573,354,8233,559,9033,473,3483,289,6942,837,1782,837,5802,999,3363,392,2213,287,3693,615,0093,718,2463,924,9033,698,564

Exportación de bienes y servicios r1/p1/

Page 9: Consumo Café.xlsx

3,898,2183,945,4284,198,3543,966,2894,272,4644,100,5844,320,3553,845,5284,346,1004,310,2284,529,2864,091,8514,565,1724,615,559


Top Related