Question: the daily exchange rate question needs to be done Use Excel to find the Standard Normal Probability for the following questions. Don't forget to sketch
the daily exchange rate question needs to be done

Use Excel to find the Standard Normal Probability for the following questions. Don't forget to sketch the normal distribution and shade the required area. a) What is the area in the left hand tail of the standard normal curve below z - -2.55? (4dp) b) What is the area under the standard normal curve between z - -1.96 and z - 2.04? (4dp) c) What is the z-value that gives the right hand tail area equal to 0.1492? (2dp) d) What is the absolute value of z such that the total area under the standard normal curve between -z and +z will be 0.8294? (2dp) The daily exchange rates for the two-year period 2011 to 2013 between the Japanese Yen (JPY) and the Australian Dollar (AUD) can be modelled by a Normal distribution with mean , u = 83 Yen and a standard deviation a = 22 Yen. Draw diagrams and use Excel to help you solve the following problems. 1. What is the probability that on a randomly selected day during this period, the dollar was worth less than 55 Yen? (4 dp) 2. What proportion of the days during this period will the dollar be worth between 55 and 87 Yen? (4 dp) 3. If you select a window of 150 days during this period, how many days would you expect the dollar to worth between 55 and 87 Yen? (round to nearest integer) A company's Human Resources department administers a test of "Executive Aptitude". Test scores are known to be normally distributed with a mean of 100 and a standard deviation of 15. 1. What score do you need to be in the top 21% of the applicant pool? (integer) ? What is the score at the ?[d norrentile? (intener) O DELL
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
