Statistical Analysis of Experimental Data

Experimental Data Analyzer

Client-side analysis of X,Y observation pairs. Your file is processed locally in the browser.

Select a text file containing one X,Y pair per row. Data are processed locally in your browser.

X / Y relationship

Scatter plot with the selected least-squares regression model.

Descriptive statistics

Regression diagnostics

Data validation

Statistical notes

These notes summarize the statistical definitions and interpretations used by the calculator.

Introduction

Statistical analysis is useful when experimental observations vary from one measurement to another. An experiment may be regarded as deterministic, when the observable is expected to give the same value under the same conditions, or random / non-deterministic, when repeated experiments may produce different outcomes under the same conditions.

A collection of observations can be regarded as a sample from a population. In practice, experimental limitations usually prevent the entire population from being observed, so a sample is used to obtain estimates such as the mean and variance of the population. When population values have an equal chance of being included, the sample is described as random and the resulting quantities are sample estimates.

Numerical descriptive measures help summarize the relative-frequency distribution of a data set. They include measures of central tendency, which describe the centre; measures of variation, which describe spread; and measures of relative standing, which describe the position of an observation within the data set.

Quantities computed from a sample are called statistics, whereas corresponding quantities describing a population are called parameters. It is also useful to distinguish model-independent procedures, such as descriptive statistics and correlation, from model-dependent procedures, such as least-squares fitting.

Sample mean

The sample (arithmetic) mean estimates the value around which the observations centrally cluster.

x̄ = (1 / n) Σ xᵢ

Sample variance and standard deviation

The calculator uses the sample variance and sample standard deviation. For n observations:

s² = Σ(xᵢ − x̄)² / (n − 1)     s = √s²

The use of n − 1 in the sample variance provides an unbiased estimate of the population variance under the stated sampling convention.

An alternative computational form of the variance can reduce the effect of rounding errors. More generally, if a distribution has no finite second moment, variance and standard deviation are not useful measures of its width and estimates may fail to converge consistently as more observations are collected.

For approximately mound-shaped (for example, Gaussian) distributions, the familiar rules of thumb are about 68% within one standard deviation, 95% within two, and almost all observations within three standard deviations of the mean. These are distribution-dependent rules of thumb, not guarantees for arbitrary data.

Skewness and kurtosis

Skewness and excess kurtosis are defined here from standardized central moments:

skewness = Σ(xᵢ − x̄)³ / (n s³) excess kurtosis = Σ(xᵢ − x̄)⁴ / (n s⁴) − 3

Bias-corrected sample skewness and excess kurtosis are also reported separately and explicitly labelled, so the two conventions are not silently conflated.

Least squares and regression

Regression can be used to estimate the mean value of a dependent response y or predict a future value of y from one or more related independent variables. The principal model here is simple linear regression relating y to a single independent variable x.

The regression model describes the mean value of y for a given x by a straight line of means, with individual observations deviating from that line by random errors. The fitted prediction equation is:

ŷ = b + ax

The usual simple linear regression assumptions include zero mean error, constant error variance, normally distributed errors, and independence of errors.

The least-squares method selects the fitted line by minimizing the sum of squared deviations between observed and predicted values. This is a stronger criterion than merely minimizing the signed sum of deviations, because different lines can have errors whose signed sum is zero. A straight line can be fitted to any set of points even when the underlying relationship is not linear.

The fitted coefficients act as estimators: the intercept estimates the point where the fitted line crosses the y-axis, while the slope describes the change in the fitted response associated with a change in x. For simple linear regression, the error-variance estimate is associated with n − 2 degrees of freedom.

The calculator reports the Pearson correlation coefficient, coefficient of determination (R²), residuals, Sum of Squared Errors (SSE), Mean Squared Error (MSE), Root Mean Squared Error (RMSE), and Mean Absolute Error (MAE) to describe the fitted model.

Chi-squared statistics

A chi-squared calculation for a fitted line can be expressed using the following non-standard form, with the sum of observed and expected values in the denominator, together with an incomplete-gamma significance calculation.

Σ[(observed − expected)² / (observed + expected)]

The significance calculation uses the incomplete gamma function with a degrees-of-freedom parameter described as the number of observations minus the number of constraints. Except for special integer cases, the gamma integral does not have a closed-form expression and its cumulative distribution must therefore be obtained by approximation.

When applied to continuous observations versus regression predictions, this expression is not treated as a statistically valid regression goodness-of-fit test. Regression diagnostics therefore use R², SSE, MSE, RMSE, and MAE. A chi-squared goodness-of-fit feature should use an explicitly specified count/expected-frequency or measurement-error model.

The statistical notes define the conventions used by the calculator and distinguish the non-standard chi-squared expression above from a conventional Pearson goodness-of-fit statistic.