***Dataset is located below the prompt* The data contains the monthly return for VTI (an Exchange Traded Fund that track
Posted: Tue Jan 18, 2022 12:58 pm
***Dataset is located below the
prompt*
The data contains the monthly
return for VTI (an Exchange Traded Fund that tracks the U.S equity
market) and the CPI index (taken from bls.gov; Series ID:
CUUR0000SA0) for the 60-month (5 years) period ending
12/31/15. Compute monthly inflation using CPI index will
be
Do the following for VTI.
VTI RE 1 year-month 2 Dec-10 3 Jan-11 4 Feb-11 5 Mar-11 6 Apr-11 7 May-11 8 Jun-11 9 Jul-11 10 Aug-11 11 Sep-11 12 Oct-11 13 Nov-11 14 Dec-11 15 Jan-12 16 Feb-12 17 Mar-12 18 Apr-12 19 May-12 20 Jun-12 21 Jul 12 22 Aug-12 23 Sep-12 24 Oct-12 25 Nov-12 26 Dec-12 27 Jan-13 28 Feb-13 29 Mar-13 30 Apr-13 31 May-13 32 Jun-13 33 Jul-13 34 Aug-13 35 Sep-13 36 Oct-13 37 Nov-13 38 Dec-13 39 Jan-14 40 Feb-14 41 Mar-14 42 Apr-14 43 May 14 44 Jun-14 45 Jul-14 46 Aug-14 47 Sep-14 48 Oct-14 49 Nov-14 50 Dec-14 51 Jan-15 52 Feb-15 53 Mar-15 54 Apr-15 55 May-15 56 Jun-15 57 Jul-15 58 Aug-15 59 Sep-15 60 Oct-15 61 Nov-15 62 Dec-15 2.05% 3.70% 0.42% 2.89% -1.06% -1.80% -2.26% -6.09% -7.58% 11.36% -0.37% 0.972 5.07% 4.222 3.06% -0.63% -6.22% 4.05% 0.883 2.703 2.49% -1.81% 0.78% 1.29% 5.42% 1.28% 3.95% 1.61% 2.44% -1.43% 5.74% -3.03% 3.902 4.26% 2.71% 2.73% -3.17% 4.87% 0.50% 0.07% 2.10% 2.62% -1.992 4.153 -2.10% 2.75% 2.4% -0.04% -2.74% 5.74% - 1.162 0.62% 1.30% -1.68% 1.70% -6.09% -2.82% 7.91% 0.60% -2.13% 0.008% 0.013% 0.006% 0.003% 0.002% 0.003% 0.001% 0.012% 0.002% 0.001% 0.001% 0.002% 0.001% 0.004% 0.006% 0.004% 0.006% 0.003% 0.004% 0.006% 0.008% 0.0043 0.005% 0.011% 0.002% 0.002% 0.006% 0.005% 0.003% 0.003% 0.001% 0.002% 0.002% 0.0087 0.003% 0.002% 0.0012 0.003% 0.003% 0.002% 0.002% 0.003% 0.003% 0.0012 0.002% 0.001% 0.003% 0.0012 0.003% 0.001% 0.002% 0.002% 0.001% 0.002% 0.0012 0.002% 0.001% 0.0012 0.001% 0.016% CPI Index 219.2 220.2 221.3 223.5 224.9 226.0 225.7 225.9 226.5 226.9 226.4 226.2 225.7 226.7 227.7 229.4 230.1 229.8 229.5 229.1 230.4 231.4 231.3 230.2 229.6 230.3 232.2 232.8 232.5 232.9 233.5 233.6 233.9 234.1 233.5 233.1 233.0 233.9 234.8 236.3 237.1 237.9 238.3 238.3 237.9 238.0 237.4 236.2 234.8 233.7 234.7 236.1 236.6 237.8 238.6 238.7 238.3 237.9 237.8 237.3 236.5
prompt*
The data contains the monthly
return for VTI (an Exchange Traded Fund that tracks the U.S equity
market) and the CPI index (taken from bls.gov; Series ID:
CUUR0000SA0) for the 60-month (5 years) period ending
12/31/15. Compute monthly inflation using CPI index will
be
Do the following for VTI.
VTI RE 1 year-month 2 Dec-10 3 Jan-11 4 Feb-11 5 Mar-11 6 Apr-11 7 May-11 8 Jun-11 9 Jul-11 10 Aug-11 11 Sep-11 12 Oct-11 13 Nov-11 14 Dec-11 15 Jan-12 16 Feb-12 17 Mar-12 18 Apr-12 19 May-12 20 Jun-12 21 Jul 12 22 Aug-12 23 Sep-12 24 Oct-12 25 Nov-12 26 Dec-12 27 Jan-13 28 Feb-13 29 Mar-13 30 Apr-13 31 May-13 32 Jun-13 33 Jul-13 34 Aug-13 35 Sep-13 36 Oct-13 37 Nov-13 38 Dec-13 39 Jan-14 40 Feb-14 41 Mar-14 42 Apr-14 43 May 14 44 Jun-14 45 Jul-14 46 Aug-14 47 Sep-14 48 Oct-14 49 Nov-14 50 Dec-14 51 Jan-15 52 Feb-15 53 Mar-15 54 Apr-15 55 May-15 56 Jun-15 57 Jul-15 58 Aug-15 59 Sep-15 60 Oct-15 61 Nov-15 62 Dec-15 2.05% 3.70% 0.42% 2.89% -1.06% -1.80% -2.26% -6.09% -7.58% 11.36% -0.37% 0.972 5.07% 4.222 3.06% -0.63% -6.22% 4.05% 0.883 2.703 2.49% -1.81% 0.78% 1.29% 5.42% 1.28% 3.95% 1.61% 2.44% -1.43% 5.74% -3.03% 3.902 4.26% 2.71% 2.73% -3.17% 4.87% 0.50% 0.07% 2.10% 2.62% -1.992 4.153 -2.10% 2.75% 2.4% -0.04% -2.74% 5.74% - 1.162 0.62% 1.30% -1.68% 1.70% -6.09% -2.82% 7.91% 0.60% -2.13% 0.008% 0.013% 0.006% 0.003% 0.002% 0.003% 0.001% 0.012% 0.002% 0.001% 0.001% 0.002% 0.001% 0.004% 0.006% 0.004% 0.006% 0.003% 0.004% 0.006% 0.008% 0.0043 0.005% 0.011% 0.002% 0.002% 0.006% 0.005% 0.003% 0.003% 0.001% 0.002% 0.002% 0.0087 0.003% 0.002% 0.0012 0.003% 0.003% 0.002% 0.002% 0.003% 0.003% 0.0012 0.002% 0.001% 0.003% 0.0012 0.003% 0.001% 0.002% 0.002% 0.001% 0.002% 0.0012 0.002% 0.001% 0.0012 0.001% 0.016% CPI Index 219.2 220.2 221.3 223.5 224.9 226.0 225.7 225.9 226.5 226.9 226.4 226.2 225.7 226.7 227.7 229.4 230.1 229.8 229.5 229.1 230.4 231.4 231.3 230.2 229.6 230.3 232.2 232.8 232.5 232.9 233.5 233.6 233.9 234.1 233.5 233.1 233.0 233.9 234.8 236.3 237.1 237.9 238.3 238.3 237.9 238.0 237.4 236.2 234.8 233.7 234.7 236.1 236.6 237.8 238.6 238.7 238.3 237.9 237.8 237.3 236.5