need function help with array formulas

[Scott R]

I'd like one formula to do all the work to produce the answer in E16.
The input cells are in B3:D5 and B7.
In other words, I'd like the input cells within the formula rather than in other cells.

Thanks!

GARCH reverse engineer.xlsm
	A	B	C	D	E
1		time-->
2	data set #	1	2	3
3	1	3	7	10
4	2	1	2	6
5	3	1	3	7
6
7	1	2.00	2.83	4.76
8	2	2.00	2.00	2.45
9	3	2.00	2.00	2.83
10
11	1	6.00	19.80	47.57	73.37
12	2	2.00	4.00	14.70	20.70
13	3	2.00	6.00	19.80	27.80
14					28.58
15					28.58
16					28.58
function

Cell Formulas
Range	Formula
C7:D9	C7	=SQRT( B11 + B7 )
B8:B9	B8	=B7
B11:D13	B11	=B3 * B7
E11:E13	E11	=SUM(B11:D11)
E14	E14	=STDEV.S(E11:E13)
E15	E15	=STDEV.S( BYROW( B11:D13, LAMBDA(r, SUM( r ))))
E16	E16	=STDEV.S( BYROW( B3:D5 * B7:D9, LAMBDA(r, SUM( r ))))

 

[Fluff]

How about

=LET(a,B3:B5*B7,b,SQRT(a+B7),c,b*C3:C5,d,SQRT(b+c),e,d*D3:D5,STDEV.S(BYROW(HSTACK(a,c,e),LAMBDA(br,SUM(br)))))

 

[Scott R]

Very cool. My concern is that I'd like to scale this up to a much larger array than 3x3.

 

[Fluff]

It would have helped if you had said that to start with.
I have no idea how to creat a single formula to work with any size array.

 

[Scott R]

Thought it would be a recursive formula. Maybe it's not possible.

 

[Fluff]

It's almost certainly possible, but I don't know how.