|
XNUMBERS
XNUMBERS is a multi-precision floating point computing and numerical methods library for Microsoft Excel. Xnumbers claims to be an open source Excel addin (xla), the license however is not an open source license. XNUMBERS performs multi-precision floating point arithmetic from 15 up to 200 significant digits. The version 5.6 as of 2008 is compatible with Excel 2003/XP and consists of a set of more than 300 functions for arithmetic, complex, trigonometric, logarithm, exponential calculus. The Foxes team members (around Leonardo Volpi) stopped their development efforts in 2008. Recently, an American astronomer had his brother John Beyers make the Italian versions compatible to recent versions of Microsoft Excel/Windows/VisualBasic. Several forked versions are made available in the last section of the astronomer's homepage, entitled "Downloads and links". Screenshots External links XNUMBERS 6.0.5.6 for Excel- John Beyers, last update 11 Dec 2013 XNUMBERS 5.6 for Excel - Foxes Te ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Floating Point
In computing, floating-point arithmetic (FP) is arithmetic that represents real numbers approximately, using an integer with a fixed precision, called the significand, scaled by an integer exponent of a fixed base. For example, 12.345 can be represented as a base-ten floating-point number: 12.345 = \underbrace_\text \times \underbrace_\text\!\!\!\!\!\!^ In practice, most floating-point systems use base two, though base ten ( decimal floating point) is also common. The term ''floating point'' refers to the fact that the number's radix point can "float" anywhere to the left, right, or between the significant digits of the number. This position is indicated by the exponent, so floating point can be considered a form of scientific notation. A floating-point system can be used to represent, with a fixed number of digits, numbers of very different orders of magnitude — such as the number of meters between galaxies or between protons in an atom. For this reason, floating-poi ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Numerical Methods
Numerical analysis is the study of algorithms that use numerical approximation (as opposed to symbolic manipulations) for the problems of mathematical analysis (as distinguished from discrete mathematics). It is the study of numerical methods that attempt at finding approximate solutions of problems rather than the exact ones. Numerical analysis finds application in all fields of engineering and the physical sciences, and in the 21st century also the life and social sciences, medicine, business and even the arts. Current growth in computing power has enabled the use of more complex numerical analysis, providing detailed and realistic mathematical models in science and engineering. Examples of numerical analysis include: ordinary differential equations as found in celestial mechanics (predicting the motions of planets, stars and galaxies), numerical linear algebra in data analysis, and stochastic differential equations and Markov chains for simulating living cells in medicine and ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Microsoft Excel
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel forms part of the Microsoft Office suite of software. Features Basic operation Microsoft Excel has the basic features of all spreadsheets, using a grid of ''cells'' arranged in numbered ''rows'' and letter-named ''columns'' to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering, and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives (using '' pivot tables'' and the ''scenario manager''). A PivotTable is a tool for data analysis. ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Significant Digits
Significant figures (also known as the significant digits, ''precision'' or ''resolution'') of a number in positional notation are digits in the number that are reliable and necessary to indicate the quantity of something. If a number expressing the result of a measurement (e.g., length, pressure, volume, or mass) has more digits than the number of digits allowed by the measurement resolution, then only as many digits as allowed by the measurement resolution are reliable, and so only these can be significant figures. For example, if a length measurement gives 114.8 mm while the smallest interval between marks on the ruler used in the measurement is 1 mm, then the first three digits (1, 1, and 4, showing 114 mm) are certain and so they are significant figures. Digits which are uncertain but ''reliable'' are also considered significant figures. In this example, the last digit (8, which adds 0.8 mm) is also considered a significant figure even though ther ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
