Consumer Price Index (CPI) and value of dollar relative to foreign currencies

Year_MonthCPIDOLVAL
1973_142.734.0
1973_243.032.6
1973_343.431.6
1973_443.731.8
1973_543.931.6
1973_644.231.1
1973_744.230.6
1973_845.031.0
1973_945.231.1
1973_1045.631.0
1973_1145.931.9
1973_1246.332.3
1974_146.833.3
1974_247.332.8
1974_347.832.3
1974_448.132.0
1974_548.631.8
1974_649.032.1
1974_749.332.4
1974_849.932.8
1974_950.633.0
1974_1051.032.9
1974_1151.532.8
1974_1251.932.8
1975_152.332.7
1975_252.632.4
1975_352.832.3
1975_453.032.8
1975_553.132.9
1975_653.533.0
1975_754.033.9
1975_854.234.5
1975_954.634.8
1975_1054.934.9
1975_1155.334.9
1975_1255.635.1
1976_155.835.1
1976_255.935.1
1976_356.035.4
1976_456.135.6
1976_556.435.7
1976_656.735.8
1976_757.035.7
1976_857.335.7
1976_957.636.1
1976_1057.936.3
1976_1158.136.8
1976_1258.436.8
1977_158.736.8
1977_259.337.0
1977_359.637.1
1977_460.037.0
1977_560.237.0
1977_660.537.0
1977_760.836.8
1977_861.137.0
1977_961.337.2
1977_1061.636.9
1977_1162.036.7
1977_1262.336.2
1978_162.735.9
1978_263.035.9
1978_363.435.7
1978_463.935.7
1978_564.536.0
1978_665.035.5
1978_765.534.8
1978_865.934.2
1978_966.534.3
1978_1067.133.7
1978_1167.534.5
1978_1267.934.7
1979_168.534.7
1979_269.234.9
1979_369.935.0
1979_470.635.3
1979_571.435.6
1979_672.235.6
1979_773.035.0
1979_873.735.2
1979_974.435.3
1979_1075.235.7
1979_1176.036.2
1979_1276.935.9
1980_178.035.9
1980_279.036.2
1980_380.137.1
1980_480.937.4
1980_581.736.3
1980_682.535.7
1980_782.635.7
1980_883.236.1
1980_983.935.9
1980_1084.736.1
1980_1185.636.8
1980_1286.437.1
1981_187.237.1
1981_288.038.0
1981_388.638.3
1981_489.139.0
1981_589.740.1
1981_690.540.9
1981_791.541.8
1981_892.242.5
1981_993.141.8
1981_1093.441.7
1981_1193.841.2
1981_1294.141.4
1982_194.442.1
1982_294.743.6
1982_394.744.8
1982_495.045.3
1982_595.944.9
1982_697.046.8
1982_797.547.5
1982_897.748.7
1982_997.749.1
1982_1098.149.9
1982_1198.050.1
1982_1297.749.3
1983_197.949.3
1983_298.050.1
1983_398.150.8
1983_498.851.5
1983_599.251.7
1983_699.452.7
1983_799.853.3
1983_8100.154.2
1983_9100.454.6
1983_10100.854.4
1983_11101.155.1
1983_12101.456.0
1984_1102.156.7
1984_2102.656.5
1984_3102.956.3
1984_4103.357.0
1984_5103.558.3
1984_6103.759.0
1984_7104.160.8
1984_8104.461.2
1984_9104.762.9
1984_10105.163.8
1984_11105.363.8
1984_12105.565.1
1985_1105.766.5
1985_2106.368.5
1985_3106.869.2
1985_4107.067.8
1985_5107.268.4
1985_6107.568.2
1985_7107.767.0
1985_8107.967.0
1985_9108.167.8
1985_10108.565.4
1985_11109.064.9
1985_12109.565.0
1986_1109.965.0
1986_2109.763.6
1986_3109.162.9
1986_4108.762.7
1986_5109.061.8
1986_6109.462.3
1986_7109.561.5
1986_8109.660.9
1986_9110.061.2
1986_10110.261.5
1986_11110.462.4
1986_12110.862.4
1987_1111.460.8
1987_2111.860.5
1987_3112.260.5
1987_4112.759.7
1987_5113.059.6
1987_6113.560.6
1987_7113.861.6
1987_8114.361.6
1987_9114.760.9
1987_10115.061.0
1987_11115.459.5
1987_12115.658.6
1988_1116.059.1
1988_2116.259.8
1988_3116.559.3
1988_4117.259.0
1988_5117.559.4
1988_6118.060.5
1988_7118.562.2
1988_8119.063.1
1988_9119.563.4
1988_10119.962.3
1988_11120.361.4
1988_12120.761.6
1989_1121.262.9
1989_2121.663.3
1989_3122.264.3
1989_4123.164.8
1989_5123.766.4
1989_6124.168.0
1989_7124.567.4
1989_8124.568.3
1989_9124.869.4
1989_10125.469.0
1989_11125.969.4
1989_12126.369.6
1990_1127.570.1
1990_2128.071.1
1990_3128.673.0
1990_4128.973.4
1990_5129.173.0
1990_6129.973.2
1990_7130.572.1
1990_8131.671.0
1990_9132.570.5
1990_10133.469.3
1990_11133.769.5
1990_12134.270.7
1991_1134.771.1
1991_2134.870.7
1991_3134.873.4
1991_4135.174.6
1991_5135.675.1
1991_6136.076.3
1991_7136.276.4
1991_8136.675.9
1991_9137.075.1
1991_10137.275.1
1991_11137.874.5
1991_12138.274.1
1992_1138.374.4
1992_2138.675.6
1992_3139.177.3
1992_4139.477.4
1992_5139.777.1
1992_6140.176.2
1992_7140.575.3
1992_8140.875.1
1992_9141.175.9
1992_10141.777.5
1992_11142.180.2
1992_12142.380.8
1993_1142.882.0
1993_2143.182.5
1993_3143.382.4
1993_4143.881.5
1993_5144.281.9
1993_6144.382.7
1993_7144.584.1
1993_8144.884.2
1993_9145.084.4
1993_10145.685.5
1993_11146.086.7
1993_12146.387.5
1994_1146.390.4
1994_2146.790.5
1994_3147.191.0
1994_4147.291.7
1994_5147.591.7
1994_6147.992.0
1994_7148.490.8
1994_8149.090.8
1994_9149.390.0
1994_10149.489.5
1994_11149.890.0
1994_12150.192.0
1995_1150.594.1
1995_2150.993.6
1995_3151.292.7
1995_4151.890.1
1995_5152.190.1
1995_6152.490.3
1995_7152.690.3
1995_8152.992.5
1995_9153.193.8
1995_10153.593.7
1995_11153.794.9
1995_12153.995.6
1996_1154.796.5
1996_2155.096.6
1996_3155.596.6
1996_4156.196.9
1996_5156.497.4
1996_6156.797.8
1996_7157.097.7
1996_8157.297.3
1996_9157.797.8
1996_10158.298.2
1996_11158.797.9
1996_12159.198.9
1997_1159.4100.0
1997_2159.7101.9
1997_3159.8102.7
1997_4159.9103.5
1997_5159.9102.4
1997_6160.2102.1
1997_7160.4103.3
1997_8160.8105.2
1997_9161.2105.7
1997_10161.5106.3
1997_11161.7108.0
1997_12161.8112.2
1998_1162.0116.0
1998_2162.0114.4
1998_3162.0114.2
1998_4162.2113.9
1998_5162.6114.8
1998_6162.8117.4
1998_7163.2117.7
1998_8163.4119.6
1998_9163.5118.2
1998_10163.9115.1
1998_11164.1115.1
1998_12164.4114.3
1999_1164.7114.5
1999_2164.7116.1
1999_3164.8117.5
1999_4165.9116.9
1999_5166.0116.6
1999_6166.0117.3
1999_7166.7117.3
1999_8167.1116.3
1999_9167.8115.6
1999_10168.1115.1
1999_11168.4115.4
1999_12168.8115.4
2000_1169.3115.2
2000_2170.0116.7
2000_3171.0116.7
2000_4170.9117.3
2000_5171.2119.9
2000_6172.2118.7
2000_7172.7119.0
2000_8172.7119.8
2000_9173.6121.3
2000_10173.9123.0
2000_11174.2123.9
2000_12174.6123.0
2001_1175.6122.9
2001_2176.0123.5
2001_3176.1125.6
2001_4176.4126.5
2001_5177.3126.4
2001_6177.7127.2
2001_7177.4127.7
2001_8177.4125.6
2001_9178.1125.9
2001_10177.6126.8
2001_11177.5127.3
2001_12177.4127.4
2002_1177.7128.9
2002_2178.0129.7
2002_3178.5128.9
2002_4179.3128.6
2002_5179.5127.0
2002_6179.6125.6
2002_7180.0123.8
2002_8180.5125.2
2002_9180.8126.2
2002_10181.2127.1
2002_11181.5125.8
2002_12181.8125.1
2003_1182.6123.6
2003_2183.6123.4
2003_3183.9123.0
2003_4183.2122.0
2003_5182.9118.0
2003_6183.1117.4
2003_7183.7118.6
2003_8184.5119.9
2003_9185.1118.6
2003_10184.9116.2
2003_11185.0116.1
2003_12185.5114.5
2004_1186.3112.6
2004_2186.7113.1
2004_3187.1114.3
2004_4187.4115.1
2004_5188.2116.9
2004_6188.9115.8
2004_7189.1115.0
2004_8189.2115.2
2004_9189.8114.7
2004_10190.8113.1
2004_11191.7110.2
2004_12191.7109.0
2005_1191.6109.6
2005_2192.4109.8
2005_3193.1109.2
2005_4193.7110.1
2005_5193.6110.6
2005_6193.7111.7
2005_7194.9112.1
2005_8196.1110.7
2005_9198.8110.6
2005_10199.1111.6
2005_11198.1112.4
2005_12198.1111.7
2006_1199.3110.2
2006_2199.4110.4
2006_3199.7110.6
2006_4200.7109.8
2006_5201.3107.6
2006_6201.8108.8
2006_7202.9108.6
2006_8203.8107.8
2006_9202.8108.1
2006_10201.9108.4
2006_11202.0107.5
2006_12203.1106.7
2007_1203.4107.7
2007_2204.2107.3
2007_3205.3106.8
2007_4205.9105.4
2007_5206.8104.5
2007_6207.2104.3
2007_7207.6102.9
2007_8207.7103.5
2007_9208.5102.1
2007_10209.2100.1
2007_11210.898.7
2007_12211.499.5
2008_1212.298.6
2008_2212.797.8
2008_3213.495.9
2008_4213.995.5
2008_5215.295.9
2008_6217.596.1
2008_7219.095.4
2008_8218.797.9
2008_9218.9100.3
2008_10217.0107.0
2008_11213.2109.6
2008_12211.4108.5
2009_1211.9109.2
2009_2212.7111.9
2009_3212.5112.3
2009_4212.7109.6
2009_5213.0106.4
2009_6214.8105.0
2009_7214.7104.7
2009_8215.4103.4
2009_9215.9102.6
2009_10216.5101.1
2009_11217.2100.7
2009_12217.3101.1
2010_1217.5101.4
2010_2217.3102.9
2010_3217.3102.0
2010_4217.4101.5
2010_5217.3104.3
2010_6217.3104.9
2010_7217.7103.3
2010_8218.0102.4
2010_9218.3101.4
2010_10219.098.8
2010_11219.599.1
2010_12220.499.8
2011_1221.198.6
2011_2221.897.9
2011_3223.096.9
2011_4224.195.3
2011_5224.995.3
2011_6225.095.3
2011_7225.694.6
2011_8226.195.1
2011_9226.798.0
2011_10226.898.9
2011_11227.199.5
2011_12227.1100.5
2012_1227.799.8
2012_2228.198.1
2012_3228.798.7
2012_4229.299.0
2012_5228.9100.7
2012_6228.8102.2
2012_7228.8101.7
2012_8230.0100.8
2012_9231.199.2
2012_10231.799.0
2012_11231.299.6
2012_12231.199.0
2013_1231.399.0
2013_2232.699.8
2013_3232.1100.7
2013_4231.7100.4
2013_5232.1100.9
2013_6232.9101.7
2013_7233.3102.2
2013_8233.4102.1
2013_9233.7101.9
2013_10233.8100.9
2013_11234.0101.8
2013_12234.6102.0
2014_1234.9103.0
2014_2235.2103.2
original numiv:1dependent variable: DOLVAL Regression results \\ $r^{2}$= 0.79890 \\ ****TEMP: 1/(1-r^2)=4.9727654745132925 \\ %%%$MSE$= 192.9903 \\ %%%$estSE$= 13.8921 \\ \begin{tabular}{rrrr} \\ Independent variable & Coefficient & Standard Error & t statistic \\ CPI & 0.49799 & 0.01126 & 44.21087 \\ Intercept & 8.92682 & 1.71312 & 5.21086 \\ \end{tabular} \\ %%%%incremental r squared: \\ %%%%total r squared = 0.79890 \\ \begin{tabular}{rrrr} \\ Independent variable & Variance & Residual Var. & ratio \\ CPI & 3079.10140 & 3079.10140 & 1.00000 \\ \end{tabular} \\ \begin{tabular}{rrr} \\ Independent variable & MR coeff & SR coeff \\ CPI & 0.49799 & 0.49799 \\ \end{tabular} \\ ========================================== >>>regression: |CPI| numiv=1 rsquared=-6.661338147750939E-16 ========================================== min rvr_index= 1.00000 variable:CPI Variance Inflation factors egin{tabular}{rrr} variable & $r^{2}$ (other i.v.) & VIF \\ \hline CPI & 0.00000 & 0.9999999999999993\\
Click here to return to Business Statistics exercise page