Author: Anonymous

A random sample of 16 passenger fares on Amtrak between Chicago and Denver resulted in a mean fare of $180 and a standard deviation of $40. We are interested in estimating the Confidence Interval on the true “Population Mean” fare between Chicago and Denver on Amtrak. What is the numerical value of Margin of Error (rounded as shown) computed for estimating 94% Confidence Interval estimate on the “Population Mean” fares between Chicago and Denver on Amtrak?

A random sample of 16 passenger fares on Amtrak between Chicago and Denver resulted in a mean fare of $180 and a standard deviation of $40. We are interested in estimating the Confidence Interval on the true “Population Mean” fare between Chicago and Denver on Amtrak. What is the “Sample Size” in this problem?

A travel agency reported that amount spent per day per person at a vacation destination follows a Normal distribution with a standard deviation of $235 and an average of $979. We want to find the Probability that folks spend between $500 and $1400 per day per person at the vacation destination. What is the correct Excel formula (among the ones listed below) that will help us find the answer?

Problem 3 Description: A travel agency reported that amount spent per day per person at a vacation destination follows a Normal distribution with a standard deviation of $235 and an average of $979.   This Problem Description applies to Question 1 through Question 20.   Note: To make it convenient for you, I have copied this problem description into the questions below wherever you need it. That limits the need for going back and forth and scrolling up-and-down and it will save plenty of time for you on the exam. Note: You must answer all the questions for this problem. For any questions that require Excel to find answers, I must see you working in Excel in the Honorlock recording. If I don’t see you working on the Excel file with Excel functions in the Honorlock recording and if less than honest means are resorted to, the Exam cannot be graded. Your work and your work alone must reflect on this Exam. You will be submitting Excel file at the last question. Indicate the Question number for the answers your are going to show in Excel.  Note: Any resources you use on Canvas, must be visible in the Honorlock recording. If students use any resources other than the textbook and the resources on Canvas, that amounts to academic integrity violation and will be reported to USF for further action, Note: Students are prohibited from copying and discussing the questions before, during, and after the Exam with anyone else. Students are prohibited from sharing their Excel files with each other. All such things amount to violation of academic integrity. Any academic integrity violations will be reported to USF for further action. As long as students work on the Exam honestly, there is nothing to worry about. Thank you.

Historically, a wealth management firm has a 20% conversion rate of turning potential customers into actual customers. During a particular week, the firm targeted 15 potential customers in the hope of converting them into actual customers. What is the “Variance” of the probability distribution in this problem?

Historically, a wealth management firm has a 20% conversion rate of turning potential customers into actual customers. During a particular week, the firm targeted 15 potential customers in the hope of converting them into actual customers. What is the “minimum” possible value for the random variable?

A travel agency reported that amount spent per day per person at a vacation destination follows a Normal distribution with a standard deviation of $235 and an average of $979. We want to find the Probability that folks spend $1300 or more per day per person at the vacation destination. What is the correct Excel formula (among the ones listed below) that will help us find the answer?

A travel agency reported that amount spent per day per person at a vacation destination follows a Normal distribution with a standard deviation of $235 and an average of $979. What is the “Variance” of amount spent per day per person at the vacation destination?

Historically, a wealth management firm has a 20% conversion rate of turning potential customers into actual customers. During a particular week, the firm targeted 15 potential customers in the hope of converting them into actual customers. We need to find the probability that between four and 10 (both inclusive) out of the 15 potential customers targeted become “actual customers” for the firm. What is the correct Excel formula (among the ones listed below) that will help us find the answer?

Flight landings at a regional airport are independent in any ten-minute slot during peak hours. The probability of flight landings at the airport in any ten-minute slot during peak hours remains the same. Based on historical data, five flights are expected to land at this airport in a ten-minute slot during peak hours. You are interested in streamlining and improving the process of flight landings at this airport. We need to find the probability that at least two, but less than seven flights land at this airport in ten-minutes during peak hours. What is the correct Excel formula (among the ones listed below) that will help us find the answer?