creating a new data table from p-value on all reports
Nov 10, 2009 12:26 PM(1409 views)
Is it possible to create a table of P-Values using tabulate? I want to be able to view a matrix or table with all of my questions listed down the left hand side and all of my factors along the top. My ultimate goal is to have a table of only P-Values for all of my survey questions by factor to easily determine which ones are significant.
It may well be possible with Tabulate, but I'll illustrate how to do it using Transpose with the Fitness data as an example.
1. Open the Fitness data in the sample library. 2. Fit Model: Oxy, Runtime, RunPulse -->Y and Age, Weight -->Model Effects, click Run Model 3. In the Oxy report right click in the Parameter Estimates segment and click on Make Combined Data Table 4. With resulting table current, Tables>Transpose: Y-->By, Term-->Label, Prob>|t|-->Transpose Columns, click Ok 5. In resulting table delete the column labeled “label” and change Y to Question if you want 6. If you want, select factor columns and, in the column panel right click in the selection and choose Standardize Attributes and change the format to “Pvalue”
However. I am using the p-value or prob> I Z I value under the Wilcoxon Non-parametric test and i have run separate reports for each of my questions to make the data more manageable but now i want all the p-value's in one report and each time i create a new combined data table and transpose it, it creates a new table for each question and i actually need them side by side on the transposed table. So there are 37 questions and 42 factors and i ran each question by factor in a separate report. So that would create 37 separate transposed tables and i just want one. Any thoughts???
This is what my transposed table looks like for each report. The column labeled Visual Privacy is 1 of 37 questions. The numbers below it are the P-Values for that question. For each question i ran a wilcoxen non-parametric by factor which is the column on the far left. This generates a total of 37 separate reports. Since the factors are constant for each report i want to be able to click on each report and add the p-values from that report to the already transposed table. Even if i have to delete the label column and duplicate factors column for each report it would still save time.