turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Navigation
- Simcenter
- Forums
- Blogs
- Knowledge Bases

- Siemens PLM Community
- Simcenter
- Testing Knowledge Base
- LMS Test.Lab: Calculating Statistics from Time His...

- Article History
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Email to a Friend
- Printer Friendly Page
- Report Inappropriate Content

Siemens Experimenter

12-20-2017
09:21 PM

**LMS Test.Lab: Calculating Statistics from Time Histories**

Collected some time data and want to calculate statistics like maximums, minimums, and means? It is easy to calculate many different statistics and export them to Excel in LMS Test.Lab.

**Getting Started**

First, right click on the time file that statistics should be calculated upon and choose “Replace in Input Basket” as shown in *Figure 1*.

Using “Replace in Input Basket” clears out the current contents of the input basket. To add additional time files for analysis, right click on them and select “Add to Input Basket”.

Make sure that the ‘Time Data Selection’ worksheet is ON under ‘Tools -> Add-ins” from the main LMS Test.Lab menu.

**Time Data Selection**

In the ‘Time Data Selection’ worksheet, click on the button with a “…” in the upper left of the screen as shown in *Figure 2*.

Once the ‘Data Source Selection’ menu is open, make sure it is on ‘Input Basket’ and press the ‘Replace’ button. The time data channels will appear on the left side.

Optionally, before calculating the statistics, the time history channels can be viewed as shown in *Figure 3*.

Viewing the time histories has no bearing on the statistic calculations, it is just a convenience.

To calculate the statistics, click in the upper corner and toggle to ‘Single Value Statistics’ as shown in *Figure 4*.

An area for statistical calculations appears in the lower right of the ‘Time Data Selection’ worksheet.

Next, click on the words ‘Select Function…’ in the lower right as shown in *Figure 5*.

In the ‘Function Selection’ menu, highlight the desired statistical functions to be calculated on the left side of the dialog.

Functions include:

- MIN – The minimum value of the time history
- MIN_X – The time value where the minimum occurs in the time history
- MAX – The maximum value of the time history
- MAX_X – The time value where the maximum occurs in the time history
- RANGE – Difference between maximum and minimum
- MEAN – Sum of data values in time history divided by number of values, mean is important in fatigue life, see SN-Curve knowledge base article
- KURTOSIS_EXCESS – Indicates the “peakiness” of the data, see Kurtosis knowledge base article
- AND MORE…

Use the arrow key in the center to move the functions from the left to the right side to make the statistics active as shown in *Figure 6*.

Press ‘OK’ when finished. Press the word ‘Calculate’ in the lower right to compute the statistics as shown in *Figure 7*.

After the calculations are done and the statistics are available, it is possible to copy them to Excel. First click in the upper left corner of the statistics area to highlight all the cells (*Figure 8*).

After highlighting the cells, right click and choose ‘Copy’. Then open Excel, right click, and choose ‘Paste’.

All the values will be in Excel. Each row represents one channel, with all the selected statistics shown.

Hope this helps with calculating statistics from time files! Questions? Call us!

**Related Links**

- LMS Test.Lab Active Picture
- LMS Test.Lab Active Picture Plug-in
- LMS Test.Lab: Import/Export to Excel
- LMS Test.Lab : Documentation Tab
- LMS Test.Lab: Templates
- Time Signal Calculator Tips
- LMS Test.Lab Throughput Processing Tips

Labels:

- Article History
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Email to a Friend
- Printer Friendly Page
- Report Inappropriate Content

Related content

Follow Siemens PLM Software

© 2018 Siemens Product Lifecycle Management Software Inc