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