Business work urgent with in 1 hours
paredanMarketDataSeriesquestions.xlsx
Sheet1
| Date | US 1M Yield | S&P 500 | Cooper Industries |
| 10/31/01 | 2.218 | 1059.78 | 19.35 |
| 11/30/01 | 1.863 | 1139.46 | 20.425 |
| 12/31/01 | 1.68 | 1148.08 | 17.46 |
| 1/31/02 | 1.67 | 1130.2 | 18.2 |
| 2/28/02 | 1.751 | 1106.73 | 17.675 |
| 3/29/02 | 1.751 | 1147.39 | 20.975 |
| 4/30/02 | 1.7356 | 1076.92 | 21.9 |
| 5/31/02 | 1.695 | 1067.14 | 21.685 |
| 6/28/02 | 1.6748 | 989.81 | 19.65 |
| 7/31/02 | 1.7152 | 911.62 | 15.57 |
| 8/30/02 | 1.695 | 916.07 | 16.36 |
| 9/30/02 | 1.5832 | 815.28 | 15.175 |
| 10/31/02 | 1.4718 | 885.76 | 15.745 |
| 11/29/02 | 1.2379 | 936.31 | 19.01 |
| 12/31/02 | 1.1363 | 879.82 | 18.225 |
| 1/31/03 | 1.1466 | 855.7 | 17.715 |
| 2/28/03 | 1.1872 | 841.15 | 18.925 |
| 3/31/03 | 1.1364 | 848.18 | 17.855 |
| 4/30/03 | 1.1058 | 916.92 | 18.55 |
| 5/30/03 | 1.1567 | 963.59 | 19.945 |
| 6/30/03 | 0.7912 | 974.5 | 20.65 |
| 7/31/03 | 0.8725 | 990.31 | 22.165 |
| 8/29/03 | 0.9664 | 1008.01 | 25.445 |
| 9/30/03 | 0.7934 | 995.97 | 24.015 |
| 10/31/03 | 0.9461 | 1050.71 | 26.45 |
| 11/28/03 | 0.9461 | 1058.2 | 26.825 |
| 12/31/03 | 0.7933 | 1111.92 | 28.965 |
| 1/30/04 | 0.8341 | 1131.13 | 28.15 |
| 2/27/04 | 0.9359 | 1144.94 | 26.455 |
| 3/31/04 | 0.9358 | 1126.21 | 28.59 |
| 4/30/04 | 0.8138 | 1107.3 | 27.455 |
| 5/31/04 | 0.9257 | 1120.68 | 28.45 |
| 6/30/04 | 1.0783 | 1140.84 | 29.705 |
| 7/30/04 | 1.2413 | 1101.72 | 28.435 |
| 8/31/04 | 1.4207 | 1104.24 | 27.61 |
| 9/30/04 | 1.4717 | 1114.58 | 29.5 |
| 10/29/04 | 1.7155 | 1130.2 | 31.95 |
| 11/30/04 | 2.0404 | 1173.82 | 33.155 |
| 12/31/04 | 1.8475 | 1211.92 | 33.945 |
| 1/31/05 | 2.01 | 1181.27 | 34.75 |
| 2/28/05 | 2.4778 | 1203.6 | 34.685 |
| 3/31/05 | 2.6107 | 1180.59 | 35.76 |
| 4/29/05 | 2.6712 | 1156.85 | 31.83 |
| 5/31/05 | 2.7622 | 1191.5 | 34.47 |
| 6/30/05 | 2.9671 | 1191.33 | 31.95 |
| 7/29/05 | 3.2208 | 1234.18 | 32.29 |
| 8/31/05 | 3.3625 | 1220.33 | 33.22 |
| 9/30/05 | 3.1088 | 1228.81 | 34.57 |
| 10/31/05 | 3.7301 | 1207.01 | 35.445 |
| 11/30/05 | 3.9428 | 1249.48 | 36.37 |
| 12/30/05 | 3.9946 | 1248.29 | 36.5 |
| 1/31/06 | 4.1878 | 1280.08 | 40.825 |
| 2/28/06 | 4.4629 | 1280.66 | 41.85 |
| 3/31/06 | 4.6272 | 1294.83 | 43.45 |
| 4/28/06 | 4.5762 | 1310.61 | 45.725 |
| 5/31/06 | 4.7376 | 1270.09 | 44.53 |
| 6/30/06 | 4.464 | 1270.2 | 46.46 |
| 7/31/06 | 5.0041 | 1276.66 | 43.08 |
| 8/31/06 | 5.1192 | 1303.82 | 40.94 |
| 9/29/06 | 4.5558 | 1335.85 | 42.61 |
| 10/31/06 | 5.1673 | 1377.94 | 44.725 |
| 11/30/06 | 5.2213 | 1400.63 | 45.72 |
| 12/29/06 | 4.7184 | 1418.3 | 45.215 |
| 1/31/07 | 4.9415 | 1438.24 | 45.695 |
| 2/28/07 | 5.1761 | 1406.82 | 45.83 |
| 3/30/07 | 5.0558 | 1420.86 | 44.99 |
| 4/30/07 | 4.749 | 1482.37 | 49.76 |
| 5/31/07 | 4.8389 | 1530.62 | 53.58 |
| 6/29/07 | 4.2295 | 1503.35 | 57.09 |
| 7/31/07 | 4.983 | 1455.27 | 52.92 |
| 8/31/07 | 4.1588 | 1473.99 | 51.17 |
| 9/28/07 | 3.3522 | 1526.75 | 51.09 |
| 10/31/07 | 3.8928 | 1549.38 | 52.39 |
| 11/30/07 | 3.6586 | 1481.14 | 50.22 |
| 12/31/07 | 2.6067 | 1468.36 | 52.88 |
| 1/31/08 | 1.5777 | 1378.55 | 44.44 |
| 2/29/08 | 2.0768 | 1330.63 | 41.93 |
| 3/31/08 | 1.2006 | 1322.7 | 40.15 |
| 4/30/08 | 1.058 | 1385.59 | 42.39 |
| 5/30/08 | 1.9851 | 1400.38 | 46.63 |
| 6/30/08 | 1.5265 | 1280 | 39.5 |
| 7/31/08 | 1.5165 | 1267.38 | 42.17 |
| 8/29/08 | 1.6036 | 1282.83 | 47.64 |
| 9/30/08 | 0.2028 | 1166.36 | 39.95 |
| 10/31/08 | 0.1115 | 968.75 | 30.95 |
| 11/28/08 | 0.0101 | 896.24 | 24.14 |
| 12/31/08 | 0.0051 | 903.25 | 29.23 |
| 1/30/09 | 0.071 | 825.88 | 26.91 |
| 2/27/09 | 0.1409 | 735.09 | 21.09 |
| 3/31/09 | 0.1267 | 797.87 | 25.86 |
| 4/30/09 | 0.0385 | 872.81 | 32.79 |
| 5/29/09 | 0.1318 | 919.14 | 32.82 |
| 6/30/09 | 0.1014 | 919.32 | 31.05 |
| 7/31/09 | 0.1217 | 987.48 | 32.95 |
| 8/31/09 | 0.0994 | 1020.62 | 32.25 |
| 9/30/09 | 0.0284 | 1057.08 | 37.57 |
| 10/30/09 | 0.0101 | 1036.19 | 38.69 |
| 11/30/09 | 0.0669 | 1095.63 | 42.69 |
| 12/31/09 | 0.0304 | 1115.1 | 42.64 |
| 1/29/10 | 0.0051 | 1073.87 | 42.9 |
| 2/26/10 | 0.076 | 1104.49 | 45.36 |
| 3/31/10 | 0.145 | 1169.43 | 47.94 |
| 4/30/10 | 0.1298 | 1186.69 | 49.1 |
| 5/31/10 | 0.1399 | 1089.41 | 46.97 |
| 6/30/10 | 0.1572 | 1030.71 | 44 |
| 7/30/10 | 0.1349 | 1101.6 | 45.15 |
| 8/31/10 | 0.1501 | 1049.33 | 42.09 |
| 9/30/10 | 0.1328 | 1141.2 | 48.93 |
| 10/29/10 | 0.1247 | 1183.26 | 52.42 |
| 11/30/10 | 0.1501 | 1180.55 | 54.5 |
| 12/31/10 | 0.0537 | 1257.64 | 58.29 |
| 1/31/11 | 0.1318 | 1286.12 | 61.26 |
| 2/28/11 | 0.1146 | 1327.22 | 64.35 |
| 3/31/11 | 0.0507 | 1325.83 | 64.9 |
| 4/29/11 | 0.0101 | 1363.61 | 65.95 |
| 5/31/11 | 0.0304 | 1345.2 | 62.85 |
| 6/30/11 | 0.0051 | 1320.64 | 59.67 |
| 7/29/11 | 0.1673 | 1292.28 | 52.31 |
| 8/31/11 | 0.0051 | 1218.89 | 47.38 |
| 9/30/11 | 0.0051 | 1131.42 | 46.12 |
| 10/31/11 | 0.0051 | 1253.3 | 52.46 |