Posted to microsoft.public.excel.programming

external usenet poster

Posts: 44

Application.Stdev(multiDimensionArray) ?

Hello all,

I would like to be able to use the Application.Stdev(myArray) function
but "myArray" actually has two dimendions (1,10000). Is it possible
to use the function to calculate the stdev of just the second
dimension? Or, are there any slick work-arounds to segregate the
second disension for a particular row (0 or 1) without looping through
the array?

Thanks a lot!!

Trip

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
stdev of an array?	Monte Milanuk[_2_]	Excel Discussion (Misc queries)	3	July 20th 08 12:59 AM
how do I get STDEV() 2 sigma?	jimbo	Excel Worksheet Functions	4	January 25th 06 07:49 AM
STDEV	Kimo	Excel Discussion (Misc queries)	3	January 13th 06 02:51 PM
STDEV...HELP	JRH	New Users to Excel	5	January 22nd 05 08:47 PM
average and stdev	Jenny	Excel Programming	3	February 10th 04 08:05 PM

All times are GMT +1. The time now is 07:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us