Question: How would I be able to chart this in excel? 199310 199311 199312 199401 199402 199403 199404 199405 199406 199407 199408 199409 199410 199411 199412

How would I be able to chart this in excel?How would I be able to chart this in excel? 199310 199311199312 199401 199402 199403 199404 199405 199406 199407 199408 199409 199410 199411

199310 199311 199312 199401 199402 199403 199404 199405 199406 199407 199408 199409 199410 199411 199412 199501 199502 199503 199504 199505 199506 199507 199508 199509 199510 199511 199512 199601 199602 199603 199604 199605 199606 199607 199608 199609 199610 199611 199612 199701 1.96% -1.52% 1.95% 3.15% -2.36% -4.41% 0.93% 1.03% -2.81% 3.04% 4.38% -1.69% 1.52% -3.67% 1.33% 1.80% 4.07% 2.72% 2.63% 3.49% 2.98% 4.08% 0.89% 3.66% -1.05% 4.27% 1.54% 2.78% 1.69% 1.22% 2.42% 2.57% -0.59% -5.25% 3.27% 5.32% 1.81% 6.75% -1.19% 5.50% -2.34% -15.98% 2.22% 17.06% 4.08% -1.97% 3.57% 1.54% 6.33% -3.80% 0.09% -2.85% 2.59% -6.16% 2.05% -6.44% -5.25% 9.08% 4.10% -6.23% -4.16% 6.31% -2.67% -1.16% -3.92% 4.52% 4.90% -1.26% -1.47% 3.01% 6.84% -4.48% 0.35% -4.70% -4.30% 2.85% -6.88% 0.64% -7.06% -10.75% 15.95% -2.18% 20.28% 1.32% -6.21% -9.72% 2.48% 4.48% -6.07% 5.02% 3.99% -2.16% 1.42% -7.85% -0.86% -7.17% 6.19% 0.92% 1.56% 4.58% -1.84% 5.24% -1.08% 2.13% -0.31% 1.22% 3.26% 8.54% 0.76% -0.54% 2.04% 1.09% -1.72% -4.96% 4.24% 2.72% 2.64% 6.83% -0.12% -1.64% 2.66% -2.01% 7.20% 6.28% -3.23% -2.28% 4.02% -3.70% -0.84% 4.93% 2.33% -3.23% 4.02% -4.14% 0.52% -1.07% 2.38% 3.90% 3.00% 2.28% 1.51% 4.48% -3.57% 2.79% -0.23% 0.19% 2.37% 0.98% 2.30% 1.36% 1.11% 1.96% 0.68% -1.38% 2.65% 1.55% 1.94% 4.47% 2.49% 0.06% 1.33% -6.06% 4.23% 7.61% -0.90% -3.37% 2.62% 0.11% 0.47% 1.35% 2.47% -2.48% 2.49% -4.77% 1.23% -1.92% 0.97% 4.72% 3.11% 0.38% 0.40% 4.82% -1.36% 2.10% -1.52% 3.07% 2.68% 1.52% 1.01% 1.62% 3.16% 0.51% -0.08% -4.07% 1.33% 3.59% -0.07% 4.83% -1.31% 0.47% 0.22% 0.25% 0.23% 0.25% 0.21% 0.27% 0.27% 0.32% 0.31% 0.28% 0.37% 0.37% 0.38% 0.37% 0.44% 0.42% 0.40% 0.46% 0.44% 0.54% 0.47% 0.45% 0.47% 0.43% 0.47% 0.42% 0.49% 0.43% 0.39% 0.39% 0.46% 0.42% 0.40% 0.45% 0.41% 0.44% 0.42% 0.41% 0.46% 0.45% On a single chart, plot the value of $1 invested in each of the five indexes over time. I.e., for all t, plot the cumulative return series for each index: TV = (1 + r)(1+r2)... (1+r) What patterns do you observe? 199310 199311 199312 199401 199402 199403 199404 199405 199406 199407 199408 199409 199410 199411 199412 199501 199502 199503 199504 199505 199506 199507 199508 199509 199510 199511 199512 199601 199602 199603 199604 199605 199606 199607 199608 199609 199610 199611 199612 199701 1.96% -1.52% 1.95% 3.15% -2.36% -4.41% 0.93% 1.03% -2.81% 3.04% 4.38% -1.69% 1.52% -3.67% 1.33% 1.80% 4.07% 2.72% 2.63% 3.49% 2.98% 4.08% 0.89% 3.66% -1.05% 4.27% 1.54% 2.78% 1.69% 1.22% 2.42% 2.57% -0.59% -5.25% 3.27% 5.32% 1.81% 6.75% -1.19% 5.50% -2.34% -15.98% 2.22% 17.06% 4.08% -1.97% 3.57% 1.54% 6.33% -3.80% 0.09% -2.85% 2.59% -6.16% 2.05% -6.44% -5.25% 9.08% 4.10% -6.23% -4.16% 6.31% -2.67% -1.16% -3.92% 4.52% 4.90% -1.26% -1.47% 3.01% 6.84% -4.48% 0.35% -4.70% -4.30% 2.85% -6.88% 0.64% -7.06% -10.75% 15.95% -2.18% 20.28% 1.32% -6.21% -9.72% 2.48% 4.48% -6.07% 5.02% 3.99% -2.16% 1.42% -7.85% -0.86% -7.17% 6.19% 0.92% 1.56% 4.58% -1.84% 5.24% -1.08% 2.13% -0.31% 1.22% 3.26% 8.54% 0.76% -0.54% 2.04% 1.09% -1.72% -4.96% 4.24% 2.72% 2.64% 6.83% -0.12% -1.64% 2.66% -2.01% 7.20% 6.28% -3.23% -2.28% 4.02% -3.70% -0.84% 4.93% 2.33% -3.23% 4.02% -4.14% 0.52% -1.07% 2.38% 3.90% 3.00% 2.28% 1.51% 4.48% -3.57% 2.79% -0.23% 0.19% 2.37% 0.98% 2.30% 1.36% 1.11% 1.96% 0.68% -1.38% 2.65% 1.55% 1.94% 4.47% 2.49% 0.06% 1.33% -6.06% 4.23% 7.61% -0.90% -3.37% 2.62% 0.11% 0.47% 1.35% 2.47% -2.48% 2.49% -4.77% 1.23% -1.92% 0.97% 4.72% 3.11% 0.38% 0.40% 4.82% -1.36% 2.10% -1.52% 3.07% 2.68% 1.52% 1.01% 1.62% 3.16% 0.51% -0.08% -4.07% 1.33% 3.59% -0.07% 4.83% -1.31% 0.47% 0.22% 0.25% 0.23% 0.25% 0.21% 0.27% 0.27% 0.32% 0.31% 0.28% 0.37% 0.37% 0.38% 0.37% 0.44% 0.42% 0.40% 0.46% 0.44% 0.54% 0.47% 0.45% 0.47% 0.43% 0.47% 0.42% 0.49% 0.43% 0.39% 0.39% 0.46% 0.42% 0.40% 0.45% 0.41% 0.44% 0.42% 0.41% 0.46% 0.45% On a single chart, plot the value of $1 invested in each of the five indexes over time. I.e., for all t, plot the cumulative return series for each index: TV = (1 + r)(1+r2)... (1+r) What patterns do you observe

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!