Data analysis of heights; Grouping and information extraction

2 次查看（过去 30 天）
R MONTGOMERY
R MONTGOMERY 2019-3-15
评论： Image Analyst 2019-3-21
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 个评论
Image Analyst
Image Analyst 2019-3-21
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()?

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息

标签

产品


版本

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by