Gnumeric learning centre

Gnumeric Statistics, Data Analysis and Scientific Tutorials

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.

25 practical tutorials

Charts

Make an XY Scatter Plot with Paired Values in GnumericAssign separate X and Y ranges, check numeric spacing, and add axis labels and sensible bounds to a Gnumeric scatter plot.Beginner · Gnumeric

Cleaning data

Split an Existing Text Column in GnumericUse Text to Columns with delimiter and quote previews, preserve the source column, and leave room for the results on its right.Beginner · Gnumeric

Data entry and validation

Create Restricted Entries and Dropdowns in GnumericRestrict quantities to whole numbers from 1 to 10, or use a source-range dropdown in Gnumeric, with Stop alerts and clear tests.Beginner · Gnumeric

Data management

Audit Duplicate Records with Sort and Filter in GnumericFlag repeated order IDs and matching rows, sort a review copy, and use Gnumeric filters without deleting source records.Beginner · Gnumeric

File compatibility

Open and Save XLSX Safely in GnumericKeep the original XLSX, save an exchange copy, and verify formulas, dates, percentages and identifiers after reopening in Gnumeric.Beginner · Gnumeric

Forecasting

Exponential Smoothing in Gnumeric: Selecting a MethodUnderstand Gnumeric simple, Holt and Holt-Winters smoothing choices and avoid applying seasonal models to unsuitable data.Intermediate · Gnumeric Smooth Measurements with a Moving Average in GnumericCompare trailing and centered moving averages in Gnumeric with a simple series, expected values and common chart mistakes.Intermediate · Gnumeric

Formatting

Highlight Duplicate Values in Gnumeric with COUNTIFUse a COUNTIF expression in Gnumeric conditional formatting, fix the comparison range and test which duplicate cells should highlight.Beginner · Gnumeric

Hypothesis testing

Compare Before and After Measurements with GnumericLearn when to use a paired t-test in Gnumeric and follow a five-pair example with a checkable mean difference and t statistic.Advanced · Gnumeric Run One-Way ANOVA in Gnumeric with Sample DataUse Gnumeric ANOVA: Single Factor with three small groups, interpret F and degrees of freedom, and check the arithmetic by hand.Advanced · Gnumeric

Importing data

Import Semicolon CSV and Decimal Commas in GnumericSet Gnumeric’s text-import delimiter, numeric locale and text columns, then verify decimal-comma amounts and leading-zero codes.Beginner · Gnumeric

Optimization

Solve a Two-Product Optimization Problem in GnumericBuild a small linear programming model in Gnumeric Solver with two products, capacity constraints and a checkable optimal profit.Advanced · Gnumeric Use Goal Seek in Gnumeric to Find an Input ValueSet up a simple Gnumeric Goal Seek example, solve for an input cell, and identify the cases where iterative search may fail.Intermediate · Gnumeric

Printing and PDF output

Set a Print Area and Fit One Page in GnumericChoose a Gnumeric print range, set one-page scaling, repeat headings when needed, and verify readable printer or PDF output.Beginner · Gnumeric

Sampling

Take Random or Periodic Samples in GnumericLearn the difference between random and periodic sampling in Gnumeric and practice with 20 numbered records.Intermediate · Gnumeric

Scientific analysis

Kaplan–Meier Survival Analysis in GnumericUnderstand the Kaplan–Meier Gnumeric analysis tool, event versus censor coding, and the meaning of survival steps.Advanced · Gnumeric Principal Component Analysis (PCA) in GnumericPrepare numeric input for Gnumeric PCA, interpret eigenvalues and loadings, and avoid scale-related analysis mistakes.Advanced · Gnumeric Use Gnumeric Fourier Analysis on a Simple SignalPrepare a power-of-two time series for Gnumeric Fourier analysis and understand FFT bins, zero-padding and scaling.Advanced · Gnumeric

Sheet and cell protection

Why a Protected Cell Can Still Be Edited in GnumericSeparate a cell’s locked attribute from active sheet protection in Gnumeric, test input and formula cells, and understand the limits.Beginner · Gnumeric

Statistical analysis

Build a Histogram with Custom Bins in GnumericUse Gnumeric histogram cutoffs, bin boundaries and frequency output to understand numeric measurements without miscounting edges.Intermediate · Gnumeric Create a Correlation Matrix in GnumericUse the Gnumeric Correlation analysis tool to compare several measurement columns and interpret Pearson correlation.Intermediate · Gnumeric Create a Score-Ranking Report with Ties in GnumericGenerate a separate Gnumeric Ranks and Percentiles report, select average or top ranks and avoid misidentifying tied observations.Beginner · Gnumeric Create Category Frequency Tables in GnumericCount text categories with Gnumeric frequency analysis and avoid missing categories or accidental duplicate labels.Beginner · Gnumeric Descriptive Statistics in Gnumeric: Mean, SD and VarianceCalculate mean, standard deviation, variance and summary statistics in Gnumeric with a small downloadable dataset.Beginner · Gnumeric Fit a Linear Regression in GnumericRun Gnumeric regression analysis on X and Y data, read the intercept and slope, and avoid common input-range mistakes.Intermediate · Gnumeric