Question

Is lack of sleep causing

10:34 Done BUQU 1230 - Assignment 2 F... Q1 Name Q2 Q3 Q4 Total Isrucr mat o of 25 a large company, iis asmed th 20% f the empleyees heild degees in b aple of 100pleyes is sclected, and thcir deprc ded A L The aple d th 18 mpyees hl degees in Gve the me its valae, and its poit estima a What is the popeiste p besines. a peobility dribaon will be od to determin the prblits o pati pi What is the value of the mean of the dribion from pan LWht is the standerd erer of the deerbticn fom prt Wht is the prbilay that a le of 100eplyes with basinss degroes? 12 mp What is the probhity th a smple of 10e employees oains less thn 15 plyos with businos degroes What is the probublity tht a sample of 10e employoos ontas betwoom 12 and 14 playoes with businoss degroe? Ifa sample of 100 employoes contains les thn 12 employos with bsin d you might qution the ap th 20% of the cmploys held degras in bn nwy

i want answer in ms excel

Answer 1

i)
value = 0.20
point estimate = 0.18

j) normal distribution
k) mean = 0.2
l) standard error = 0.04

m)
P(p^ > 0.12)
= 0.97725

n)
P(p^ < 0.15)
= 0.10565

Z = (p^ - p)/sqrt(pq/n)

Excel formulas

p	0.2
X	18
n	100
point estimate	=B2/B3
standard error	=SQRT(B1*(1-B1)/B3)
P(p^ > 0.12)	=1-NORMDIST(0.12,0.2,0.04,1)
P(p^ < 0.15)	=NORMDIST(0.15,0.2,0.04,1)

you can solve rest problems similarly

Please rate if helpful

By HOMEWORKLIB RULES, we have to answer only first 4 sub-parts in multiple sub-parts

Please post rest questions again if you still need help