Question

52. Suppose N=10 and r=3. PLEASE SHOW ALL ANSWERS AND FORMULAS IN EXCEL Compute the hypergeometric...

52. Suppose N=10 and r=3.

PLEASE SHOW ALL ANSWERS AND FORMULAS IN EXCEL

Compute the hypergeometric probabilities for the following values of n and x.

a. n = 4, x = 1.

b. n = 2, x =  2.

c. n = 2, x =  0.

d. n = 4, x = 2.

e. n = 4, x = 4.

Homework Answers

Answer #1

Given that, population size = N = 10 and

Number of success in population = r = 3

Using Excel we find the probabilities for the following cases:

a) n = 4, x = 1

P(X = 1) = HYPGEOMDIST(1,4,3,10) = 0.5

Therefore, required probability is 0.5

b) n = 2, x = 2

P(X = 2) = HYPGEOMDIST(2,2,3,10) = 0.0667

Therefore, required probability is 0.0667

c) n = 2, x = 0

P(X = 0) = HYPGEOMDIST(0,2,3,10) = 0.4667

Therefore, required probability is 0.4667

d) n = 4, x = 2

P(X = 2) = HYPGEOMDIST(2,4,3,10) = 0.3

Therefore, required probability is 0.3

e) n = 4, x = 4

Since, number of success in population is 3 so we can not calculate this probability that number of success is greater than number of success in population.

We can not calculate this probability.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Please show all calculations. If using Excel, please show formulas. Practice Question: Calculate the NPV &...
Please show all calculations. If using Excel, please show formulas. Practice Question: Calculate the NPV & IRR for the following 5 year project: - discount rate of 10% - ncf yr 0 = -250,000 - ncf yr 1 = 200,000 - ncf yr 2 = 350,000 - ncf yr 3 = 300,000 - ncf yr 4 = 300,000 - ncf yr 5 = -50,000
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...
PLEASE USE EXCEL TO FIND THE ANSWERS! Or if you don't have access to excel please...
PLEASE USE EXCEL TO FIND THE ANSWERS! Or if you don't have access to excel please tell me how you would find the answers in excel THANK YOU SO MUCH! A study of a hypertension drug’s effectiveness is being conducted. It is considered that the probability that 0 patients of 4 will be brought under control is 0.006, 1 out of 4 brought under control is 0.078, 2 of 4 is 0.261, 3 of 4 is 0.415, and all 4...
Please show all calculations. If using Excel, please show formulas and data. Practice 9: You started...
Please show all calculations. If using Excel, please show formulas and data. Practice 9: You started with a market price of $30 and 10,000 shares. Calculate number of shares after the split and the per share price: *please do this example 2 ways. part a: calculate as 4 individual splits part b: calculate splits as successive.... begin with the original market price and number of shares and calculate the price and number of shares after 4 consecutive splits split 1:...
Exercise 5-69 Algo Assume that X is a hypergeometric random variable with N = 19, S...
Exercise 5-69 Algo Assume that X is a hypergeometric random variable with N = 19, S = 7, and n = 6. Calculate the following probabilities. (Round your answers to 4 decimal places.) a. P(X=1) b. P(X=6) C. P(X>or equal to 2)
Please show formulas in excel Do heavier cars really use more gasoline? Suppose a car is...
Please show formulas in excel Do heavier cars really use more gasoline? Suppose a car is chosen at random. Let x be the weight of the car (in hundreds of pounds), and let y be the miles per gallon (mpg). x 29 46 33 47 23 40 34 52 y 29 22 24 13 29 17 21 14 Complete parts (a) through (e), given Σx = 304, Σy = 169, Σx2 = 12,244, Σy2 = 3837, Σxy = 6045, and...
Suppose the joint probability distribution of X and Y is given by the following table. Y=>3...
Suppose the joint probability distribution of X and Y is given by the following table. Y=>3 6 9 X 1 0.2 0.2 0 2 0.2 0 0.2 3 0 0.1 0.1 The table entries represent the probabilities. Hence the outcome [X=1,Y=6] has probability 0.2. a) Compute E(X), E(X2), E(Y), and E(XY). (For all answers show your work.) b) Compute E[Y | X = 1], E[Y | X = 2], and E[Y | X = 3]. c) In this case, E[Y...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN ANSWER!!!!!!!! You need to buy...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN ANSWER!!!!!!!! You need to buy raw materials for your production process. You use 2,000 units of the raw material each year. The supplier quotes you a price of $9.50 per unit for an order size of 499 units or less, a price of $9 per unit for orders of 500 to 1499 units, and a price of $8.50 per unit for an order of 1,500 or more units. You...
Answer using excel: Please show how you do it   on excel with formulas! 1. Given the...
Answer using excel: Please show how you do it   on excel with formulas! 1. Given the following information, calculate the effective borrowing cost (rounded to the nearest tenth of a percent). Loan amount: $166,950, Term: 30 years, Interest rate: 8 %, Monthly Payment: $1,225.00, Discount points: 2, Other Closing Expenses: $3,611. 
 A. 7.7% B. 8.2% C. 8.5% D. 9.1% 2. Suppose a potential home buyer is interested in taking a $500,000 mortgage loan that has a term of 30 years...
Please show all calculations and formulas. If using Excel (or tables), please show data, formulas, etc....
Please show all calculations and formulas. If using Excel (or tables), please show data, formulas, etc. Practice question 14: Calculate the company’s w.a.c.c. using the info below. ***assume this is a corporate bond that pays 2x annually when calculating the PV of the bond Harvey LLC’s capital structure consists of a 25-year bond issued 5 years ago with a coupon of 6% and a par value of $14,000,000. The company’s main competitor just issued a similar bond paying 5%. The...