Data analysis of heights; Grouping and information extraction
1 次查看(过去 30 天)
显示 更早的评论
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
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 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!