Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started