5257 statistics assignment

1.stocks.xls data set
For stock 1, the median was 0.0607, mean was 0.0286, the loss of investment can be as large as -0.5268, and the gain of the investment can be as large as 0.6015. However, the risk of loss was round 7%, while the chance to gain between 0 – 0.8 was very high, nearly 78%.
For stock 2, the median was 0.0511, mean was 0.096413, the loss of investment can be as large as -0.9963, and the gain of the investment can be as large as 1.519. The risk to loss for stock 2 was about 12%, the chance to gain between 0-0.8 was nearly 64%, and the chance to gain between 0.8 and 1.2 was relative big, round 17%.
For stock 3, the median was 0.0108, mean was 0.028598, the loss of investment can be as large as -0.577, and the gain of the investment can be as large as 0.4816. The risk to be loss was only 2%, and the chance to gain between 0-0.8 was almost 96%.
For these 3 kinds of stocks, stock 3 had the lowest risk to loss, and stock 2 can be loss large and gain large. The stock 1 and 3 had narrow range for the return of investment while the opportunities of it for stock 2 is a litter flatter than the two above.
Justify with descriptive statistics and the histogram tools:
Firstly use descriptive statistics to summarise the key features of stock1, stock2, and stock3 respectively.
All the available output options were chosen and labels in the first row were chose as in the Appendix figure 4.1 descriptive statistics.
The output are as follows:

Figure 1.1 descriptive Statistics for Stock 1, 2, and 3
Stock 1

Stock 2

Stock 3

Mean
0.028631

Mean
0.096413

Mean
0.028598
Standard Error
0.030729

Standard Error
0.049218

Standard Error
0.022666
Median
0.0607

Median
0.0511

Median
0.0108
Mode
-0.5085

Mode
-0.8652

Mode
-0.3641
Standard Deviation
0.305747

Standard Deviation
0.489717

Standard Deviation
0.22552
Sample Variance
0.093481

Sample Variance
0.239822

Sample Variance
0.050859