Math Formulas Rumus Hasil =ROUND(234/8,2) 29.25 =ROUND(234/8,0) 29 =ROUND(234/8,-1) 30 Catatan, jika ingin membulatkan ke puluhan, ratusan atau ribuan dan seterusnya mana, parameter ke dua dalam fungsi round adalah "angka negative". Sebagai contoh -2 dalam contoh pembulatan 1000 dibagi 3 yaitu =ROUND(1000/3,-2), hasilnya adalah nilai 300. Fungsi RoundUp dan RoundDown Sedangkan fungsi Randbetween dapat dipergunakan untuk membangkitkan angka acak dengan batas atas dan batas bawah yang dapat anda tentukan sendiri. Rumusnya adalah =RANDBETWEEN(bottom,top). Parameter pertama adalah "bottom" yaitu batas angka terendah dan parameter ke dua "top" adalah batas angka tertinggi. Fungsi ini akan tersedia jika anda telah mengaktifka Analysis Toolpak Add Ins. Fungsi ini hanya menghasikan angka integer, jadi kalau ingin angka random yang tidak integer maka kita dapat menggunakan Fungsi Rand dan mengalikannya dengan Fungsi RandBetween sehingga menghasilkan angka acak yang tidak integer (contoh =RAND()*RANDBETWEEN (10,50)).
, 0 jika angka nol, dan -1 jika angkanya negatif.
Tuesday, September 16, 2008
Fungsi-Fungsi Matematik dlm Excel
Saturday, August 9, 2008
Matrix Theory
Matrix theory is a branch of mathematics which focuses on the study of matrices. Initially a sub-branch of linear algebra, it has grown to cover subjects related to graph theory, algebra, combinatorics, and statistics as well.
The term matrix was first coined in 1848 by J.J. Sylvester as a name of an array of numbers. In 1855, Arthur Cayley introduced matrix as a representation of linear transformation. This period was considered as the beginning of linear algebra and matrix theory. The study of vector space over finite field, a branch of linear algebra which is useful in coding theory, naturally leads to the study and use of matrices over finite field in coding theory.
Module is a generalization of vector space. It could be considered as a vector space over ring. It leads to the study of matrices over ring. Matrix theory in this area is not often considered as a branch of linear algebra. Among the results listed in Useful theorems, Cayley-Hamilton Theorem is valid if the underlying ring is commutative, Smith normal form is valid if the underlying ring is a principal ideal domain, but others are valid for only matrices over complex numbers or real numbers.
The motivation of linear algebra and the first use of matrices, is the study of systems of linear equations. Related concepts such as determinant and Gaussian elimination, exist long before the introduction of the idea of matrices, now are part of the matrix theory.
Magic squares and Latin squares, two ancient branches of recreational mathematics, are now reformulated using the language of matrices. The link between Latin square and coding theory demonstrates that it is not merely a coincidence. If these two branches are taken into account, we can push back the origin of matrix theory to as far as 650 BC.
With the advance of computer technology, we are now able to solve a system of a large number of linear equations, not just in theory. John von Neumann and Herman Goldstine introduced condition numbers in analyzing round-off errors in 1947. Later, different techniques to calculation, multiplication or factorization of matrices were invented, such as the Fast Fourier Transform.
Payoff matrix in game theory, another field pioneered by John von Neumann, might be the first use of matrices in economics.
Simplex algorithm, a technique involving the operations of matrices of very large size, is used to solve operations research problems, a field strongly related to economics. Flow network problem, a branch of both graph theory and linear programming, can be solved using simplex algorithm -- but there are other more efficient methods.
There are other uses of matrices in graph theory. For example, the adjacency matrix is a representation of undirected graph.
The adjacency matrix is a type of nonnegative matrix. Permutation matrices, the matrix representation of permutations in combinatorics, are also nonnegative matrices. Another important matrix in combinatorics is the Hadamard matrix.
A useful type of nonnegative matrices are the stochastic matrices and doubly stochastic matrices. Stochastic matrices are useful in the study of stochastic processes, in probability theory and in statistics. The evaluation of an enormous stochastic matrix is the central idea behind the PageRank algorithm used by Google. It is worth to state that each doubly stochastic matrix is a convex combination of permutation matrices.
Another important tool in statistics is the correlation matrix.
Computer graphics also involve heavy computation of matrices. For example, a search for a way to minimize the memory needed for best quality of graphics.
For optimization problems involving multi-variable real-value functions, Positive-definite matrices occur in the search for maxima and minima.
There are also practical uses for matrices over arbitrary rings (see Matrix ring). In particular, matrices over polynomial rings are used in control theory.
On the pure mathematics side, matrix rings can provide a rich field of counterexamples for mathematical conjectures, amongst other uses. The square matrices also plays a special role, because the n×n matrices for fixed n have many closure properties.
Further, on the mathematics side, in an nxn' matrix, there are natural rows and columns which define the matrix to actually be n x n. If a matrix can be reduced down to its simplest form where the natural rows do not = n and the natural columns do not = n than that matrix is not square or n x n.
Useful theorems
Wednesday, August 6, 2008
Sets of Real Numbers
- A set is a collection of objects.
- An object in a set is called an element of that set.
- Different type of integers:
- Set of Positive Integers = {1,2,3, ...}
- Set of Negative Integers = (..., -3,-2,-1}
- The real-number line is shown as:
Some Properties of Real Numbers
- Important properties of real numbers
If a=b and b=c then a=c
2. The Closure Properties of Addition and Multiplication
3. The Commutative Properties of Addn and Multiplicationition
4. The Commutative Properties of Addition and Multiplication
5. The Identity Properties
6. The Inverse Properties
7. The Distributive Properties
Review of Algebra
The Objective of Review Algebra
- To be familiar with sets, real numbers, real-number line.
- To relate properties of real numbers in terms of their operations.
- To review the procedure of rationalizing the denominator.
- To perform operations of algebraic expressions.
- To state basic rules for factoring.
- To rationalize the denominator of a fraction.
- To solve linear equations.
- To solve quadratic equations.
Content of Review Algebra:
- Sets of Real Numbers
- Some Properties of Real Numbers
- Exponents and Radicals
- Operations with Algebraic Expressions
- Factoring
- Fractions
- Equations, in Particular Linear Equations
- Quadratic Equations
MATHEMATICAL for BUSINESS
Review of Algebra
Applications and More Algebra
Functions and Graphs
Lines, Parabolas, and Systems
Exponential and Logarithmic Functions
Mathematics of Finance
Matrix Algebra
Linear Programming
Introduction to Probability and Statistics
Additional Topics in Probability
Limits and Continuity
Differentiation
Additional Differentiation Topics
Curve Sketching
Integration
Methods and Applications of Integration
Continuous Random Variables
Multivariable Calculus