Hi AndreaP88,
For Procedure A, please try the following for your XY worksheet (col(1) for the 1st column, col(2) for 2nd column):
1) Sort the worksheet on the X column ascending
2) Get min and max of X column by:sum(col(1));
sum.min=;
sum.max=;
3) Run the freq counts with:
- Set the Input to X column
- Turn OFF the "Auto" check box of the bin begin and end
- Enter the above min and max values there
- Select "Number of Bins" for Step By option, and enter the number of bins of your choice
4) Add extra column in the original XY worksheet, and run the following
script to set the group# in this extra column
/////////////////////////
range dest=1!col(3);
range ref=2!col(3);
NB=ref.getSize();
start=0;
gg=1;
for(ii=1; ii<=NB; ii++) {
NJ=ref[ii];
for(jj=1; jj<=NJ; jj++) {
dest[start+jj]=gg;
}
start=start+jj-1;
gg++;
}
dest[start+1]=gg-1; //for the last cell as max
/////////////////////////////5) For col(2), run Stats on Column such that:
- Set the Recalculate mode to None
- Grouping Range set to col(3) for mean and SD.
6) In the result, insert a column before the Mean, then
- copy-and-paste the bin centers in freq table in 3) into this new column.
- Set the designation of this column as X.
Hope this helps.
--Hideo Fujii
OriginLab
Basic Binning
Posted - 09/18/2014 : 05:04:16 AM
