Valid HTML 4.01 Transitional Valid CSS! Level A conformance icon, W3C-WAI Web Content Accessibility Guidelines 1.0

SStatist, version 0.9.2

Statistical supplement for the spreadsheet (Calc, Excel)

2017/07/14 Version

La senyera Bandera espaņola

It's a program of free distribution and open source (*). See the page, fom:

SourceForge.net Logo

Download

Click, directly, here (Nullsoft program installer, 3.02MB).

Introduction

This program is an statistical supplement for your spreadsheet:

Make statistical calculations in the data cells imported from your spreadsheet (Calc, Excel). The result of the calculations with these data is already copied to the clipboard for easy copy it back to your spreadsheet.

From two possibilities:

Qualitative data categorized into a contingency table

Descriptive statistics

Sums (by columns and rows) and percentages (by columns, rows and matrix), and the confidence interval of percentages.

Comparative analysis

Between two or among various qualitative samples.

Between a sample and theoretical population.

Using the chi-square test with Yates correction (when it can accurately and adjust the limit), and using the Fisher's exact test in the 2x2 crosstab case.

Other

Grouping rows and/or columns.

Quantitative data from one to several lists of numbers

Descriptive statistics

Counting, minimum and maximum values, mean, mean ± standard deviation different values, different percentiles (including median or P50) and can display the confidence interval for the mean and median.

Analysis of the probability distribution for each sample includes: skewness, kurtosis and the Ryan-Joiner test as normality test.[1][2]

Grouping of data to facilitate the representation in a bar chart, with the suggestion of the minimum value and the size of the interval group.

Comparative analysis

Among several independent samples: ANOVA and/or Kruskal-Wallis tests.

Between two paired samples: paired t and/or Willcoxon tests.

Between two (or more) samples: Pearson and Spearman correlation coefficients.

(*) The program is free software, you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation. You can download the source, in Object Pascal (Delphi): here (in zip file, 3,19MB).

Go to page beginning