LabPlot/DataContainers/Spreadsheet

Basic Concepts

The spreadsheet is the main part of LabPlot when working with data and consists out of columns. Column is the basic data set in LabPlot used for plotting and data analysis. Every column of the spreadsheet is specified by its name and the type - numeric, text, month names, day names and date and time. Also, for each type different representation formats can be assigned like decimal or scientific format for numeric columns etc.

In addition to these properties it is also possible to specify the plot designation - LabPlot is using this property in some places to to automatically recognize how to plot the data and which columns to use as X, Y, etc.

Import Data

See the video on how to import e.g. an SPSS file and export it to text.
{{#ev:youtube|GmGzv6a_5Jk|800|center}}

Generate Data

See the video on wow to generate and visualize random numbers from the Uniform, Normal (Gaussian), Binomial, Poisson, Weibull and many more distributions in LabPlot.
{{#ev:youtube|IBjgNkxJePg|800|center}}

Mask Data

Sometimes it is required to ignore some data points in the visualization or when performing some data analysis like fitting etc. To exclude some data points from plotting and data analysis without deleting them, masking of those data points can be used. You can mask the selected data points in the spreadsheet (Selection/Mask Selection from the spreadsheet cell context menu).

In the example below a fit was performed to the original data was performed containing some obvious measurement errors and a fit where those outliers were masked. TODO: screenshot with two fits

Descriptive Statistics

See the video on how to quickly get descriptive statistics with visualization.
{{#ev:youtube|2dJ19VCKRho|800|center}}

Baseline Subtraction (Correction)

See the video on how to perform Baseline Subtraction in LabPlot.
{{#ev:youtube|Fl2fACGlYrY|800|center}}