How coins move -- second spreadsheet (original) (raw)
Related papers
Bitcoin is an innovative virtual currency, which has gained much commercial traction, yet is widely overlooked by the accounting profession. Due to its parallels with actual currencies and its growing use, accountants should be aware of what bitcoin is, including its risks and benefits, in order to properly leverage its business uses. Of the existing financial instruments, derivatives stand out in their potential to stabilize the bitcoin market. Bitcoin regulation is sparse, but evolving, especially in the face of the emerging bitcoin securities and derivatives markets. The accounting profession is poised to play a major role in facilitating the future of proper regulation and oversight of Bitcoin.
Computational Geometry: Theory and Applications, 2006
We consider combinatorial and computational issues that are related to the problem of moving coins from one configuration to another. Coins are defined as non-overlapping discs, and moves are defined as collision free translations, all in the Euclidean plane. We obtain combinatorial bounds on the number of moves that are necessary and/or sufficient to move coins from one configuration to another. We also consider several decision problems related to coin moving, and obtain some results regarding their computational complexity.
Algebraic and Scientific Thinking via Spreadsheets: The Unstacking Coins Model
Electronic Proceedings of the ICTCM Conference, Vol. 29, 2018
By starting with a stack of coins and removing four at a time, we construct a model with negative correlation. This investigation can have the linear regression model with its mathematical nature converted to the scientific nature (physical meaning of variables). Error can be investigated in a spreadsheet simulation to see how it influences results including model predictions. We can validate the model using US Mint data along with pooled group results for some interesting discussion.
Parthica, Vol. 13, 67-71. In Zhores Khachatryan, "The Tomb of Sisian (second Half of the 1st Century BC), 2011
Si prega di inviare manoscritti, dattiloscritti e stampati e la posta redazionale al seguente indirizzo: dott. Carlo Lippolis, Dipartimento di Scienze Antropologiche, Archeologiche e Storico-Territoriali, Via Giolitti 21/e, i 10123 Torino. I testi originali di contributi e/o recensioni sottoposti all'attenzione della redazione scientifica non saranno restituiti.
Percentile Plots and Other Methods of Graphing Coin Weights
Weights of large numbers of coins can be difficult to summarize and interpret. Several ways to plot data are discussed and the Percentile Plot is recommended, especially for comparing weights of two or more issues. Remark: This is now easy to do in a spreadsheet. Sort the weights lowest to highest. Rank them 1 to n. Make a column with 100*rank/(n+1). Make a scatterplot of that on the x-axis and the weights on the y-axis.
A simple method for the interpretation of coin hoard patterns
Dating historical events or artefacts by coins has a long tradition. The information contained in a closed ensemble of find coins, however, is higher than merely the age of the "terminal coin". Much of this additional information can be retrieved from the histogram of the ensemble. The paper describes a simple method for interpreting the "pattern" (or shape) of a coin hoard in terms of its coin circulation system (i.e. transport time, speed of circulation, etc.)
A Graphical Method for Analysing Chronological Patterns of Coin Sets (+ attached Excel file)
Notae Numismaticae - Zapiski Numizmatyczne, 2022
This paper presents a graphical method for analysing chronological patterns which can be successfully applied to coin sets (e.g. hoards) containing specimens dated within multiple, overlapping timespans of up to several dozen years. The timespans are considered rounded up to full years, i.e. the shortest timespan would be 1 year, while the longer ones could cover several, a dozen or more years. This works well, for example, with Roman coins from the Imperial period, or with some categories of medieval or modern European coinage. The method is based on a simple mathematical model and the values calculated for each year are presented in a graphical form (as values of a discrete function spread on a timeline) to show the chronological distribution of coins in percentage terms. Such distributions make sets of coins easy to compare. The method is much less effective when applied to precisely dated coins (e.g. with an accuracy of one year), like Roman coins from the Republican period, or certain categories of early medieval Islamic coins.
What can we learn from 'transitional' coins?
Coinage and history in the seventh century near east, 2020
A few rare coins combine obverses and reverses from two different phases of Arab-Byzantine coinage. Could these coins represent a transition from one phase to the next? This paper is identical to the published version, but corrects a misleading typo in the caption to Fig. 8 on p. 128
Applying Statistics and Computer Science to the study of big coin finds: an engineering approach
"Too Big to Study? Troppo grandi da studiare?", 2019
Any large amount of data raises processing and interpretation issues. Coin finds, particularly hoards made of several thousand pieces, are no exception. In front of a great number of specimens, a comprehensive study, conducted with methods usually applied to small finds, becomes a difficult target to achieve. Statistics, as well as Computer Science, can provide important analysis tools and solutions allowing the researchers to extract relevant information from finds data. This contribution will examine how Statistics and Computer Science can support the work of numismatists. It will present at an introductory level what is still available today and what could become affordable hopefully not too far in the future, going through the major pros and cons. It will be shown how large and articulated amounts of data – from denominations of coins to the mints of origin, from image descriptions to weights and diameters – can be managed and organized in a smart way along with coin images into a structured information system. The analysis will be carried out under an engineering perspective, always focusing on aspects such as application limits, implementation costs and the effort required in terms of human resources.