how to calculate Standard deviation of product of numbers?

[Guest]

There are 3 columns, A, B and C. Each column has 10 rows each containing
numbers. I need to find the standard deviation of the product of the numbers
in each row.
Eg:

a b c product
2 5 4 40
3 6 5 90
4 7 6 168

We need to find STDEV of the product column.
I need this without calculating the product separately just in one formula
which would give the stdev of the product.

 

[Richard Buttrey]

On Mon, 4 Jul 2005 03:51:03 -0700, "Mridull Putatunda" <Mridull

There are 3 columns, A, B and C. Each column has 10 rows each containing
numbers. I need to find the standard deviation of the product of the numbers
in each row.
Eg:

a b c product
2 5 4 40
3 6 5 90
4 7 6 168

We need to find STDEV of the product column.
I need this without calculating the product separately just in one formula
which would give the stdev of the product.

=STDEV(D211)

Assuming the '40' in the product column is in D2

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[sebas_cp]

={STDEV(A1:A3*B1:B3*C1:C3)}

as an array function with shift + ctrl + enter