Cash-back offer from March 22nd to 31st, 2024: Get a flat 10% cash-back credited to your account for a minimum transaction of $50.Post Your Questions Today!

Question Details Urgent
$ 10.00

Excel Precision Tree: Using

  • From Business, General Business
  • Due on 25 Jul, 2016 12:00:00
  • Asked On 25 Jul, 2016 04:31:48
  • Due date has already passed, but you can still post solutions.
Question posted by
Online Tutor Profile
request

I need help with an assignment which has 2 seperate problems to answer. 

1. I need someone to do Problem #1  (Please Read Instructions Well)

2. Problem #2 using the PRECISION TREE EXCEL APP: with the DECISION ANALYSIS TOOL.

 

Thank you so much for you help!

 

Available Answers
$ 12.00

[Solved] Excel Precision Tree: Using

  • This Solution has been Purchased 3 time
  • Average Rating for this solution is A+
  • Submitted On 25 Jul, 2016 05:12:41
Answer posted by
Online Tutor Profile
solution
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 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. Here we want to find out the probability that, P(X < 0) where X~Normal(0.30,2.50). Using the Minitab software, Graph-> Porbability distribution plot->View probability, the obtained output is given below, We can see that the probability is 0.4522, this is the probability of making a negative return on that selected day. b. 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. The obtained output is given below (we can also do it using excel command NORM.INV(0.8,0.3,2.5)), Thus the required value i.e. L = 2.404. c. Find the probability that t...
Buy now to view the complete solution
$ 10.00

[Solved] Excel Precision Tree: Using

  • This Solution has been Purchased 2 time
  • Average Rating for this solution is A+
  • Submitted On 26 Jul, 2016 10:26:52
Answer posted by
Online Tutor Profile
solution
Excel Precisio...
Buy now to view the complete solution
Other Related Questions

No related question exists

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.
closebutton
Only 45 characters allowed.
closebutton

$ 629.35