FAQ & troubleshooting¶
- A column I want isn’t offered in a selector.
Selectors only show columns of a compatible type. Check the column’s type in the data viewer — for example, a numeric summary won’t list a text column. Use Transform Column to change a column’s type (see Transform Column).
- My nominal variable won’t go into a regression.
Regression accepts only numeric/ordinal predictors. Convert the nominal column with One-hot encoding first; then select the resulting 0/1 indicator columns. See Regression.
- A blank answer shows up as
nan. Blank cells in text columns are read as the literal value
nan; blanks in numeric columns stay genuinely missing. Handle them with Impute Missing or remove them with Filter. See Importing data.- A correlation cell is empty.
If a variable has no variance (one repeated value), its correlation is undefined and shown blank — a note explains this. Also, confidence intervals are only shown for Pearson and Spearman; other coefficients legitimately show none.
- My results didn’t change after I edited a cleaning step.
Results read from a data source. With Auto they follow your latest step automatically; if you set a specific source, make sure it points where you intend.
- A group comparison says there aren’t enough groups / cases.
The grouping column must define at least two groups, each with enough cases. Check the grouping column’s values (watch for a stray
nancategory from blank answers).- Tables/figures pasted into Word look wrong.
Use File ▸ Copy All Results, then paste into Word. A regular paste (Ctrl+V) works fine. For more precise formatting, use Paste Special ▸ HTML Format instead. Either way, if tables come out misaligned, remove the paragraph indent first: Word applies a default first-line/left indent that distorts pasted tables, so set the indent to 0 (Home ▸ Paragraph, or clear formatting) before or right after pasting. Also set the Language (Settings ▸ Language) and Plot theme (Settings ▸ Plot theme) before copying, since results render in the current settings.
- How do I share or archive a full report?
File ▸ Export Report (HTML)… writes one self-contained file (figures embedded). Open it in a browser to read or print to PDF.
- How do I reopen everything later?
Save a
.spproject (File ▸ Save As…). It stores the data, all processing steps, and all analyses. See Projects & settings.- Is StatPrism free?
Yes — it is open source. Report issues or suggest features on the project’s GitHub repository.
See also
New here? Start with Getting started, then follow the Worked example: from a Google Form to a report.