avance de excel

10
MEDICION DE LA INFLACIÓN EN EL PERÚ Mes/Año Jan-10 93.84 0.22% 0.22% 4,80% Feb-10 94.69 0.91% 1.13% 4,82% Mar-10 95.68 1.04% 2.17% 5,55% Apr-10 95.83 0.15% 2.32% 5,52% May-10 96.18 0.37% 2.69% 5,39% Jun-10 96.92 0.77% 3.46% 5,71% Jul-10 97.46 0.56% 4.02% 5,79% Aug-10 98.03 0.59% 4.61% 6,27% Sep-10 98.59 0.57% 5.18% 6,22% Oct-10 99.20 0.61% 5.79% 6,54% Nov-10 99.50 0.31% 6.10% 6,75% Dec-10 99.86 0.36% 6.46% 6.46% Jan-11 99.97 0.11% 0.11% 6.53% Feb-11 99.89 -0.07% 0.03% 5.49% Mar-11 100.25 0.36% 0.39% 4.78% Apr-11 100.27 0.02% 0.41% 4.64% May-11 100.23 -0.04% 0.37% 4.21% Jun-11 99.89 -0.34% 0.03% 3.06% Jul-11 100.07 0.19% 0.21% 2.68% Aug-11 99.87 -0.21% 0.01% 1.87% Sep-11 99.78 -0.09% -0.08% 1.20% Oct-11 99.90 0.12% 0.04% 0.71% Nov-11 99.79 -0.11% -0.07% 0.29% Dec-11 100.10 0.32% 0.25% 0.25% Jan-12 100.40 0.30% 0.30% 0.44% Feb-12 100.73 0.32% 0.62% 0.84% Mar-12 101.01 0.28% 0.90% 0.76% Apr-12 101.03 0.03% 0.92% 0.76% May-12 101.27 0.24% 1.16% 1.04% Jun-12 101.53 0.25% 1.41% 1.64% Jul-12 101.90 0.36% 1.78% 1.82% Econ. Efraín Castillo Q. IPC Lima (2011 = 100) Indice general Inflación Mensual en % Inflación Acumulada en % Inflación Anual % (12 meses) INFLACION DE U INFLACION A INFLACION AN (12 MES SIEMPRE IGUALES ( . . IPC IPC t marzo t abril ( 1 . . IPC IPC t abril t abril ( 1 . . IPC IPC t dic t feb

Upload: migna-isabel-salcedo-vila

Post on 09-Nov-2015

10 views

Category:

Documents


3 download

DESCRIPTION

es un trabajo de alpachaca

TRANSCRIPT

Sheet1MEDICION DE LA INFLACIN EN EL PER

Mes/AoIPC Lima (2011 = 100) Indice generalInflacin Mensual en % Inflacin Acumulada en %Inflacin Anual % (12 meses)Jan-1093.840.22%0.22%4,80%Feb-1094.690.91%1.13%4,82%Mar-1095.681.04%2.17%5,55%Apr-1095.830.15%2.32%5,52%May-1096.180.37%2.69%5,39%Jun-1096.920.77%3.46%5,71%Jul-1097.460.56%4.02%5,79%Aug-1098.030.59%4.61%6,27%Sep-1098.590.57%5.18%6,22%Oct-1099.200.61%5.79%6,54%Nov-1099.500.31%6.10%6,75%Dec-1099.860.36%6.46%6.46%

Jan-1199.970.11%0.11%6.53%Feb-1199.89-0.07%0.03%5.49%Mar-11100.250.36%0.39%4.78%Apr-11100.270.02%0.41%4.64%May-11100.23-0.04%0.37%4.21%Jun-1199.89-0.34%0.03%3.06%Jul-11100.070.19%0.21%2.68%Aug-1199.87-0.21%0.01%1.87%Sep-1199.78-0.09%-0.08%1.20%Oct-1199.900.12%0.04%0.71%Nov-1199.79-0.11%-0.07%0.29%Dec-11100.100.32%0.25%0.25%

Jan-12100.400.30%0.30%0.44%Feb-12100.730.32%0.62%0.84%Mar-12101.010.28%0.90%0.76%Apr-12101.030.03%0.92%0.76%May-12101.270.24%1.16%1.04%Jun-12101.530.25%1.41%1.64%Jul-12101.900.36%1.78%1.82%Econ. Efran Castillo Q.

INFLACION DE UN MESINFLACION ACUMULADA

INFLACION ANUALIZADA (12 MESES)

SIEMPRE IGUALES OKK

Hoja1MEDICION DE LA INFLACIN EN EL PER

Mes/AoIPC Lima (2011 = 100) Indice generalInflacin Anual % (12 meses)Jan-0181.783.85Feb-0181.983.61Mar-0182.403.58Apr-0182.062.63May-0182.082.64Jun-0182.032.51Jul-0182.172.15Aug-0181.921.37Sep-0181.970.87Oct-0182.000.68Nov-0181.600.12Dec-0181.53-0.12

Jan-0281.10-83.15%Feb-0281.07-111.00%Mar-0281.51-108.01%Apr-0282.104.87%May-0282.2115.84%Jun-0282.030.00%Jul-0282.06-13.39%Aug-0282.1426.86%Sep-0282.5368.32%Oct-0283.12136.59%Nov-0282.79145.83%Dec-0282.76150.86%

Jan-0382.95228.11%Feb-0383.34280.00%Mar-0384.27338.61%Apr-0384.23259.44%May-0384.20242.06%Jun-0383.81216.99%Jul-0383.68197.42%Aug-0383.691.8870221573Sep-0384.161.9750393796Oct-0384.21.2993262753Nov-0384.341.8722067883Dec-0384.822.4891251812Jan-0485.272.7968655817Feb-0486.23.431725462Mar-0486.62.7649222736Apr-0486.582.7899798172May-0486.883.1828978622Jun-0487.374.2477031381Jul-0487.544.6128107075Aug-0487.534.5883618114Sep-0487.554.0280418251Oct-0487.533.9548693587Nov-0487.784.0787289542Dec-0487.773.4779533129Jan-0587.863.0374105782Feb-0587.651.6821345708Mar-0588.221.870669746Apr-0588.332.0212520213May-0588.441.7955801105Jun-0588.671.487924917Jul-0588.761.3936486178Aug-0588.61.2224380212Sep-0588.521.107938321Oct-0588.651.2795612933Nov-0588.711.0594668489Dec-0589.081.4925373134Jan-0689.531.9007511951Feb-0690.022.7039361095Mar-0690.432.5051008842Apr-0690.892.8982225744May-0690.412.2274988693Jun-0690.291.826998985Jul-0690.141.5547543939Aug-0690.261.8735891648Sep-0690.291.9995481247Oct-0690.331.8950930626Nov-0690.071.5330853342Dec-0690.091.1338123035Jan-0790.10.6366581034Feb-0790.340.3554765608Mar-0790.650.2432820966Apr-0790.81-0.0880184839May-0791.260.9401614866Jun-0791.691.5505593089Jul-0792.122.196583093Aug-0792.252.2047418569Sep-0792.822.8020821796Oct-0793.113.0776043396Nov-0793.213.4861774176Dec-0793.633.9294039294Jan-0893.844.1509433962Feb-0894.694.8151427939Mar-0895.685.5488141202Apr-0895.835.5280255478May-0896.185.3911900066Jun-0896.925.7040026175Jul-0897.465.7967867998Aug-0898.036.2655826558Sep-0898.596.2163326869Oct-0899.26.5406508431Nov-0899.56.7482029825Dec-0899.866.6538502617Jan-0999.976.5323955669Feb-0999.895.4916041821Mar-09100.254.7763377926Apr-09100.274.6332046332May-09100.234.2108546475Jun-0999.893.0643829963Jul-09100.072.6780217525Aug-0999.871.8769764358Sep-0999.781.2070189674Oct-0999.90.7056451613Nov-0999.790.2914572864Dec-09100.10.2403364711Jan-10100.40.4301290387Feb-10100.730.8409250175Mar-10101.010.7581047382Apr-10101.030.7579535255May-10101.271.037613489Jun-10101.531.6418059866Jul-10101.91.8287198961Aug-10102.172.3029938921Sep-10102.142.3652034476Oct-10101.992.0920920921Nov-101022.2146507666Dec-10102.182.0779220779

INFLACION DE UN MESINFLACION ACUMULADA

INFLACION ANUALIZADA (12 MESES)

SIEMPRE IGUALES OKK

Hoja2a0ipcipc nominal pbi real119907481,7544382032-7658921991409,526686837607,93199273,544953834014199348,6692628737573,55199423,7985779857748,66199511,1120928107064-723,77199611,513708110976011,1819978,515753311729411,5919987,31662821165228,51019993,51744221175877,31120003,81861411210573,512200121892131213173,81320020,219965012740221420032,32134251325450,21520043,72379021391412,31620051,62616531486403,71720062.003022251601451,61820071,83355291744072.001920085,83710731915051,82020092,93823181931555,82120101,54347382101432,92220113,44865452246691,53,4