Gnumeric learning centre
Gnumeric Statistics, Data Analysis and Scientific Tutorials
Learn Gnumeric beyond basic formulas. These guides use small downloadable datasets to explain statistical analysis and scientific workflows. The expected values are independently checked; steps based on the official manual are not yet verified in the application. For function syntax, explore the Gnumeric function index.
15 practical tutorials · Official documentation reviewed; native checks pending
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 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
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
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
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
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