Excel Funtions and Analysis
Problem 1 – The normal distribution
Show your work concisely.
If you utilize Excel functions or online calculators specify the function/calculator and ALL inputs.
You may find the reading on probability fundamentals useful in answering part c.
The daily return of a certain stock is normally distributed with a mean of 0.30% and a standard deviation of 2.50%.
(already solved on the quiz) Find the probability that the return on a randomly selected day is negative. ** ** Provide a simple picture of the normal distribution and clearly label what the probability found refers to.
Find the level, L, such that there is a 20% chance that the daily return on a randomly selected day exceeds L.
** Provide a simple picture of the normal distribution and clearly label the value found on the picture.
** Find the probability that the return is negative on each of 4 randomly selected days.
You can place an order similar to this with us. You are assured of an authentic custom paper delivered within the given deadline besides our 24/7 customer support all through.
Latest completed orders:
| # | topic title | discipline | academic level | pages | delivered |
|---|---|---|---|---|---|
|
6
|
Writer's choice
|
Business
|
University
|
2
|
1 hour 32 min
|
|
7
|
Wise Approach to
|
Philosophy
|
College
|
2
|
2 hours 19 min
|
|
8
|
1980's and 1990
|
History
|
College
|
3
|
2 hours 20 min
|
|
9
|
pick the best topic
|
Finance
|
School
|
2
|
2 hours 27 min
|
|
10
|
finance for leisure
|
Finance
|
University
|
12
|
2 hours 36 min
|
