Question

In: Finance

Use Excel to generate 70 values from Normal distribution with mean 18 and standard deviation 5....

  1. Use Excel to generate 70 values from Normal distribution with mean 18 and standard deviation 5. Construct a histogram for them [Note: first generate 100 uniformly distributed random values from [0,1]; then use them as the first input for NORMINV( ) function, two other inputs are mean and standard deviation of given Normal distribution]

Solutions

Expert Solution

Let's first generate 100 uniformly distributed random values from [0,1]
Number random values Normal Distribution
1 0.200077177 13.79327202
2 0.170298607 13.23507049
3 0.817356205 22.5266783
4 0.085075861 11.14141769
5 0.894521613 24.25469444
6 0.626201088 19.60904217
7 0.218788519 14.11854374
8 0.297040659 15.3353448
9 0.815880228 22.4988793
10 0.576538614 18.96523109
11 0.605647196 19.33995915
12 0.57514921 18.94749601
13 0.851640662 23.21747953
14 0.904640703 24.54228139
15 0.381236927 16.48883109
16 0.43090419 17.12963683
17 0.253548425 14.68317527
18 0.492323225 17.90377995
19 0.1925384 13.6570991
20 0.298934374 15.36266082
21 0.061284292 10.27959239
22 0.414277147 16.91721945
23 0.816255534 22.50593472
24 0.310321758 15.52530738
25 0.454720284 17.43127897
26 0.357191677 16.17012248
27 0.961963758 26.86971789
28 0.71278068 20.80763272
29 0.914596486 24.84807637
30 0.490484696 17.88073204
31 0.413449964 16.90660384
32 0.15086223 12.83628795
33 0.702313576 20.65533141
34 0.110638634 11.8843059
35 0.642825641 19.83010961
36 0.95966668 26.73415548
37 0.901043487 24.43760112
38 0.531517763 18.3954284
39 0.58759948 19.10687126
40 0.345658246 16.01465441
41 0.027829999 8.431558618
42 0.985849274 28.96541137
43 0.053110578 9.922931963
44 0.605565837 19.33890221
45 0.272310966 14.97080697
46 0.257744324 14.74842406
47 0.777775748 21.82351429
48 0.62523084 19.59624093
49 0.313970817 15.57686976
50 0.000328285 0.964499669
51 0.937276456 25.66152703
52 0.739401811 21.20751157
53 0.059059808 10.18642438
54 0.32719375 15.76162315
55 0.895962308 24.29437639
56 0.426599126 17.07480376
57 0.223785603 14.20264793
58 0.241869737 14.49849601
59 0.313894822 15.57579857
60 0.049410824 9.747033496
61 0.664691378 20.12650514
62 0.8148975 22.48044717
63 0.338964889 15.92355108
64 0.212623976 14.0132514
65 0.752679435 21.41472869
66 0.679625403 20.33325779
67 0.297336518 15.33961766
68 0.569324884 18.87327816
69 0.578015935 18.98410172
70 0.029889869 8.58792673
71 0.684359996 20.39963003
72 0.872611797 23.69412195
73 0.06715897 10.51355237
74 0.409829824 16.86008623
75 0.284951786 15.15903241
76 0.607656856 19.36608581
77 0.402180686 16.76146666
78 0.023197039 8.041048797
79 0.958987282 26.69526512
80 0.664451648 20.12321663
81 0.480985086 17.76159309
82 0.593198798 19.17890634
83 0.604386379 19.32358654
84 0.433647359 17.1645213
85 0.077173662 10.87828703
86 0.016762664 7.371324775
87 0.639708369 19.78839693
88 0.058601369 10.16688284
89 0.484211085 17.80206361
90 0.582493116 19.04137809
91 0.865157099 23.51893205
92 0.623516456 19.57364721
93 0.028964299 8.518810648
94 0.831693501 22.80439513
95 0.722475784 20.95106071
96 0.743086104 21.26444539
97 0.855977072 23.31209122
98 0.204705288 13.87534334
99 0.522781034 18.28567327
100 0.260618784 14.79280552


Please do rate me and mention doubts, if any, in the comments section.

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

1. In a normal distribution with a mean of 70 and a standard deviation of 5,...
1. In a normal distribution with a mean of 70 and a standard deviation of 5, which z score is closest to the mean? z= -0.02, 0.95, 2.50, -1.00, 0.07 2. heights of 10 year olds, regardless of gender, closely follow a normal distribution with a mean of mu= 55in and standard deviation of 6 in. What is the z score of a girl who is 61 in tall? 3. Petra took two exams last week, one in french and...
A distribution of values is normal with a mean of 190 and a standard deviation of...
A distribution of values is normal with a mean of 190 and a standard deviation of 15. From this distribution, you are drawing samples of size 35. Find the interval containing the middle-most 82% of sample means: Enter your answer using interval notation. In this context, either inclusive or exclusive intervals would be acceptable. Your numbers should be accurate to 1 decimal places. Answers obtained using exact z-scores or z-scores rounded to 3 decimal places are accepted.
A distribution of values is normal with a mean of 114.8 and a standard deviation of...
A distribution of values is normal with a mean of 114.8 and a standard deviation of 98.5. Find the probability that a randomly selected value is between 16.3 and 26.2
A distribution of values is normal with a mean of 80 and a standard deviation of...
A distribution of values is normal with a mean of 80 and a standard deviation of 18. From this distribution, you are drawing samples of size 12. Find the interval containing the middle-most 88% of sample means: Enter your answer using interval notation. In this context, either inclusive or exclusive intervals would be acceptable. Your numbers should be accurate to 1 decimal places. Answers obtained using exact z-scores or z-scores rounded to 3 decimal places are accepted.
A distribution of values is normal with a mean of 60 and a standard deviation of...
A distribution of values is normal with a mean of 60 and a standard deviation of 28. From this distribution, you are drawing samples of size 22. Find the interval containing the middle-most 60% of sample means: Enter your answer using interval notation. In this context, either inclusive or exclusive intervals would be acceptable. Your numbers should be accurate to 1 decimal places. Answers obtained using exact z-scores or z-scores rounded to 3 decimal places are accepted.
A distribution of values is normal with a mean of 80 and a standard deviation of...
A distribution of values is normal with a mean of 80 and a standard deviation of 18. From this distribution, you are drawing samples of size 13. Find the interval containing the middle-most 32% of sample means: Incorrect Enter your answer using interval notation. In this context, either inclusive or exclusive intervals would be acceptable. Your numbers should be accurate to 1 decimal places. Answers obtained using exact z-scores or z-scores rounded to 3 decimal places are accepted.
1.) A distribution of values is normal with a mean of 200 and a standard deviation...
1.) A distribution of values is normal with a mean of 200 and a standard deviation of 27. From this distribution, you are drawing samples of size 30. Find the interval containing the middle-most 54% of sample means: Enter your answer using interval notation. In this context, either inclusive [] or exclusive () intervals are acceptable. Your numbers should be accurate to 1 decimal places. 2.) A fitness company is building a 20-story high-rise. Architects building the high-rise know that...
A population of values has a normal distribution with mean of 165.7 and standard deviation of...
A population of values has a normal distribution with mean of 165.7 and standard deviation of 60.2. a) Get the z-score for a value of 163. For this problem you use the z score formula z=x−μσz=x-μσ    b) This z-score tells you how many  the score of 163 is above or below the population mean μμ . c) Find the probability that a randomly selected value is greater than 163.   Part 2 A population of values has a normal distribution with mean...
Assuming a normal distribution with a mean of 5 and standard deviation of 1.2, what is...
Assuming a normal distribution with a mean of 5 and standard deviation of 1.2, what is the P(X = 6)? 0 0.2033 -0.8333 0.8333   Assuming the expected value of a distribution is 4 and the standard deviation is 0.85, what would be the expected value if a constant of 1 added to each value of x? 4.00 4.85 5.00 5.85 What distribution would you use if you want to find the expected number of heads when you flip a coin...
A normal distribution has a mean of 15 and a standard deviation of 4 . Use...
A normal distribution has a mean of 15 and a standard deviation of 4 . Use the? 68-95-99.7 rule to find the percentage of values in the distribution between 15 and 23 .
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT