Features
Open an SPSS, Excel or CSV file and choose a method; tables, effect sizes and a method note are written to the output document in APA style. 60 methods in 12 categories, variables with value labels and missing-value definitions, and a syntax equivalent for every menu action. Calculations run on this device in Python on WebAssembly; your data is never sent anywhere.
Key features
- Data and Variable view
- In Data view, cells are edited, cases are added, and value labels or codes are shown. In Variable view, name, type (numeric, string, date), width and decimals, label, value labels, missing-value codes, measurement level (nominal, ordinal, scale) and role are edited.
- Open SPSS, Excel and CSV
- SPSS .sav and .zsav files are opened with Varenza's own reader; value labels, missing values, measurement levels and the weight variable are kept. From Excel (.xlsx) the first sheet is read; in CSV / TSV the delimiter is detected automatically. The first row holds the variable names.
- Transform data
- Compute: a new variable with Varenza's own safe expression language (mean.n, sum, sd, ln, rnd, any, range, ifelse, text functions; "a to b" ranges), optionally only for cases that meet a condition. Recode: value, range, missing and "else" rules, into the same or a new variable. Select cases (condition, random sample, range), Split file, Weight cases, Sort cases.
- 60 methods in 12 categories
- Descriptive statistics, regression (linear, logistic, ordinal, multinomial, hierarchical), group comparison (t-tests, ANOVA, ANCOVA, MANOVA, repeated measures, Mann-Whitney, Wilcoxon, Kruskal-Wallis, Friedman), correlation, categorical data, factor analysis, clustering, reliability, distribution, structural equation modelling, market research (NPS, MaxDiff, conjoint, TURF, Van Westendorp), randomness.
- Method browser and data requirements
- The Analyze menu follows the familiar order (Reports, Descriptive statistics, Compare means, General linear model …); the method browser searches by category. For each method, the columns that fit are named; an "Only methods that fit my data" filter is available, and assumptions are checked first.
- Output viewer
- Each analysis is added to the output document in order, with tables, charts and notes; tables and figures are numbered in APA style. Items can be reordered, hidden and re-run; decimal places and the leading zero in p values are adjustable. Output is saved as Word (.docx), PDF, Excel (.xlsx) or HTML, printed or shared; tables are copied with their formatting.
- Syntax
- Varenza's own command language (English keywords): compute, recode, filter, split, weight, sort, and every method by its name. "Paste to syntax" in a dialog writes the correct line; selected lines or everything are run, and menu actions are written to a session journal. Syntax files are saved as .vsx.
- Calculations on the device
- The engine is Python running on WebAssembly via Pyodide: pandas, NumPy, SciPy, statsmodels, scikit-learn, semopy. The engine and packages ship with the app and run in a separate worker (Web Worker); no requests are made while working. Each method's note states which library function computed it.
- Project file and sharing
- Data, variable definitions, output and syntax are saved together as a .varenza file (ZIP), opened again and shared with the device's share feature. Data can also be exported as CSV or Excel (a data sheet plus a variables sheet).
- Sample data
- Three sample datasets are included: a customer satisfaction survey, a teaching experiment and employee engagement. They are seeded synthetic data generated by FigBell; "Restore samples" brings them back.
Devices and browsers
- On the desktop, the dataset and views are on the left, the data table, methods or output in the middle, and parameters and settings on the right; the Analyze menu is in the menu bar. On phones and portrait tablets, the bottom menu holds Data, Variables, Analyze, Output and More.
- The engine is loaded into memory on first launch; meanwhile, data can be opened and variables edited. For large datasets and multivariate methods, a desktop computer with enough memory is recommended.
Keyboard shortcuts
⌘ and ⌥ are used on macOS; Ctrl and Alt on Windows and Linux.
| Shortcut | Action |
|---|---|
| 1 – 5 | Data · Variables · Analyze · Output · Syntax |
| ↑ ↓ ← → | Move between cells in the data table |
| Enter · F2 | Edit cell |
| Esc | Cancel editing, close dialog |
| Ctrl/⌘ E | Compute variable |
| Ctrl/⌘ Enter | Run selection in syntax |
| Ctrl/⌘ O | Open file |
| Ctrl/⌘ S | Save project |
On touch screens, method, parameter and output buttons are sized for fingers; the data table scrolls, and a cell is edited with a double tap. Menus and dialogs open from the bottom.
Get Varenza
Try it in the browser without installation; for continued use, purchase the version for macOS, Windows or Linux.