Data analysis of heights; Grouping and information extraction
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaire
Image Analyst
le 21 Mar 2019
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()?
Réponses (0)
Voir également
Catégories
En savoir plus sur Data Import and Analysis dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!