Hi,
I'd like to calculate the area of a non-normal distribution set of numbers.
The set of numbers are in rows in series of 20 records.
Each serie can have a different distribution, so some might be close to Normal while others won't be
Ideally i need a function that can approx for any series so i can drag down and add the Area result in a new field
The original data has thousands of series.
<colgroup><col width="64" span="21" style="width:48pt"> </colgroup><tbody>
</tbody>
I'd like to calculate the area of a non-normal distribution set of numbers.
The set of numbers are in rows in series of 20 records.
Each serie can have a different distribution, so some might be close to Normal while others won't be
Ideally i need a function that can approx for any series so i can drag down and add the Area result in a new field
The original data has thousands of series.
ID | BS1 | BS2 | BS3 | BS4 | BS5 | BS6 | BS7 | BS8 | BS9 | BS10 | BS11 | BS12 | BS13 | BS14 | BS15 | BS16 | BS17 | BS18 | BS19 | BS20 |
62160 | -30.5 | -34.5 | -37.5 | -33 | -29.5 | -27 | -25.5 | -25.5 | -25.5 | -26.5 | -28 | -30.5 | -34.5 | -42 | -43.5 | -39 | -36 | -34 | -33 | -32.5 |
62161 | -29.5 | -30 | -31 | -31 | -30 | -30 | -30.5 | -31.5 | -34 | -36 | -33 | -29 | -26.5 | -25 | -24.5 | -25.5 | -27.5 | -32 | -39 | -34.5 |
62162 | -23.5 | -23.5 | -24 | -25 | -27 | -29.5 | -32 | -34 | -37.5 | -39.5 | -35.5 | -30.5 | -27 | -24.5 | -23.5 | -23.5 | -23.5 | -24.5 | -26.5 | -30 |
62163 | -32.5 | -31 | -30 | -30 | -30.5 | -31.5 | -33.5 | -37 | -45 | -44.5 | -38.5 | -37 | -37.5 | -39 | -40.5 | -44 | -48.5 | -51.5 | -48.5 | -45 |
62164 | -33.5 | -30 | -28 | -27 | -27.5 | -28 | -29.5 | -30.5 | -31.5 | -31.5 | -31 | -30.5 | -30 | -28.5 | -27.5 | -27 | -27.5 | -28.5 | -29.5 | -30 |
<colgroup><col width="64" span="21" style="width:48pt"> </colgroup><tbody>
</tbody>