Question: Please answer the green box questions below using Excel and show all formulas. 3. (5 pts, total) Suppose that the Iowa Express is a su

Please answer the green box questions below using Excel and show all formulas.

Please answer the green box questions below using Excel and show allformulas. 3. (5 pts, total) Suppose that the Iowa Express is a

3. (5 pts, total) Suppose that the Iowa Express is a su perispeedv train that makes daily trips (cine trip per day) around the full perimeter of lowa's border. Assume the travel time of a given trip is a random variable that is normally distributed with a mean of 5 hours and a standard deviation of 30 minutes. Further assume that from one day to the next, trip times are independent of each other. . a) (2 pts) What is the probability that the travel time on a given day is over 6 hours? I: Your answer should be an exact answer with an Excel formula coded into your cell.) b) [1 pt) What is the ziscore associated to a trip travel time of 6 hours? c) (2 pts) What is the probability that over the course of a 365 day year, between 5 ahd 15 trips (inclusive) have travel times in excess of 6 hours? (Your answer should be an exact answer with an Excel formula coded into ybur cell.) 5. (2 pts, total) Let Y be a continuous random variable that is uniformly distributed between 103 and 215. Find a number, b, so that P(Y > b) =.75 (Your answer cell should show work or you can provide written justification of answer.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!