excel assignment help

profileaxxxd.gh
Homework4.xlsx
Home>Computer Science homework help>excel assignment help

Question 1

Homework 4 Due October 2, 2020 no later than 11:59 pm
Question One
According to the US Department of Health and Human Services, only 49.2% of home in the United States
used landline telephone service in 2017
a) Suppose a sample of 207,000 U.S. homes will be taken to learn about home telephone usage
Show the sample distribution of pbar where pbar is the sample proportion of homes that use
landline phone service.
b) What is the probabillity that the sample population in question (a) above will be within +/- .002
of the population proportion.
c) Suppose a sample of 86,800 entreprenuers will be taken to learn about home telephone usage
Show the sampling distribution of pbar where pbar is the sample proportion of homes that use
landline service.
d) What is the probabillity that the sample population in question (c )above will be within +/- .002
of the population proportion.
Are the probabilities different in parts b and d above? Why or why not?

Question 2

Question 2 Homework 3
According to the National Association of Colleges and Employers, the 2015 mean salary
for new college graduates in health sciences was $51, 541. The mean starting salaries for
new college graduates in business was $53,901. Assume the starting salaries are normally
distributed and that the standard deviation for starting salaries for for new college graduates
in health sciences is $11,000. Assume that the standard deviation for starting salaries for new
college graduates in business is $15,000.
a) What is the probability that a new college graduate in business will earn a starting
salary of at least $65,000?
b) What is the probability that a new college graduate in health sciences will earn
a starting salary of at least $65,000?
c) What is the probability that a new college graduate in health sciences will earn
a starting salary less than $40,000?
d) How much would a new college graduate in business need to earn in order to have
a starting salary higher than 99% of all starting salaries of new college graduates in
the health sciences?