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

answer question and do Excel equations,but the underlying equations that Excel usesAnswerthequestionsbelow.Eachanswerwillbe1-3paragraphs,includinganyequationsnecessary.NotjustExcelequations, buttheunderlyingequationsthatExceluses.Showyourwork thatis,bothdescribewhatyourcalculationsareinwords,and show yourcalculationsinthehomework.YoushouldalsoattachanyStatacodeifyouusethatprogramtocalculatetests.Ifit isnotreadilyapparentwhatyouaredoing(i.e.,howyouarecalculatingsomething),thenyouneedtoexplainmore. Answerthefollowingquestions: 1. NursesExam 2. (AdaptedfromStatisticsforLawyers,p.157)26whitenursesand9Blacknursestookanexamination.All whitesandfourBlackspassed.CreateacontingencytableforPassingExamvs.Race,andusetheFisherexact testwhetherraceandpassingtheexamareindependent. 3. Createacontingencytableforthisdata. 4. CanyouusePearsonsChi-squaredtest?Ifyes,pleaseusethePearsonchi-squaredmethodtotestthenull hypothesisthatethnicityandtheexaminationpassrateareindependent,andexplaintheresults.Ifnot, pleaseexplainwhy. 5. UsetheFisherExacttesttotestthenullhypothesisthatethnicityandtheexaminationpassrateare independent.Explaintheresults. 2. Death-Qualifiedjuries Deathpenaltytrialsaresplitintotwoseparateparts:aguiltphase,wheretheguilt/innocenceofthedefendantis determinedbyajury,andthepenaltyphase,wherethepenalty(generallyachoicebetweendeathorlifeinprison withoutparole)isdeterminedbythesamejury.Inordertoserveonajuryinadeathpenaltytrial,jurorsmustbe death-qualified,thatis,theymustbewillingtoimposethedeathpenaltyinsomecircumstances(ratherthanbe categoricallyopposedtothedeathpenalty).Someresearchersinvestigatedwhetherdeathqualifiedjurorswere morelikelytodecideadefendantwasguilty.Theresearcherscreatedmocktrialsandtestedhowmockjurorswould havevotedinthecase.Inparticular,mockjurorswereaskedbeforedeliberationwhattheirvotewouldbe,thejuries deliberatedfor1hour,andthenthejurorsvotedagain.Thereweretwotypesofjurors thosewhoweredeathqualified, andthosewhowouldhavebeenexcluded.ThedataforthisexperimentarepostedonBlackboard. A. Isthereastatisticallysignificantdifferenceinthevotingpatternbetweendeath-qualifiedjurorsandthose who wouldhavebeenexcluded?Testthevotingpatternforbothbeforedeliberationandafterdeliberation separately,andexplaintheresults.. B. Doesdeliberationmatter?Thatis,doesdeliberationchangethevotesofmockjurors?Howwouldyoutestthis? 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.:

Welcome to Vision Essays! For over 10 years we have been helping students like you write, research, and generate ideas for their research papers, essays, term papers, dissertations, editing, resumes, and any other type of work your learning institution may assign you.

We can write any paper and have flexible payment plans with a minimum deadline of 6 Hrs.

Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total: