Hello,
I have three sets named as ParameterArrrayRange(i) where i=1,2,3.
I want to calculate mean and variance of each set and have a 2*3 table named as "ary_statistics" in excel.
Here is what I've done:
But I get a Type mismatch error.
Please Login or Register to view this content.
Even when I change it to
it doesn't write anything in my matrix.Please Login or Register to view this content.
Could you please help me with these problems?
Thanks
Hi AnnaDanna,
I have no access to the "ary_statistics" range but see if this works:
Please Login or Register to view this content.
Last edited by xladept; 06-19-2013 at 03:47 PM. Reason: typo
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
thank you XLAdept, but it didn't work!
Is the only difference between my code and your that you don't define ParameterArrrayRange as a range?
Please Login or Register to view this content.
That and the last loop index - I got it clean up to the "ary_statistics" which I couldn't use. Can you post a sample which includes all the necessities for the routine?
I double checked, but the last loop is the same as mine.
I got a discrepancy when I pasted what you posted - how about the sample?
(Don't you love the alliteration?)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks