This is for an EXCEL formula. Problem 23. Contrast the probability distribution for the value of...

This is for an EXCEL formula.

Problem 23. Contrast the probability distribution for the value of the 2 card hand dealt form standard deck of 52 cards. (All Face cards have a value of 10 and the Ace has value of 11).

What is the probability of being dealt 21?

What is the probability of being dealt 16? Construct a chart for the cumulative distribution function.

What is the probability of being a 16 or less?

Between 12 and16?

Between 17 and 20?

Find the expected value and standard deviation of 2 card hand

Expert Solution

orchestra answered 1 year ago

a/Use Excel to find the discrete probability and cumulative probability of the Binomial distribution with probability...

a/Use Excel to find the discrete probability and cumulative probability of the Binomial distribution with probability of success p = 0.75 and n = 80. Find its mean and variance. b/Based upon Excel chart, what can you conclude about the binomial convergence? Hint: Use binom.dist function on Excel and sketch the curve.

what is the formula in excel to get probability answers on range of numbers - Question:...

what is the formula in excel to get probability answers on range of numbers - Question: mean number is 10.3 per day standard deviation is 2.25 per day for any day what is the probability that the number of customers returning items is between 12 and 14 I don't know how to write the equation to obtain P

How would you calculate this with an excel formula on excel: •What is the future value...

How would you calculate this with an excel formula on excel: •What is the future value of the following cash flows if the discount rate is 8%? What is the future value if the discount rate is 5%? (this is asking you take the future value of the cash flows. Please find the future value at year 4. ))

Normal probability distribution Is a continuous distribution Review the in-class Excel worksheet and list criteria under...

Normal probability distribution Is a continuous distribution Review the in-class Excel worksheet and list criteria under which it is appropriate to use the normal distribution in the calculation of probabilities Review the Excel Normal Distribution video clip in the In-class Excel folder. The feature needs the mean and the standard deviation of the distribution under study. Use Excel to calculate the following Normal distribution probabilities: Mean = 5ft, standard deviation = .7ft. The probability that a woman’s height is over...

Use Excel to generate the probability distribution for a binomial random variable for which there are...

Use Excel to generate the probability distribution for a binomial random variable for which there are 20 trials (n = 20) and the probability of success is 0.5 (p = 0.5), and show the graph.

For exercises 21-23, construct a probability distribution and compute the mean and standard deviation for only...

For exercises 21-23, construct a probability distribution and compute the mean and standard deviation for only 21 and 23. 21 Kathryn and John would like to rent a car for a day at the airport. There is a 0.30 probability that they will rent a truck at $20per day, a 0.27 probability that they will rent a SUV at $18 per day, and a 0.28 probability that they will rent a sport car at $35 per day, and a 0.15...

The symbol p in the binomial distribution formula means the probability of (blank) success in (blank) trial.

The symbol p in the binomial distribution formula means the probability of (blank) success in (blank) trial. Please fill in the blanks with the discrete numbers.

1) Using the Binomial Distribution formula find the probability that a family that has 13 children...

1) Using the Binomial Distribution formula find the probability that a family that has 13 children has 10 girls. 2) Given the paired data set below of Super Models ( heights and weights) to determine the line of regression. X | 65 67 62 70 66 69 61 67 65 69 Y |110 105 113 107 109 113 104 110 116 115 3) Calculate the Coefficient of Correlation. 4) Using the data from problem 23 predict the weight of a...

7. Using the Z Chart or excel, assume normal distribution, What is the Probability if Z...

7. Using the Z Chart or excel, assume normal distribution, What is the Probability if Z = -2.09? What is Z if the probability is 0.39? 8. Why would a person use Z scores to compare performance in Business and History classes?

Derive the variation of parameters formula for the solution of the initial value problem for a...

Derive the variation of parameters formula for the solution of the initial value problem for a non-homogeneous, linear system of first order, ordinary differential equations in terms of a fundamental matrix of solutions of the corresponding homogeneous problem.

Question