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 six 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?

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 range of amounts (lower and upper in $) that fols spend, assuming the spending is within the middle 80% (with the remaining 20% equally distributed in the two tails) of per day per person spending distribution at the vacation destination. What are the correct Excel formulas to be used (among the ones listed below) that will help us find the answer?

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 probability (rounded to four digits after the decimal) that between three and nine (both inclusive) out of the 15 potential customers targeted become “actual customers” for the firm?

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 amount (in $) that folks need to spend, assuming the spending is in the top 70% of spending per day per person distribution at the vacation destination. What is the correct Excel formula (among the ones listed below) that will help us find the answer?

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 probability (rounded to four digits after the decimal) that seven out of the 15 potential customers targeted become “actual customers” for the firm?

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 probability (rounded to four digits after the decimal) that less than 11 out of the 15 potential customers targeted become “actual customers” for the firm?

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?

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 less than five 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?

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. What is the probability (rounded to four digits after the decimal) that less than four flights land at this airport in ten-minutes during peak hours?

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. What is the probability (rounded to four digits after the decimal) that more than four flights land at this airport in ten-minutes during peak hours?