Question: please fill out the convariance and correlation coefficient table. Please show what formula you have used in excel for each box. DTE RETURN -2.98% 2.96%


DTE RETURN -2.98% 2.96% 2.48% -1.35% -0.37% 6.98% -1.05% 7.77% -0.85% 1.70% 9.31% -0.84% -4.74% 0.83% 3.36% -3.04% 5.82% 0.99% 2.78% 0.72% 3.26% 4.71% -3.41% 1.96% 4.91% -4.42% 4.44% 4.63% TARGET RETURN -4.89% 1.76% -1.88% -6.06% 0.94% -0.26% 8.33% 5.75% -3.38% -13.48% 2.29% 7.89% -6.82% -1.37% 0.07% 12.38% -5.69% -10.73% -8.86% -5.23% 1.20% -1.25% -4.16% 8.38% -3.78% 9.43% 0.05% 1.46% EBAY RETURN -3.59% -9.85% 14.16% 6.06% -7.13% -14.63% 1.45% 0.25% 2.39% 0.12% -4.29% 33.11% 3.21% 2.30% -13.34% -2.46% 6.76% 7.21% 6.50% -0.97% -0.48% 2.66% 1.81% 2.32% 1.12% 6.45% -2.13% -7.89% 4.63% -5.29% -2.73% -4,60% 4.49% 1.84% -2.82% 1.17% 5.70% 2.40% -1.81% 3.80% 6.53% -7.88% 7.60% 4.93% 0.95% 1.46% 10.06% 15.28% 0.25% -7.17% 4.57% 0.40% 5.33% 5.99% 8.45% 1.60% -5.19% -15.15% -6.09% 10.46% -0.49% 11.47% -7.89% 88.85% 7.53% 5.62% -6.11% -5.86% -0.42% -3.87% -7.75% 3.47% -4.59% -12.08% 2.82% -5.96% 19.88% 10.40% 0.35% 1.55% -0.19% 1.92% 0.13% -3.54% 3.91% 8.63% -0.24% 4.33% -7.28% 10.36% 4.28% 2.01% 2.55% -3.54% -1.87% 3.95% 2.94% -15.79% -14.95% 10.46% 3.69% 2.64% 23.89% 0.65% 0.00% 16.93% 3.17% -13.63% -6.99% -9.22% 18.04% 11.47% -2.33% -2.19% -2.92% -9.57% 0.77% 2.06% -7.06% 3.22% -12.82% 32.50% 14.34% 1.33% Covariance DTE TGT EBAY DTE TGT EBAY Correlation coefficient DTE TGT EBAY DTE TGT EBAY
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
