creating a new data table from p-value on all reports

unknown

Hi,

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.

Thanks!

mpb

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”

This could probably be scripted but I didn't try.