Submitted by: Submitted by qiaokeliquqi
Views: 300
Words: 1007
Pages: 5
Category: Other Topics
Date Submitted: 04/27/2011 12:26 AM
Question 1
Use Stocks.xls data set. In this dataset, the annual returns on investment of three stocks are recorded.
a. Characterize the key features of the returns on investment for each stock.
Stock 1:
|Bin |Frequency |Cumulative % |
|-0.5268 |1 |1.01% |
|-0.401433333 |6 |7.07% |
|-0.276066667 |14 |21.21% |
|-0.1507 |11 |32.32% |
|-0.025333333 |11 |43.43% |
|0.100033333 |15 |58.59% |
|0.2254 |11 |69.70% |
|0.350766667 |10 |79.80% |
|0.476133333 |8 |87.88% |
|More |12 |100.00% |
[pic]
Stock 2:
|Bin |Frequency |Cumulative % |
|-0.9963 |1 |1.01% |
|-0.716822222 |4 |5.05% |
|-0.437344444 |7 |12.12% |
|-0.157866667 |15 |27.27% |
|0.121611111 |25 |52.53% |
|0.401088889 |23 |75.76% |
|0.680566667 |11 |86.87% |
|0.960044444 |9 |95.96% |
|1.239522222 |2 |97.98% |
|More |2 |100.00% |
[pic]
Stock 3:
|Bin...