2-Sample Tukey Quick Test Excel Template - QI Macros

Click on the QI Macros menu > Stat Templates > Tukey: · A workbook will open to a worksheet with links to various Non-Parametric tests including the Tukey Test. SixSigma&SPCExcelAdd-in QIMacros30-DayTrial Questions?ContactUs Cart0 888-468-1537 CLOSE StatisticalAnalysisinQIMacros FREEQIMacros30-DayTrial StatisticsWizard DataNormality NormalProbabilityPlot AndersonDarlingtest HypothesisTests WhatisHypothesisTesting? NullvsAlternateHypothesis TypeiandiiRisk pvalues TestofMeans ANOVA OneWayANOVA OneWayANOVAPostHoc TwoWayANOVAWithoutReplication TwoWayANOVAWithReplication TwoWayANOVANestedWithReplication ANCOVA t-tests OneSamplettest Pairedttest-TwoSampleforMeans TwoSamplettest: EqualVariancesUnequalVariances z-tests z-testTwoSampleforMeans EquivalenceTests EquivalenceTest TwoOneSidedTestforEquivalence TestofVariances f-testTwoSample LevenesTest Variance-Test:one-sample TestofProportion TestofaProportion TestofTwoProportions TestRelationship Autocorrelation Chi-squareContingencyTable Chi-squareGoodnessofFit Correlation Covariance DescriptiveStatistics FisherExactTest RegressionAnalysis MultipleRegressionAnalysis LogisticRegression(Binary) AdjustedRSquared BoxCoxTransformation Non-parametrictests WhentoUseNon-parametrictests 1-samplesigntest Friedmantest Kolmogorov-Smirnovtest Kruskal-Wallistest Mann-Whitneytest Mood'sMedianTest Signtest Spearmantest TukeyQuicktest WilcoxonRankSumtest WilcoxonSignedRanktest Sampling AQLSamplingTables SampleSizeCalculator HypothesisTestingCheatSheet KnowledgeBase|OnlineUserGuide CLOSE CLOSE Free30-DayTrial WhyQIMacros? PowerfulSPCSoftwareforExcel WhoUsesQIMacros? WhatDoOurCustomersSay? QIMacrosSPCSoftwareReviews SPCSoftwareComparison KeyImprovementTools ControlChart HistogramwithCpCpk ParetoChart FishboneDiagram GageR&RMSA DataMiningTools StatisticalAnalysis SmartWizards LeanSixSigmaTools Support TechnicalSupport QIMacrosFAQs UpgradeHistory SubmitEnhancementRequest DataAnalysisServices FreeTraining FreeQIMacrosWebinar FreeQIMacrosVideoTutorials HowtoSetupExcelforQIMacros FreeLeanSixSigmaWebinars AnimatedLeanSixSigmaVideoTutorials FreeAgileLeanSixSigmaTrainerTraining FreeWhiteBeltTraining FreeYellowBeltTraining FREEResources QIMacrosResources QIMacrosKnowledgeBase|UserGuide ExcelTipsandTricks LeanSixSigmaResources QIMacrosMonthlyNewsletter ImprovementInsightsBlog ShopNow BuyQIMacros QuantityDiscountsandW9 HassleFreeGuarantee StatisticalAnalysisinQIMacros FREEQIMacros30-DayTrial StatisticsWizard DataNormality NormalProbabilityPlot AndersonDarlingtest HypothesisTests WhatisHypothesisTesting? NullvsAlternateHypothesis TypeiandiiRisk pvalues TestofMeans ANOVA OneWayANOVA OneWayANOVAPostHoc TwoWayANOVAWithoutReplication TwoWayANOVAWithReplication TwoWayANOVANestedWithReplication ANCOVA t-tests OneSamplettest Pairedttest-TwoSampleforMeans TwoSamplettest: EqualVariancesUnequalVariances z-tests z-testTwoSampleforMeans EquivalenceTests EquivalenceTest TwoOneSidedTestforEquivalence TestofVariances f-testTwoSample LevenesTest Variance-Test:one-sample TestofProportion TestofaProportion TestofTwoProportions TestRelationship Autocorrelation Chi-squareContingencyTable Chi-squareGoodnessofFit Correlation Covariance DescriptiveStatistics FisherExactTest RegressionAnalysis MultipleRegressionAnalysis LogisticRegression(Binary) AdjustedRSquared BoxCoxTransformation Non-parametrictests WhentoUseNon-parametrictests 1-samplesigntest Friedmantest Kolmogorov-Smirnovtest Kruskal-Wallistest Mann-Whitneytest Mood'sMedianTest Signtest Spearmantest TukeyQuicktest WilcoxonRankSumtest WilcoxonSignedRanktest Sampling AQLSamplingTables SampleSizeCalculator HypothesisTestingCheatSheet KnowledgeBase|OnlineUserGuide QIMacrosReviewsCNETFiveStarReviewIndustryLeadersOurCustomers Home » StatisticalAnalysisExcel »TukeyTest TukeyQuickTestCalculatorinExcel TukeyTestsareEasyUsingQIMacrosStatisticalAdd-inforExcel QIMacrosTukeyTestTemplateinExcel \ Note:ExceldoesnotprovideTukeyTests;QIMacrosaddsthisfunctionality. WhentoUseaTukeyQuickTest A TukeyQuickTest islikeat-test,butitcanhandle nonparametric (i.e.,non-normal)data.Ithelpsdetermineifthemeansarethesameordifferentfromeachother.ThenullhypothesisH0 isthatthemeansarethesame. Tukey'sQuickTestcanbeusedwhen: Therearetwo unpaired samplesofsimilarsizethatoverlapeachother.Ratioofsizesshouldnotexceed4:3. Onesamplecontainsthehighestvalue,theothersamplecontainsthelowestvalue.Onesamplecannotcontainboththehighestandthelowestvalue,norcanbothsampleshavethesamehighorlowvalue. Byaddingthecountsofthenumberofunmatchedpointsoneitherend,onecandeterminethe5%,1%and0.1%criticalvaluesasroughly7,10,and13points. TukeyQuickTestExampleUsingQIMacros ThisexampleusesthedatafromTukey'soriginalpaper(AQuick,Compact,Two-SampleTestToDuckworth'sSpecifications,Technometrics,Vol.1,No.1,February,1959): TorunaTukeyTestinQIMacrosfollowthesesteps: ClickontheQIMacrosmenu>StatTemplates>Tukey: AworkbookwillopentoaworksheetwithlinkstovariousNon-ParametrictestsincludingtheTukeyTest.ClickontheTukeyhyper-linktogototheTukeyworksheet: The TukeyQuickTesttemplatewillopenwithsomepre-populateddataincolumnsAandB.Justdeletethisdataandenteryourown.Note,thatwithoutdata,D1:E1show"TukeyNotApplicable."Ifthedataviolatesanyoftherules,thetemplatewillnotcalculatetheTukeyQuicktest: InputyourdataincolumnsAandBandconfidencelevelincellE17(default=95). Next,clickonthearrowinthelowerrightcornertoUpdatecolumnCandtheChart: HowEndCounts(cellsE13:15)areDetermined IfwecombineandsortthepointsfromcolumnsAandB,wecanseethatthereare5unmatchedpointsoneitherend(foratotalof10).AndTukeycountsatie(14.6and15.0)as0.5.Therearetwooftheseforanothercountof1.10+1equalsatotalof11.Thismeansthatthetwo-sidedconfidenceof99%(>=10)applies: InterpretingtheTukeyQuickTestresults If Then TotalEndCount>=7 Rejectthenullhypothesisat5%confidencelevel. TotalEndCount>=10 Rejectthenullhypothesisat1%confidencelevel. TotalEndCount>=13 Rejectthenullhypothesisat0.1%confidencelevel. TotalEndCount<7 CannotRejectthenullhypothesis(acceptthenullhypothesis) ThenullhypothesisH0 isthatthemeansarethesame.Inthisexample,sincetheEndCount=11,werejectthenullhypothesisata1%confidencelevel. WhyChooseQIMacrosStatisticalSoftwareforExcel? Affordable Only$329USD-lesswithquantitydiscounts Noannualfees FreeTechnicalSupport EasytoUse WorksRightinExcel InterpretsResultsforYou AccurateResultsWithoutWorry ProvenandTrusted 100,000Usersin80Countries Celebrating20thAnniversary FiveStarCNETRating-VirusFree DataMiningandAnalysis DownloadFreeQIMacrosTrial BuyQIMacrosforExcelNow Home AboutUs Store SPCSoftwareforExcel Free30DayTrial On-lineTechSupport QIMacrosReviews SPCSoftwareComparison FreeQIMacrosTraining ContactUs PrivacyPolicy Sitemap KnowWareInternational,Inc. 2696S.ColoradoBlvd.,Ste.555Denver,CO80222USAToll-Free:1-888-468-1537Local:(303)756-9144 © 2022KnowWareInternationalInc.AllRightsReserved.LegalInfo|TermsofUse