# answer question and do Excel equations,but the underlying equations that Excel uses

buttheunderlyingequationsthatExceluses.Showyourwork thatis,bothdescribewhatyourcalculationsareinwords,and
show yourcalculationsinthehomework.YoushouldalsoattachanyStatacodeifyouusethatprogramtocalculatetests.Ifit
1. NursesExam
whitesandfourBlackspassed.CreateacontingencytableforPassingExamvs.Race,andusetheFisherexact
testwhetherraceandpassingtheexamareindependent.
3. Createacontingencytableforthisdata.
hypothesisthatethnicityandtheexaminationpassrateareindependent,andexplaintheresults.Ifnot,
5. UsetheFisherExacttesttotestthenullhypothesisthatethnicityandtheexaminationpassrateare
independent.Explaintheresults.
2. Death-Qualifiedjuries
Deathpenaltytrialsaresplitintotwoseparateparts:aguiltphase,wheretheguilt/innocenceofthedefendantis
determinedbyajury,andthepenaltyphase,wherethepenalty(generallyachoicebetweendeathorlifeinprison
death-qualified,thatis,theymustbewillingtoimposethedeathpenaltyinsomecircumstances(ratherthanbe
categoricallyopposedtothedeathpenalty).Someresearchersinvestigatedwhetherdeathqualifiedjurorswere
deliberatedfor1hour,andthenthejurorsvotedagain.Thereweretwotypesofjurors thosewhoweredeathqualified,
andthosewhowouldhavebeenexcluded.ThedataforthisexperimentarepostedonBlackboard.
A. Isthereastatisticallysignificantdifferenceinthevotingpatternbetweendeath-qualifiedjurorsandthose who
wouldhavebeenexcluded?Testthevotingpatternforbothbeforedeliberationandafterdeliberation
separately,andexplaintheresults..
Performthattest,andexplaintheresults.
C. Doesdeliberationchange thedifferencebetweendeath-qualifiedandexcludablejurors? Howwouldyoutestthis?
Performthattest,andexplaintheresults.
3. PoliceExamination.
26Hispanicofficersand64otherofficerstookapromotionexamination.3Hispanicofficersandfourteenother
officerspassed.
A. Createacontingencytableforthisdata
B. UsethePearsonchi-squaredmethodtotestthenullhypothesisthatethnicityandtheexaminationpass
rateareindependent. Explaintheresults.
C. UsetheFisherExacttesttotestthenullhypothesisthatethnicityandtheexaminationpassrateare
independent. Explaintheresults.
D. Usethe2-sampleZ-testmethodtotestthenullhypothesisthatthepassratesareequalforHispanicand
otherofficers. Explaintheresults,andcomparetheresultsfromthe threetestsyouperformedinB,C,D.
E. Compute95%CIfortheRATIOofthepassratesforHispanicofficers andotherofficers.