emblem
Get data from Excel
  Template to get data (copy-paste) from Excel.
2024.Jul.03 18:23:16
Header, transpose Data have header ? Transpose ? •
Data Data for two samples (with spaces or tabs). For missing data, insert -1.E+99 (i.e., ≤ this value)

Decimal mark (here): either ',' or '.' .   •
α % Level of significance. •
Variance   Variance (unknown) equal or unequal. •
Show values ? Shows the graph coordinates.

Computes, from two samples with unknown, unequal mean and standard deviation, a confidence interval for the difference of the means. This is essentially a template for easy introduction of data, namely, via copy and paste from source documents, such as an Excel sheet or a 'pdf' file. (For the base samples, the interval, for α = 1 %, is (0.697, 3.303) .)

Missing data are allowed, given as mentioned.

A graph is drawn showing the two sample data.

References: Plate: GetDataTemplate

• Ponce, V. M., "Vlab" (OnlineCalc), San Diego State University, San Diego (CA), USA.

• Arsham, H., "Descriptive Statistics", University of Baltimore, Baltimore (MD), USA.

• 1845-11-14: Dini, Ulisse (1919-10-28).

 
 
Valid HTML 4.01! IST http://web.ist.utl.pt/~mcasquilho/compute/qc/Fx-getFromExcel.php
Created: 2016-11-13 — Last modified: 2016-11-17