Reference no: EM131950670
1. You will be finding probabilities using excel. Use the Excel instructions for Binomial Distribution (=BINOMDIST(x, n, p, true or false)) and/or Excel Instructions under Excel Examples folder to evaluate the following problems. State which probabilities are unusual.
a.) P(X ≤ 8), n = 20, p = .8 b.) P(X > 6), n = 10, p =.15
c.) P(X < 14), n = 40, p = .35
2. Construct a binomial distribution (table) using Excel functions for the following: Twelve percent of people in the US eligible to donate blood do. You randomly section 15 eligible blood donors and ask them if they donate blood. Create the histogram of this probability distribution. Describe the histogram.
3. Use Excel functions to find the following probability of Z-distribution
a.) P(Z < -1.74) b.) P(Z > .58)
c.) P(-1.4 < Z < 2.1)
4. Use Excel functions to find the following probability of Normal distribution
a.) P (X > 70) when X ~ N (65, 10)
b.) P(20 < X < 40) when X ~ N (32, 12)
5. Use Excel functions to find the X value(s) given the probability when X ~ N(45, 5)
a.) P18 b.) Q3
Percent and the required rate of return
: The project is estimated to have annual cash flows of $1,210,000 with a cost of $475,000. The tax rate is 35% percent and the required rate of return is 11% per
|
What is the present value of the cash flows
: The appropriate real discount rate for the company is 8% percent. Assume all cash flows received at the end of the year.
|
Republican candidate in a state senate race
: A random sample of n=1100 registered voters and found that 570 would vote for the republican candidate in a state senate race.
|
Describe ethical boundaries in clinical psychology
: A diagnosis for a female with Somatic Symptom Disorder, and depression, explain your rationale for assigning these diagnoses on the basis of the DSM.
|
Find the following probability of z-distribution
: Use Excel functions to find the following probability of Z-distribution
|
How you will promote your product or service in detail
: Imagine that you are planning to sell a new product or service, such as a new energy drink, a cleaning service, vitamin water for dogs and cats.
|
What is the mean fro the probability distribution
: The following table shows a police department's data on the probabilities that 0, 1, 2, and 3 burglaries will be reported in a given day.
|
Identify three out of five skills or competencies you have
: Articulate the responsibility of global citizenship and multicultural understanding with regard to academic and professional pursuits.
|
Report on organisation and sector leadership
: Assignment: Report on Organisation and Sector Leadership - itically evaluate how certain types of leadership/management styles impact people performance
|