Average/Standard Deviation/Max/Min of 2D Array

[esa_paranoid]

I am trying to read data from a spreadsheet file and calculate the average, standard deviation, max, and min values.

I can of course get the max and min using Array Max & Min.

I am having difficulty getting the average and standard deviation though; if anyone has ideas on how to do this I would appreciate it.

Thanks,
Ryan

[John Rich]

Which LabVIEW package do you have (Base, Full, or Professional)? If you have the base package then you will have to develop these functions on your own. If you have the full or professional packages then if you go to the Functions pallette and, under All Functions select Analyze, then select Mathematics, then select Probability and Statistics. You will find a function for Mean and for Standard Deviation on this pallette.

[altenbach]

The built-in Mean.vi from the advanced analysis palette does not do 2D arrays, so you would need ot reshape it to a 1D array.

Of course it would be also very simple to calculate these values using plain math. The attached VI (LabVIEW 7.0) shows both possibilities (Assuming Sample weighting for the variance). Enjoy!


(Everything should also work for 3-D and higher arrays).

Message Edited by altenbach on 06-07-2005 01:36 PM

[John Rich]

Oops. I missed the fact that this was a 2D array. Nice catch altenbach.

[esa_paranoid]

Hey guys, thanks a lot that was just what I needed...as simple as reshaping the array.....grrrrr

Thanks again for the help,
Ryan