By Made Wijana
wijanaimade@yahoo.com
ABSTRACT
Generally, statistics formula involving data summation of a random variable, product of a random variable, and summation of product several random variables and function of random variable. In implementing statistics formula in a worksheet of spreadsheet package software like Microsoft Excel we often need a dummy which can be a cell or collection of cells (range).
This paper discuss computation of statistics formula in a worksheet of spreadsheet package software like Microsoft Excel without a dummy which can be a cell or collection of cells (range). Computation of statistics formula in a worksheet of spreadsheet package software like Microsoft Excel can be done without a dummy by utilization function SUMPRODUCT.
Computation of statistics formula in without a dummy doesn’t need more cell or range as well as the size of file is smaller. However, the computation need a long formula and often it is quite complicated with functions which is possible that a function nest in other function.
.
Key Word: Statistics formula computation, Computation without a dummy, Computation in a spreadsheet
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment