Data analysis of heights; Grouping and information extraction

Hi there,
I have recorded some measurements of height in two columns with there corresponding times they were taken at (image attached).
I am quite unfamiliar in matlab and was wondering if someone could give me some pointers in data analysis.
- Place in the matrix of my recorded heights into matlab
- Highlight values over 2.5mm for both column "Height 1" and "Height 2"
- Where values over 2.5mm are following each other (as shown in red); group these values together as a “slug 1, 2, 3 etc”
- Find out average height and length of each "slug"
- Find out (time) distance between each "slug"
- Find out (time) distance between "slug 1 of the height 1" column and "slug 1 of height 2 column". These could be labelled "slug 1a" and "slug 1b".
Essentially I would like to group these slugs in red and create an automated process of data analysis.
Many Thanks for any information or help you could spare!!!!

1 Comment

What do yo umean by "Highlight values over 2.5mm for both column"? Do you mean that you want the cells in your Excel worksheet to be filled with a background color other than white?
What do you mean by "slug"? Do you mean a run of consecutive array elements?
Have you tried just doing
slugs = vec > 2.5;
where vec is each column vector? Or do you need help calling xlsread()?

Sign in to comment.

Answers (0)

Products

Release

R2018b

Asked:

on 15 Mar 2019

Commented:

on 21 Mar 2019

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!