Contact

Gnumeric learning centre

Gnumeric Statistics, Data Analysis and Scientific Tutorials

67 practical tutorials. Start with the ordered route, or browse every lesson by task and learning stage.

About this tutorial collection

Learn Gnumeric beyond basic formulas, from importing and checking data to statistical analysis and scientific workflows. These guides use small downloadable datasets and reproducible examples. Each guide identifies its verification method. Some worked examples have been tested in Gnumeric, while others are based on official documentation and independent calculation. For application-tested examples, check the stated version, tested steps and remaining limitations. For function syntax, explore the Gnumeric function index.

Suggested first steps

Gnumeric: from a first workbook to checked output

Use Gnumeric desktop and work on copies of your files. Start with the first workbook lesson; later lessons use separate fixtures. Historical GUI and CLI evidence have different scopes: check each lesson’s notes.

This is a short route through existing guides, not a complete course or a claim that every procedure was application-tested.

  1. Build and Check Your First Expense Workbook in Gnumeric

    Build and check four expense formulas and a remaining budget.

    Version and verification notes

    Manual 1.12 desktop documentation and independent fixture; native save/reopen unverified.

  2. Copy Formulas with A1 and R1C1 References in Gnumeric

    Copy a checked price matrix and distinguish A1/R1C1 notation.

    Version and verification notes

    Gnumeric 1.12.62 source-qualified GTK controls; ssconvert CLI calculation and reread evidence only. GUI copy/paste, R1C1 toggle/direct entry and graphical reopening untested.

  3. Audit Duplicate Records with Sort and Filter in Gnumeric

    Audit duplicates without deleting the original records.

    Version and verification notes

    Historical native Gnumeric 1.12.57 Debian 13.6 Linux English/C-locale sort and separate-output filter; manual/1.12.62 source reviewed, not 1.12.62 GUI-tested. Reopening and changed-input reruns untested.

  4. Build and Update a Column or Line Chart in Gnumeric

    Check a chart against four monthly values and changed ranges.

    Version and verification notes

    Gnumeric manual 1.12 documentation; menu wording varies between sources; GUI creation/updates/reopening/screenshots unverified.

  5. Set a Print Area and Fit One Page in Gnumeric

    Verify print scope and readable PDF output.

    Version and verification notes

    Historical native Gnumeric 1.12.57 Debian 13.6 Linux English/C locale PDF tests; 1.12.62 source not runtime. Native preview viewer unavailable; physical printing and workbook reopening untested.

Browse all tutorials

Learning stages use the guide’s own difficulty label. Edition/platform filtering is classified only for the reviewed route above; other lessons remain unclassified, not unsupported. Read each guide’s version notes.

Beginner

Annotate a Report with Images and Drawings in Gnumeric

Insert an original practice PNG, add an arrow beside a report total, and distinguish floating objects from worksheet cells and exported report output.

Report images and annotations · Beginner

Unclassified: check guide

Check Selected Values with Status Calculations in Gnumeric

Use Gnumeric's running calculation to check a selected range, distinguish numeric Count from row count, and avoid mistaking a temporary display for a saved formula.

Selection and calculation checks · Beginner

Unclassified: check guide

Create and Maintain Named Ranges in Gnumeric

Define workbook and sheet names in Gnumeric, audit their scope, extend a named range and check a reversible rate change.

Names and references · Beginner

Unclassified: check guide

Create and Reuse a Workbook Template in Gnumeric

Build a reusable native Gnumeric master, create a separate working copy before entry, and verify that formulas and the clean master survive reuse.

Templates · Beginner

Unclassified: check guide

Create Category Frequency Tables in Gnumeric

Count text categories with Gnumeric frequency analysis and avoid missing categories or accidental duplicate labels.

Statistical analysis · Beginner

Unclassified: check guide

Edit Records Without Misaligning Fields in Gnumeric

Compare Clear Contents, Delete Rows, Insert Rows and shifting cells in Gnumeric, then check that each record keeps the right ID, item, amount and note.

Record editing and data integrity · Beginner

Unclassified: check guide

Enter Data Through a Selected Region in Gnumeric

Use Enter to work down columns or Tab to work across rows inside a selected Gnumeric rectangle, with explicit direction and boundary checks.

Data entry · Beginner

Unclassified: check guide

Export a Clean CSV from Gnumeric

Export one clean Gnumeric sheet with deliberate CSV quoting, UTF-8 and decimal conventions, then check identifiers and numeric totals after import.

Import and export · Beginner

Unclassified: check guide

Fill Sequences and Copy a Model Safely in Gnumeric

Generate bounded numeric and weekly date sequences in Gnumeric, fill a calculation column, and distinguish generated values from live formulas.

Data entry and filling · Beginner

Unclassified: check guide

Find and Replace Data Safely in Gnumeric

Preview scoped matches in Gnumeric, replace only text values with per-change confirmation, and audit formulas and untouched cells afterward.

Find and replace · Beginner

Unclassified: check guide

Generate a Random-Integer Table in Gnumeric

Use Gnumeric's Random Number Generation dialog for a fixed 20-cell integer table. Check its size, bounds and values without expecting a repeatable sequence.

Data entry · Beginner

Unclassified: check guide

Guide’s version scope

Gnumeric 1.12.62 English GTK desktop source and packaged manual; headless Linux checks cover synthetic validation formulas only

Import CSV and Fixed-Width Text in Gnumeric

Import semicolon CSV or fixed-width text in Gnumeric. Set column boundaries, decimal locale and text types, then check numbers and leading-zero codes.

Importing data · Beginner

Unclassified: check guide

Lay Out a Readable Worksheet in Gnumeric

Format a Gnumeric task report with readable widths, wrapped notes, restrained borders and a repeatable check for newly added rows.

Cell formatting and layout · Beginner

Unclassified: check guide

Open and Save XLSX Safely in Gnumeric

Keep the original XLSX, save an exchange copy, and verify formulas, dates, percentages and identifiers after reopening in Gnumeric.

File compatibility · Beginner

Unclassified: check guide

Organize, Hide and Resize Worksheets in Gnumeric

Build a cross-sheet summary, hide and restore a source tab, and safely resize one Gnumeric worksheet without changing every sheet.

Workbook organization · Beginner

Unclassified: check guide

Review Workbook Properties Before Handoff in Gnumeric

Give a synthetic workbook a clear document title and description, distinguish properties from cell comments, and verify a revised copy without claiming complete sanitization.

Workbook documentation · Beginner

Unclassified: check guide

Set a Print Area and Fit One Page in Gnumeric

Choose a Gnumeric print range, set one-page scaling, repeat headings when needed, and verify readable printer or PDF output.

Printing and PDF output · Beginner

Desktop (reviewed route)

Set Reversible Workspace Defaults in Gnumeric

Test Gnumeric's new-workbook sheet count and zoom defaults without confusing them with existing workbook contents, then recover a hidden toolbar and restore your settings.

Workspace preferences · Beginner

Unclassified: check guide

Set Up Auto Save Safely in Gnumeric

Configure Gnumeric Auto Save, keep an independent checkpoint, and verify saved changes without mistaking timed saves for crash recovery or version history.

Saving and recovery · Beginner

Unclassified: check guide

Split an Existing Text Column in Gnumeric

Use Text to Columns with delimiter and quote previews, preserve the source column, and leave room for the results on its right.

Data cleanup · Beginner

Unclassified: check guide

Why a Protected Cell Can Still Be Edited in Gnumeric

Separate a cell’s locked attribute from active sheet protection in Gnumeric, test input and formula cells, and understand the limits.

Sheet and cell protection · Beginner

Unclassified: check guide

Intermediate

Build a Covariance Table in Gnumeric

Use Gnumeric's Covariance analysis tool with aligned observations, correct labels and grouping, and a checked population-covariance example.

Statistical analysis · Intermediate

Unclassified: check guide

Build a Histogram with Custom Bins in Gnumeric

Use Gnumeric histogram cutoffs, bin boundaries and frequency output to understand numeric measurements without miscounting edges.

Statistical analysis · Intermediate

Unclassified: check guide

Check normality before choosing a statistical test

Run a documented normality test with a probability plot, check sample count, and interpret an outlier without treating a p-value as proof.

Analysis and modeling · Intermediate

Unclassified: check guide

Guide’s version scope

Gnumeric 1.12.62 GTK desktop source and upstream 1.12 manual; English controls; documentation-qualified, not native-tested or a 1.12.57 runtime claim

Compare saved what-if scenarios

Save named input sets, preview them in Scenario Manager, and keep a scenario report without accidentally canceling it.

Analysis and modeling · Intermediate

Unclassified: check guide

Guide’s version scope

Gnumeric 1.12.62 GTK desktop source and upstream 1.12 manual; English controls; documentation-qualified, not native-tested or a 1.12.57 runtime claim

Compare Two Variances with Gnumeric's F-Test Tool

Use Claims About Two Variances in Gnumeric, set labeled sample ranges, and interpret its F ratio, directional probabilities and two-sided cutoffs.

Statistical analysis · Intermediate

Unclassified: check guide

Consolidate Regional Tables by Label in Gnumeric

Use Gnumeric's Consolidate tool to match row and column labels across reordered tables, check the combined figures and distinguish values from formula output.

Data management · Intermediate

Unclassified: check guide

Create a Correlation Matrix in Gnumeric

Use the Gnumeric Correlation analysis tool to compare several measurement columns and interpret Pearson correlation.

Statistical analysis · Intermediate

Unclassified: check guide

Fit a Linear Regression in Gnumeric

Run Gnumeric regression analysis on X and Y data, read the intercept and slope, and avoid common input-range mistakes.

Statistical analysis · Intermediate

Unclassified: check guide

Reference Another Workbook Safely in Gnumeric

Learn Gnumeric external-reference syntax, local file paths, recalculation limits and a changed-input check before trusting a linked report.

Workbook organization · Intermediate

Unclassified: check guide

Run and check a Monte Carlo simulation

Run a bounded uniform Monte Carlo model, compare simulated statistics with theory, and retain reports without expecting identical random results.

Analysis and modeling · Intermediate

Unclassified: check guide

Guide’s version scope

Gnumeric 1.12.62 GTK desktop source and upstream 1.12 manual; English controls; documentation-qualified, not native-tested or a 1.12.57 runtime claim

Run two-factor ANOVA with and without replication

Set rows per sample correctly for two-factor ANOVA, reconcile sums of squares, and avoid claiming an interaction test without replication.

Analysis and modeling · Intermediate

Unclassified: check guide

Guide’s version scope

Gnumeric 1.12.62 GTK desktop source and upstream 1.12 manual; English controls; documentation-qualified, not native-tested or a 1.12.57 runtime claim

Solve an integer-constrained planning model

Solve a small mixed-integer-capable planning model and prove why rounding the continuous relaxation is not an acceptable substitute.

Workbook workflows · Intermediate

Unclassified: check guide

Guide’s version scope

Gnumeric 1.12.62 GTK desktop source and upstream 1.12 manual; English controls; documentation-qualified, not native-tested or a 1.12.57 runtime claim

Test a Contingency Table for Independence in Gnumeric

Run Gnumeric's chi-squared independence analysis with numeric counts, correct labels, expected-count checks and an independently checked example.

Statistical analysis · Intermediate

Unclassified: check guide

Advanced

Compare Independent Sample Means in Gnumeric

Choose Gnumeric's unpaired equal-variance t, Welch t or known-variance z tool and check one original example without confusing independent and paired data.

Statistical analysis · Advanced

Unclassified: check guide

Run One-Way ANOVA in Gnumeric with Sample Data

Use Gnumeric ANOVA: Single Factor with three small groups, interpret F and degrees of freedom, and check the arithmetic by hand.

Hypothesis testing · Advanced

Unclassified: check guide