Tukey: Test of mean differences in Excel - Business Analytics

Tukey: Test of mean differences in Excel ... - [Instructor] This worksheet calls out each of the differences between two group means separately. With seven groups ... Skiptomaincontent Solutionsfor: Business HigherEducation Government Buyformyteam Fromthecourse:BusinessAnalytics:MultipleComparisonsinRandExcel Tukey:TestofmeandifferencesinExcel Fromthecourse:BusinessAnalytics:MultipleComparisonsinRandExcel Startmy1-monthfreetrial Buythiscourse(SGD29.99*) Transcripts ExerciseFiles ViewOffline Tukey:TestofmeandifferencesinExcel “ -[Instructor]Thisworksheetcallsouteachofthedifferencesbetweentwogroupmeansseparately.Withsevengroups,ashere,youcanmakeseventimessixdividedbytwocomparisons.Eachinvolvingadifferentpair.That's21.Sothereare21meancomparisonstomake.Thedifferenceisbetweengroupmeansappearincolumnh.Soforexample,thegrouponemeanof33.02incellF2,minusthegrouptwomeanof29.98,incellG2,resultsinameandifferenceof3.03incellH2.Howfarawayinstandarddeviationunitsisthatdifferenceof3.03fromzero?Wecandeterminethatbydividingtherawdifferencebythestandarderrorwithin,whichwesawinthiscaseis3.22.It'sincellB11,onacurrentworksheet.Theresultofthedivision3.03dividedby3.22is0.94,shownincellI2.Sothetwogroupmeansare0.94ofastandarderrorapart.FinallywetaketheabsolutevalueofthatresultincellJ2.Thattellsusthattherawdifferencebetweenthemeansofcellschannelsfandcis94%ofastandarderrorintheqdistribution.Doesthatdifferentbetweenthetwomeansdepartfromzerofarenoughtomakeyoubelievethatit'sadependabledifference?ThecriticalqvalueshownincellB13answersthatquestion.Adifferenceofatleast3.86standarddeviationunitsisnecessaryforthedifferencebetweenanytwoofthesegroupmeanstoberegardedassignificantatthe0.10levelofalpha.Ifyouscanthevaluesincolumnj,you'llseethatonlyoneinrowsevenislargeenoughat4.07tobedeclaredsignificant.It'stheonlyoneofthe21comparisonswithanabsolutevaluelargerthanthecriticalvalueof3.86.SoaccordingtoTukey'smultiplecomparisonprocedure,there'sasignificantdifferenceonlybetweenthemeanprofitmarginforsaleschannelscandthemarginforsaleschannele.Ifyou'dratherthinkintermsofmargindollarsinsteadofstandarderrorunits,youcanmultiplythenumberofstandarderrorsincellB13,bythesizeofthestandarderrorincellB11.Thisvalue12.42isthecriticalvalueforanyofthe21comparisonsofgroupmeansindollarunits.Asyou'llseeit'salsothesizeofthehalfwidthofthe90%confidenceinterval.Let'scomparetheresultswegotonExcelwithresultsthatwegetfromthestatisticalfreewarepackageR. Practicewhileyoulearnwithexercisefiles Downloadthefilestheinstructorusestoteachthecourse.Followalongandlearnbywatching,listeningandpracticing. ExerciseFile:Subscribetoaccess. Ex_Files_Business_Analytics_R_Excel.zip Downloadtheexercisefilesforthiscourse. Getstartedwithafreetrialtoday. Downloadcoursesandlearnonthego Watchcoursesonyourmobiledevicewithoutaninternetconnection.DownloadcoursesusingyouriOSorAndroidLinkedInLearningapp. Watchthiscourseanytime,anywhere. Getstartedwithafreetrialtoday. Contents Introduction Introduction Pinpointgroupmeandifferences 1m36s Gettingstarted 5m7s 1.TukeyMultipleComparisonsTest 1.TukeyMultipleComparisonsTest Tukeyhonestlysignificantdifference(HSD):Overview 2m11s Tukey:PreliminarytestsinExcel 7m30s Tukey:TestofmeandifferencesinExcel 3m3s Tukey:PreliminarytestsinR 4m53s Tukey:TestofmeandifferencesinR 2m21s Tukey:Choiceoferrorrates 6m28s 2.SchefféMultipleComparisonsTest 2.SchefféMultipleComparisonsTest Scheffé:Overview 2m36s Scheffé:PreliminarytestsinExcel 2m33s Scheffé:ContrastsinExcel 2m10s Scheffé:CalculatingPsi 8m12s Scheffé:TestofmeandifferencesinR 6m1s Scheffé:Criticalvaluesandconfidenceintervals 3m39s Conclusion Conclusion Nextsteps 40s *PricemaychangebasedonprofileandbillingcountryinformationenteredduringSignInorRegistration ExploreBusinessTopics BusinessAnalysisandStrategy BusinessSoftwareandTools CareerDevelopment CustomerService FinanceandAccounting HumanResources LeadershipandManagement Marketing ProfessionalDevelopment ProjectManagement Sales SmallBusinessandEntrepreneurship TrainingandEducation Seeall ExploreCreativeTopics AEC AnimationandIllustration AudioandMusic GraphicDesign MotionGraphicsandVFX Photography ProductandManufacturing UserExperience Video VisualizationandReal-Time WebDesign Seeall ExploreTechnologyTopics CloudComputing DataScience DatabaseManagement DevOps ITHelpDesk MobileDevelopment NetworkandSystemAdministration Security SoftwareDevelopment WebDevelopment Seeall