problem_set_1_data.xlsx
Question 1
| DATE | DJIA (Monthly) | S&P 500 (Monthly) |
| 2014-12-01 | 17754.24 | 2054.27 |
| 2015-01-01 | 17542.26 | 2028.18 |
| 2015-02-01 | 17945.41 | 2082.20 |
| 2015-03-01 | 17931.75 | 2079.99 |
| 2015-04-01 | 17970.51 | 2094.86 |
| 2015-05-01 | 18124.71 | 2111.94 |
| 2015-06-01 | 17927.22 | 2099.28 |
| 2015-07-01 | 17795.02 | 2094.14 |
| 2015-08-01 | 17061.59 | 2039.87 |
| 2015-09-01 | 16339.95 | 1944.40 |
| 2015-10-01 | 17182.28 | 2024.81 |
| 2015-11-01 | 17723.77 | 2080.62 |
| 2015-12-01 | 17542.86 | 2054.08 |
| 2016-01-01 | 16305.25 | 1918.60 |
| 2016-02-01 | 16299.90 | 1904.42 |
| 2016-03-01 | 17302.14 | 2021.95 |
| 2016-04-01 | 17844.38 | 2075.54 |
| 2016-05-01 | 17692.32 | 2065.55 |
| 2016-06-01 | 17754.87 | 2083.89 |
| 2016-07-01 | 18341.18 | 2148.90 |
| 2016-08-01 | 18495.19 | 2177.48 |
| 2016-09-01 | 18088.29 | 2128.19 |
| AVERAGE | 17589.32 | 2059.69 |
| VARIANCE | 381861.760164219 | 4612.8002562771 |
| STANDARD DEV | 617.950 | 67.918 |
| COEFFICIENT OF VAR | 0.03513 | 0.03297 |
Question 3
| Wage |
| 17.5 |
| 13 | | | THE MEAN | 14.017 |
| 10 | | | THE MEDIAN | 14 |
| 16.5 | | | STANDARD DEV | 2.889 |
| 16 |
| 13.5 |
| 14.75 |
| 12 |
| 10 |
| 11 |
| 10.5 |
| 14 |
| 19 |
| 16.5 |
| 16 |
falehal3biwy
