Finance questions + paragraph

profileBaj.f
3m_analysis_fin_421.xlsx
Home>Business & Finance homework help>Finance questions + paragraph

Data

Date 3M Co. S&P 500 ROR-3M Co. ROR-S&P 500
10/3/16 $ 171.27 $ 2,151.33 -33.77% -9.38%
9/1/16 $ 176.23 $ 2,168.27 -20.15% -1.48%
8/1/16 $ 179.24 $ 2,170.95 5.92% -1.46%
7/1/16 $ 178.36 $ 2,173.60 22.20% 42.73%
6/1/16 $ 175.12 $ 2,098.86 48.48% 1.09%
5/2/16 $ 168.32 $ 2,096.95 6.74% 18.39%
4/1/16 $ 167.38 $ 2,065.30 5.40% 3.24%
3/1/16 $ 166.63 $ 2,059.74 74.66% 79.19%
2/1/16 $ 156.87 $ 1,932.23 46.65% -4.95%
1/4/16 $ 151.00 $ 1,940.24 2.87% -60.88%
12/1/15 $ 150.64 $ 2,043.94 -45.52% -21.04%
11/2/15 $ 156.58 $ 2,080.41 -4.81% 0.61%
10/1/15 $ 157.21 $ 2,079.36 130.69% 99.58%
9/1/15 $ 141.77 $ 1,920.03 -3.12% -31.73%
8/3/15 $ 142.14 $ 1,972.18 -72.95% -75.10%
7/1/15 $ 151.34 $ 2,103.84 -23.02% 23.69%
6/1/15 $ 154.30 $ 2,063.11 -36.06% -25.21%
5/1/15 $ 159.08 $ 2,107.39 20.64% 12.59%
4/1/15 $ 156.39 $ 2,085.51 -62.27% 10.22%
3/2/15 $ 164.95 $ 2,067.89 -26.33% -20.88%
2/2/15 $ 168.65 $ 2,104.50 46.95% 65.87%
1/2/15 $ 162.30 $ 1,994.99 -14.75% -37.25%
12/1/14 $ 164.32 $ 2,058.90 31.71% -5.03%
11/3/14 $ 160.09 $ 2,067.56 49.32% 29.44%
10/1/14 $ 153.77 $ 2,018.05 102.40% 27.84%
9/2/14 $ 141.68 $ 1,972.29 -19.33% -18.62%
8/1/14 $ 144.00 $ 2,003.37 26.49% 45.19%
7/1/14 $ 140.89 $ 1,930.67 -19.69% -18.10%
6/2/14 $ 143.24 $ 1,960.23 5.81% 22.87%
5/1/14 $ 142.55 $ 1,923.57 29.85% 25.24%
4/1/14 $ 139.09 $ 1,883.95 30.34% 7.44%
3/3/14 $ 135.66 $ 1,872.34 8.28% 8.32%
2/3/14 $ 134.73 $ 1,859.45 61.22% 51.74%
1/2/14 $ 128.19 $ 1,782.59 -103.19% -42.70%
12/2/13 $ 140.25 $ 1,848.36 60.58% 28.28%
11/1/13 $ 133.51 $ 1,805.81 73.04% 33.66%
10/1/13 $ 125.85 $ 1,756.54 64.72% 53.51%
9/3/13 $ 119.41 $ 1,681.55 61.60% 35.70%
8/1/13 $ 113.58 $ 1,632.97 -39.34% -37.56%
7/1/13 $ 117.43 $ 1,685.73 88.67% 59.35%
6/3/13 $ 109.35 $ 1,606.28 -10.01% -18.00%
5/1/13 $ 110.27 $ 1,630.74 63.72% 24.92%
4/1/13 $ 104.71 $ 1,597.57 -18.06% 21.70%
3/1/13 $ 106.31 $ 1,569.19 26.65% 43.19%
2/1/13 $ 104.00 $ 1,514.68 41.17% 13.27%
1/2/13 $ 100.55 $ 1,498.11 99.52% 60.51%
12/3/12 $ 92.85 $ 1,426.19 25.07% 8.48%
11/1/12 $ 90.95 $ 1,416.18 45.89% 3.42%
10/1/12 $ 87.60 $ 1,412.16 -62.58% -23.75%
9/4/12 $ 92.42 $ 1,440.67 -2.33% 29.08%
8/1/12 $ 92.60 $ 1,406.58 18.02% 23.72%
7/2/12 $ 91.23 $ 1,379.32 21.83% 15.12%
6/1/12 $ 89.60 $ 1,362.16 73.78% 47.47%
5/1/12 $ 84.41 $ 1,310.33 -66.47% -75.18%
4/2/12 $ 89.36 $ 1,397.91 2.02% -9.00%
3/1/12 $ 89.21 $ 1,408.47 22.05% 37.60%
2/1/12 $ 87.60 $ 1,365.68 12.32% 48.71%
1/3/12 $ 86.71 $ 1,312.41 73.12% 52.30%
12/1/11 $ 81.73 $ 1,257.60 10.22% 10.24%
11/1/11 $ 81.04 $ 1,246.96 30.68% -6.07%
10/3/11 $ 79.02 $ 1,253.30 120.85% 129.27%
9/1/11 $ 71.79 $ 1,131.42 -161.82% -86.11%
8/1/11 $ 82.98 $ 1,218.89 -57.29% -68.15%
7/1/11 $ 87.14 $ 1,292.28 -97.54% -25.77%
6/1/11 $ 94.85 $ 1,320.64 5.98% -21.91%
5/2/11 $ 94.38 $ 1,345.20 -34.93% -16.20%
4/1/11 $ 97.21 $ 1,363.61 47.61% 34.19%
3/1/11 $ 93.50 $ 1,325.83 16.52% -1.26%
2/1/11 $ 92.23 $ 1,327.22 58.83% 38.35%
1/3/11 $ 87.92 $ 1,286.12 22.53% 27.17%
12/1/10 $ 86.30 $ 1,257.64 33.15% 78.36%
11/1/10 $ 83.98 $ 1,180.55 -3.42% -2.75%
10/1/10 $ 84.22 $ 1,183.26 -34.46% 44.23%
9/1/10 $ 86.71 $ 1,141.20 124.66% 105.06%
8/2/10 $ 78.55 $ 1,049.33 -98.06% -56.94%
7/1/10 $ 85.54 $ 1,101.60 99.51% 82.53%
6/1/10 $ 78.99 $ 1,030.71 -4.84% -64.66%
5/3/10 $ 79.31 $ 1,089.41 -126.67% -98.37%
4/1/10 $ 88.67 $ 1,186.69 73.23% 17.71%
3/1/10 $ 83.57 $ 1,169.43 51.20% 70.56%
2/1/10 $ 80.15 $ 1,104.49 -5.07% 34.22%
1/4/10 $ 80.49 $ 1,073.87 -31.64% -44.37%
12/1/09 $ 82.67 $ 1,115.10 81.04% 21.32%
11/2/09 $ 77.44 $ 1,095.63 63.12% 68.84%
10/1/09 $ 73.57 $ 1,036.19 -3.74% -23.71%
9/1/09 $ 73.80 $ 1,057.08 28.29% 42.87%
8/3/09 $ 72.10 $ 1,020.62 26.89% 40.27%
7/1/09 $ 70.52 $ 987.48 208.05% 88.97%
6/1/09 $ 60.10 $ 919.32 63.05% 0.23%
5/1/09 $ 57.10 $ 919.14 -10.42% 63.70%
4/1/09 $ 57.60 $ 872.81 190.18% 112.71%
3/2/09 $ 49.72 $ 797.87 112.45% 102.49%
2/2/09 $ 45.46 $ 735.09 -185.83% -131.92%
1/2/09 $ 53.79 $ 825.88 -78.21% -102.79%
12/1/08 $ 57.54 $ 903.25 -168.35% 9.39%
11/3/08 $ 66.93 $ 896.24 49.08% -89.82%
10/1/08 $ 64.30 $ 968.75 -70.44% -203.31%
9/2/08 $ 68.31 $ 1,166.36 -55.14% -108.95%
8/1/08 $ 71.60 $ 1,282.83 20.63% 14.63%
7/1/08 $ 70.39 $ 1,267.38 13.80% -11.83%
6/2/08 $ 69.59 $ 1,280.00 -123.31% -103.15%
5/1/08 $ 77.56 $ 1,400.38 10.30% 12.81%
4/1/08 $ 76.90 $ 1,385.59 -34.11% 57.06%
3/3/08 $ 79.15 $ 1,322.70 11.48% -7.15%
2/1/08 $ 78.40 $ 1,330.63 -18.83% -41.71%
1/2/08 $ 79.65 $ 1,378.55 -66.46% -73.40%
12/3/07 $ 84.32 $ 1,468.36 15.28% -10.35%
11/1/07 $ 83.26 $ 1,481.14 -43.08% -52.85%
10/1/07 $ 86.36 $ 1,549.38 -92.58% 17.79%
9/4/07 $ 93.58 $ 1,526.75 34.16% 42.95%
8/1/07 $ 90.99 $ 1,473.99 27.94% 15.44%
7/2/07 $ 88.92 $ 1,455.27 29.45% -38.38%
6/1/07 $ 86.79 $ 1,503.35 -15.96% -21.38%
5/1/07 $ 87.96 $ 1,530.62 75.24% 39.06%
4/2/07 $ 82.77 $ 1,482.37 99.54% 51.95%
3/1/07 $ 76.43 $ 1,420.86 38.07% 11.98%
2/1/07 $ 74.08 $ 1,406.82 -3.55% -26.22%
1/3/07 $ 74.30 $ 1,438.24 -55.90% 16.87%
12/1/06 $ 77.93 $ 1,418.30 -52.00% 15.14%
11/1/06 $ 81.46 $ 1,400.63 39.88% 19.76%
10/25/06 $ 78.84 $ 1,377.94

Correlation

Column 1 Column 2
Column 1 1
Column 2 0.734095448 1
correlation eh do ror dos 2

Descriptive Stats 3M

3M Co.
Mean 9.55%
Standard Error 0.0595243259
Median 0.130560214
Mode ERROR:#N/A
Standard Deviation 65.21%
Sample Variance 0.4251774455
Kurtosis 1.1760584632
Skewness -0.2116110514
Range 3.9388707082
Minimum -1.8583383927
Maximum 2.0805323155
Sum 11.4582413146
Count 120
pega so coluna do ror, faz o mesmo pro sp

Descriptive Stats S&P

S&P 500
Mean 5.64%
Standard Error 0.0482068858
Median 0.1228281917
Mode ERROR:#N/A
Standard Deviation 52.81%
Sample Variance 0.278868461
Kurtosis 1.6363422709
Skewness -0.7103063666
Range 3.3257707476
Minimum -2.0330942852
Maximum 1.2926764624
Sum 6.7659640155
Count 120