Paternity analysis using microsatellite information is a well-studied subject. These markers are ideal for parentage studies and fingerprinting, due to their high-discrimination power. This type of data is used to assign paternity, to compute the average selfing and outcrossing rates and to estimate the biparental inbreeding. There are several public domain programs that compute all this inform...

Soil classifiers have taken their lead from biologists but have not produced an internationally accepted system even though the WRB is supported by the IUSS. More recently Mazaheri et al. (1995a, 1995b) have tried to introduce Fuzzy logic into soil classification. They achieved a small amount of success when their technique was applied to selected soils in Australia but failed when applied to o...

Excel 2013 (version 15) includes an add-in 'Inquire' 1 for auditing spreadsheets. We describe the evolution of such tools in the third-party marketplace and assess the usefulness of Microsoft's own add-in in this context. We compare in detail the features of Inquire with similar products and make suggestions for how it could be enhanced. We offer a free helper add-in that in our opinion correct...

We analyze the performance of a genetic algorithm (GA) we call Culling, and a variety of other algorithms, on a problem we refer to as the Additive Search Problem (ASP). We show that the problem of learning the Ising perceptron is reducible to a noisy version of ASP. Noisy ASP is the first problem we are aware of where a genetic-type algorithm bests all known competitors. We generalize ASP to k...

In this paper, we present Tablexcel, a tabletop interface to Microsoft Excel. Single-user, desktop-based computer applications are pervasive in our daily lives and work. An application like Microsoft Excel, a widely deployed spreadsheet application, is used by a large number of businesses and users. Often, several users will collaborate on the creation of a spreadsheet, for example exchanging E...

著者ら [1]は,2011年の東日本大震災後に見られ た情報リテラシーにかかわる問題点を論じた際に, 公開されたデータの機械可読性の低さを指摘した。 それらのデータは,Excel に入力されていながら, 公開情報が PDF だけであったり,時にはデータ抽 出禁止の設定がなされていたり画像化されていたり して,集約や再解析にたいへん手間がかかった。 しかし,震災データに限らず,政府統計の総合窓 口 e-Stat [3] や自治体などで公開されているデータ を調べるにつれて,そもそも Excelへの入力の段階 でデータの再利用を考えず,罫線を多用した紙の帳 票作成を最終目的とするものが多いことに気づい た。こうしたデータは,PDFでなく Excelファイル (またはそれから生成した CSVファイル)で公開さ れたとしても,データを再解析するには余計な手間 がかかる。 こうした巧妙だがデー...

Spreadsheets, and MS Excel in particular, are established analysis tools. They offer an attractive user interface, provide an easy to use computational model, and offer substantial interactivity for what-if analysis. However, as opposed to RDBMS, spreadsheets do not provide a central repository hence they do not provide shareability of models built in Excel and lead to proliferation of multiple...

Numerous statistical and graphical problems have been reported for different versions of Microsoft Excel, including the newest version (Excel 2007). We report newly discovered problemswith Excel 2007when generating polynomial trend line equations, having a userspecified (forced) intercept, from graphed data. We also remind users of Excel’s Trendline function of problems with Excel 2003 that hav...

Survival curves are frequently used for reporting survival or mortality outcomes of experimental pharmacological/toxicological studies and of clinical trials. Microsoft Excel is a simple and widely used tool for creation of numerous types of graphic presentations however it is difficult to create step-wise survival curves in Excel. Considering the familiarity of clinicians and biomedical scient...

Some of the problems that rendered Excel 97, Excel 2000 and Excel 2002 unfit for use as a statistical package have been fixed in Excel 2003, though some have not. Additionally, in fixing some errors, Microsoft introduced other errors. Excel’s new and improved random number generator, at default, is supposed to produce uniform numbers on the interval (0,1); but it also produces negative numbers....