1 / 8

Chart 16-2: Excel Wilcoxon Signed-Rank Test

Chart 16-2: Excel Wilcoxon Signed-Rank Test. Click OK. Input Column A data in Group 1. Input Column B data in Group 2. Enter data. Click MegaStat. Click Nonparametric Tests. Click Wilcoxon Signed-Rank Test. Select Output ranked data. Chart 16-3: Minitab Wilcoxon Signed-Rank Test.

orrick
Download Presentation

Chart 16-2: Excel Wilcoxon Signed-Rank Test

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chart 16-2: Excel Wilcoxon Signed-Rank Test Click OK Input Column A data in Group 1 Input Column B data in Group 2 Enter data Click MegaStat Click Nonparametric Tests Click Wilcoxon Signed-Rank Test Select Output ranked data

  2. Chart 16-3: Minitab Wilcoxon Signed-Rank Test Enter Variables: (Spicy-Current) Text Median: 0.0 Alternative: greater than Enter data on spicy and current flavours in the worksheet. Use calculator to find differences (Spicy-Current) and store them in C3. Click Stat Click Nonparametrics Click 1-Sample Wilcoxon

  3. Chart 16-4: Excel M-W-W Rank Sum Test Enter data range Click OK Enter data Click MegaStat Click Nonparametric Tests Click Wilcoxon – Mann/Whitney Test Select Output ranked data Select one-tailed

  4. Chart 16-5: Minitab M-W-W Rank Sum Test ETA1 is median for sample 1 (Mirabel) ETA2 is median for sample 2 (Dorval) First Sample: Mirabel Second Sample: Dorval Alternative: less than Click OK Enter data Click Stat Click Nonparametric Click Mann-Whitney

  5. Chart 16-6: Excel Kruskal-Wallis Test Click OK Enter data Click MegaStat Click Nonparametric Tests Click Kruskal-Wallis Test Select Output ranked data Indicate Input range

  6. Chart 16-7: Minitab Kruskal-Wallis Test Store the stacked data in: C4 Enter C1, C2 and C3 in Stack the Columns Enter data for each of the three samples in three separate columns (C1, C2, C3) Click Stack/ unstack Click Manip Click Stack Columns Enter C4 in the Response Enter C8 in the Factor box Click OK Click OK Repeat Stacking Process Click OK Click Stat Click Nonparametrics Click Kruskal-Wallis Stack new columns: C5, C6, C7 Store in C8 Enter labels corresponding to data in C1, C2, C3

  7. Chart 16-8: Excel Rank Correlation Click OK Enter data for Executives and Training in Columns B and C Click MegaStat Click Nonparametric Tests Click Spearman Coefficient of Rank Correlation Input data range Select Output ranked data

  8. Chart 16-9: Minitab Rank Correlation Enter data for Executives and Training in C2 and C3 Click Manip Click Rank Repeat with C3 data Enter C2 in the Rank data box Enter C4 in Store ranks box Click Stat Click Basic Statistics Click Correlation Click OK Enter C4 and C5 in Variables box Click OK

More Related