Excel Funtions and Analysis

From Business, Finance
Due on 24 Jul, 2016 12:00:00
Asked On 25 Jul, 2016 03:57:44
Due date has already passed, but you can still post solutions.

Question posted by

Jhiggins2118
Rating : 0
Grade : No Rating
Questions : 6
Solutions : 0
Blog : 0
Earned : $0.00

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.

Please Login or Register To Submit the Solution for the Question

Available Answers

$ 7.00

[Solved] Problem 1 – The normal distribution

This Solution has been Purchased 1 time
Submitted On 25 Jul, 2016 08:42:01

Answer posted by

DEEPEYES
Rating : 36
Grade : A-
Questions : 0
Solutions : 534
Blog : 0
Earned : $2221.39

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 c) and d) The daily return of a certain stock is normally distributed with a mean of 0.30% and a standard deviation of 2.50%. a. (already solved on the quiz) Find the probability th...

Buy now to view the complete solution

Attachment

Solution.docx (23 KB)

The benefits of buying study notes from CourseMerits

Assurance Of Timely Delivery

We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.

Best Price In The Market

All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.

Uninterrupted 24/7 Support

Our customer support wing remains online 24x7 to provide you seamless assistance. Also, when you post a query or a request here, you can expect an immediate response from our side.