Origin provides tools for user to generate basic statistics for rows in worksheet.
In this blog post we will discuss the tools to generate row-wise statistics:
- Using the “Statistics on Rows” menu
- Rowstats x-function for non-contiguous data/multiple sheet
- Pros and cons of the two methods
Using the “Statistics on Rows” menu
To generate the basic statistics row by row, choose menu Statistics> Descriptive Statistics> Statistics on Rows.
The dialog provides over 30 options and interactive GUI for user to calculate descriptive statistics on rows for contiguous data
Statistics on rows for non-contiguous data/Multiple Sheet
While the Statistics on Rows menu provides advanced settings and interactive GUI to user, there is another quick way, rowstats, which enables to get row-wise statistics for more flexible input data range. The rowstats x-function supports seven outputs
- Mean
- Standard Deviation (SD)
- Standard Error of Mean (SE)
- Minimum
- Maximum
- Number of Points
- Sum
CASE-1. Statistics on rows for non-contiguous data
Sometimes the data are stored in non-contiguous columns, or non-contiguous rows. The rowstats x-function can help to generate row-wise statistics on selected ranges.
- Open the Script Window from Window: Script Window menu
- Press Ctrl key to select non-contiguous ranges in worksheet
- Type the following in the Script Window, then press Enter:
rowstats
- The row-wise statistics for selected range will be generated in the columns next to the input column
CASE-2. Statistics on rows from multiple sheet
If the data are stored in different worksheet/workbook and you want to create a new workbook for the statistics on each row of certain columns, you can also use the rowstats x-function.
- Prepare a worksheet to store the results
- Open the Script Window from Window: Script Window menu
- Type the following in the Script Window, then press Enter:
rowstats -d
- In the opened dialog, click the Triangle button to the right of Input. Choose Select Columns… from the context menu to specify columns in different sheet in the Column Browser.
- Click Interactive button to the right of desired outputs, now which are Mean 、 Standard Deviation. And select columns in the prepared worksheet.
Pros and cons of the two methods
Statistics on Rows menu | rowstats x-function | |
Input | Only allow the same sheet | Flexible, can be from any sheet |
Computation Control | Yes | No |
Output Quantities | 30+ | 7 |
Run as Labtalk | Maybe, very hard | Straight forward |
Dialog | Nice | x-function, can be opened with “-d” |
Where can I find the formula of the Statistics? Like the Geometric Mean and Geometric SD.
Sorry for the late reply.
U can press F1 in any Origin dialog or ? button on top of the dialog to find help.
E.g. for stats on rows dialog, press F1 will go to
https://www.originlab.com/doc/Origin-Help/Statistics-on-Rows?f=dl
Then click the “The Statistics on Rows Dialog Box” link on the bottom to go to https://www.originlab.com/doc/en/Origin-Help/DescStatsRow-Dialog
All output and algorithms are listed there.
Thanks, Snow