I have a task for Column J which consists of 2000 samples to record in another column the variance of each subsequent 100 values(it`s mean 20 values). In my case, I had to do it manually by changing in the top the range of the calculation. Like from 1 to 1, next 2 to 2 and so on. Is it possible to set the number of values in the series and to do automatic calculation of variance values? Thank you.
One way of doing this would be to create a new column and use set column values to fill it with: (int((i-1)/100)+1) This should create a column which counts from 1 to 20, you can then right click on the column you want to analyze (column J) and select Statistics on Column.
In the dialog box you will want to be sure that column J is listed as the Data Range, and that the new column counting from 1 to 20 is your Grouping Range. Under Quantities to Compute, you will want to be sure Variance is checked, along with any other measures you with to compute.
If you click OK this will create 2 new worksheets containing the results. Let me know if this doesn't work for you.
Statistics for N samples in column
Posted - 04/11/2013 : 08:16:58 AM
