Question

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.

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.

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 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 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 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 = 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 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 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 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 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.
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...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 11 minutes ago

asked 26 minutes ago

asked 39 minutes ago

asked 40 minutes ago

asked 43 minutes ago

asked 48 minutes ago

asked 49 minutes ago

asked 54 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago