Preliminary analyses
Build constructs from any sheet columns, name them, and optionally rename items. Composites use the mean of items (listwise). Add raw columns for item-level descriptives and correlations. Likert text is auto-coded when possible.
Constructs & columns Collapse to focus on results below
User-defined constructs
Group sheet columns into named constructs (composites + α). Full headers stay in tooltips where text is shortened.
Add or edit a construct
New construct
If set, replaces the full construct name on axes for the composite row. Item-level rows use each item’s label.
Items in this construct
Tick columns above, then click Add checked… — or just click Save construct; checked columns are added automatically. Optional item label overrides the sheet header in summaries.
Raw columns for analysis
Numeric / Likert columns only (auto-detected). Max 24 variables total combined in the correlation matrix (each construct may add one composite, several items, or both — counts toward the same cap).
Results
One tab at a time. Use Export CSV to download tables (pairwise export matches current filter / sort). Item mapping shows the full construct → sheet column map. With very large n and many variables, the correlation block may run in a background worker so the page stays responsive.
Run these analyses
Uncheck outputs you don’t need (faster, less clutter). Choices are saved in this browser.
Construct descriptives
| Construct | k | Items (labels) | n listwise | α | M | SD |
|---|
Raw variable descriptives
| Variable | n | Valid % | Mean | SD | Min | Max |
|---|
Each row is one sheet column assigned to a construct. Headers are shown in full (not shortened). A custom item label overrides the sheet header in descriptives and correlation labels; “—” means the sheet column name is used (possibly shortened in dense tables).
| Construct | Sheet column (CSV header) | Custom item label |
|---|
Pairwise complete observations. * p < .05, ** p < .01, *** p < .001 (two-tailed, uncorrected). Each construct can contribute its composite, items, or both (edit construct). Optional short matrix label shortens the composite on the axes; raw columns use item labels when the sheet column is in a construct (hover for detail).
r column: significance stars use uncorrected two-tailed p. Optional
multiplicity adjustment applies only to the Adj. p column and CSV columns
p_bonferroni / p_fdr_bh (family = all pairs in the current matrix).
Bonferroni: min(1, p × m). FDR-BH: step-up across the m pairwise tests above the diagonal.
| Pair | r | p | Adj. p | n |
|---|