필터 지우기
필터 지우기

Data analysis of heights; Grouping and information extraction

조회 수: 1 (최근 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 CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

제품


릴리스

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by