THE USE OF LOTUS 1-2-3 IN STATISTICS

被引:9
作者
SUNDQVIST, C
ENKVIST, K
机构
[1] SWEDISH UNIV ABO,DEPT BIOL,SF-20500 ABO 50,FINLAND
[2] SWEDISH UNIV ABO,DEPT BIOCHEM & PHARM,SF-20500 ABO 50,FINLAND
关键词
COMPUTER PROGRAMMING - Spreadsheet - STATISTICAL METHODS - Statistical Tests;
D O I
10.1016/0010-4825(87)90057-6
中图分类号
Q [生物科学];
学科分类号
07 [理学]; 0710 [生物学]; 09 [农学];
摘要
This paper describes a convenient way of performing statistical tests in biology. The recent development of powerful spreadsheet programs for microcomputers has made it possible to easily apply various statistical significance tests on biological data. Presently the following tests have been implemented in the LOTUS 1-2-3 framework: Student's-test, chi-square test, analysis of variance (single classification random ANOVA), Student-Neumann-Kuels test, correlation analysis and analysis of linear regression (single and multilevel design). The most important advantages gained by using 1-2-3 instead of the commercial software packages are the simplicity of entering data, the possibility of asking 'what-if? ' questions, the simple, but useful graphical presentation of data and the ease of actual building of the tests.
引用
收藏
页码:395 / 399
页数:5
相关论文
共 13 条
[3]
SPREAD-SHEET ANALYSIS IN PHARMACOKINETIC SIMULATIONS [J].
CURRY, SH ;
LAIZURE, C ;
DEVANE, CL .
TRENDS IN PHARMACOLOGICAL SCIENCES, 1986, 7 (06) :220-223
[4]
ELECTRONIC SPREADSHEET PROGRAM FOR ESTIMATING 2-COMPARTMENT INTRAVENOUS PHARMACOKINETIC PARAMETERS BY LEAST-SQUARES LINEAR-REGRESSION ANALYSIS [J].
HOLMES, RA ;
WILSON, RC ;
MCCALL, JW .
INTERNATIONAL JOURNAL OF BIO-MEDICAL COMPUTING, 1986, 18 (3-4) :203-212
[5]
KLING B, 1985, ABCS LOTUS 1 2 3
[6]
EPIDEMIOLOGIC PROGRAMS FOR COMPUTERS AND CALCULATORS - APPLICATIONS OF MICROCOMPUTER SPREADSHEET PACKAGES AS ADJUNCTS TO MULTIPLE LOGISTIC-REGRESSION ANALYSIS [J].
LEMESHOW, S ;
PASTIDES, H ;
AVRUNIN, JS ;
TERES, D .
AMERICAN JOURNAL OF EPIDEMIOLOGY, 1985, 122 (04) :710-716
[7]
PLASMA-RENIN ASSAY CALCULATION USING LOTUS 1-2-3C [J].
MCCLUNG, DE ;
ZAWADA, ET ;
TERWEE, JA .
COMPUTERS IN BIOLOGY AND MEDICINE, 1986, 16 (05) :371-376
[8]
APPLICATION OF SPREADSHEET SOFTWARE TO X-RAY-MICROANALYSIS [J].
MOON, AR ;
NOCKOLDS, CE .
SCANNING, 1985, 7 (06) :307-308
[9]
Sachs L., 1982, APPL STAT HDB TECHNI
[10]
Sokal RR., 2011, BIOMETRY, V4th ed