Computational Formulas Without Statistics Dummy On Spreadsheet Software

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 discusses 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 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.