Q1) construct a contingency tablefor the positive and non-positive returns of the two stocks
| Date | BIT | MAC |
| 11/3/13 | 52.06 | 37.7145 |
| 18/3/13 | 53.84 | 34.8626 |
| 25/3/13 | 99.99 | 36.5344 |
| 1/4/13 | 139.23 | 36.023 |
| 8/4/13 | 113.07 | 37.5375 |
| 15/4/13 | 123.93 | 35.3838 |
| 22/4/13 | 141.36 | 37.3506 |
| 29/4/13 | 126.5 | 42.3956 |
| 6/5/13 | 120.39 | 45.2082 |
| 13/5/13 | 125.5 | 43.8118 |
| 20/5/13 | 142.52 | 41.8547 |
| 27/5/13 | 137.88 | 42.4546 |
| 3/6/13 | 115.66 | 39.6617 |
| 10/6/13 | 120.98 | 40.8615 |
| 17/6/13 | 125.28 | 41.127 |
| 24/6/13 | 111.97 | 41.1762 |
| 1/7/13 | 97.54 | 41.2647 |
| 8/7/13 | 114.95 | 43.9986 |
| 15/7/13 | 96.5 | 43.3299 |
| 22/7/13 | 92 | 42.2973 |
| 29/7/13 | 99.95 | 44.451 |
| 5/8/13 | 125.49 | 43.025 |
| 12/8/13 | 104.1 | 43.6839 |
| 19/8/13 | 109.53 | 43.8904 |
| 26/8/13 | 158.75 | 43.1332 |
| 2/9/13 | 136.12 | 45.4049 |
| 9/9/13 | 147.87 | 47.9913 |
| 16/9/13 | 143.09 | 49.1715 |
| 23/9/13 | 142.08 | 48.0897 |
| 30/9/13 | 140.24 | 47.7455 |
| 7/10/13 | 151.77 | 47.2538 |
| 14/10/13 | 193.52 | 49.3386 |
| 21/10/13 | 213.89 | 50.3516 |
| 28/10/13 | 233.5 | 52.2201 |
| 4/11/13 | 331.05 | 53.6559 |
| 11/11/13 | 547.08 | 53.6461 |
| 18/11/13 | 974.55 | 53.5969 |
| 25/11/13 | 1191.99 | 53.2822 |
| 2/12/13 | 1016.27 | 50.9908 |
| 9/12/13 | 1027.82 | 51.335 |
| 16/12/13 | 781.78 | 54.8 |
| 23/12/13 | 889.11 | 54.95 |
| 30/12/13 | 999 | 55 |
please construct on on excel.
