In: Finance
e. Using 50 random numbers given below, compute the mean and standard deviation.
0.733281 | 0.529223 | 0.570479 | 0.156946 | 0.192894 |
0.698638 | 0.495868 | 0.998076 | 0.838307 | 0.905365 |
0.448185 | 0.137872 | 0.141081 | 0.574547 | 0.843859 |
0.894399 | 0.379021 | 0.508334 | 0.663515 | 0.652916 |
0.915581 | 0.906651 | 0.396749 | 0.251720 | 0.443785 |
0.772846 | 0.102010 | 0.682309 | 0.122710 | 0.245580 |
0.769919 | 0.425645 | 0.129105 | 0.345392 | 0.040610 |
0.583922 | 0.520693 | 0.601260 | 0.464264 | 0.338123 |
0.466757 | 0.030690 | 0.922145 | 0.157196 | 0.838904 |
0.987588 | 0.523028 | 0.618625 | 0.876213 | 0.465093 |
Mean = (to 6 decimals)
Standard deviation = (to 6 decimals)
Using Excel Formula to calculate mean and standard
deviation
A | |||||
1 | 0.733281 | ||||
2 | 0.698638 | ||||
3 | 0.448185 | ||||
4 | 0.894399 | ||||
5 | 0.915581 | ||||
6 | 0.772846 | ||||
7 | 0.769919 | ||||
8 | 0.583922 | ||||
9 | 0.466757 | ||||
10 | 0.987588 | ||||
11 | 0.529223 | ||||
12 | 0.495868 | ||||
13 | 0.137872 | ||||
14 | 0.379021 | ||||
15 | 0.906651 | ||||
16 | 0.10201 | ||||
17 | 0.425645 | ||||
18 | 0.520693 | ||||
19 | 0.03069 | ||||
20 | 0.523028 | ||||
21 | 0.570479 | ||||
22 | 0.998076 | ||||
23 | 0.141081 | ||||
24 | 0.508334 | ||||
25 | 0.396749 | ||||
26 | 0.682309 | ||||
27 | 0.129105 | ||||
28 | 0.60126 | ||||
29 | 0.922145 | ||||
30 | 0.618625 | ||||
31 | 0.156946 | ||||
32 | 0.838307 | ||||
33 | 0.574547 | ||||
34 | 0.663515 | ||||
35 | 0.25172 | ||||
36 | 0.12271 | ||||
37 | 0.345392 | ||||
38 | 0.464264 | ||||
39 | 0.157196 | ||||
40 | 0.876213 | ||||
41 | 0.192894 | ||||
42 | 0.905365 | ||||
43 | 0.843859 | ||||
44 | 0.652916 | ||||
45 | 0.443785 | ||||
46 | 0.24558 | ||||
47 | 0.04061 | ||||
48 | 0.338123 | ||||
49 | 0.838904 | ||||
50 | 0.465093 | ||||
Mean | 0.526158 | Using Excel Formula =AVERAGE(A1:A50) | |||
Standard Deviation | 0.279248 | Using Excel Formula =STDEV(A1:A50) |
Please Discuss in case of Doubt
Best of Luck. God Bless
Please Rate Well