How can I find the average trend of different eyes over a certain period of time?

조회 수: 1 (최근 30일)
Abu Tahir Taha
Abu Tahir Taha 2022년 11월 12일
답변: Vijay 2022년 11월 15일
Let's say I have the following eyes. Each one has values over the course of 24months. Some eyes don't have all the values and some have skipped visit ex: one eye will have 00 and 12 months only.
The question is, how can I find out the average trend of thes values when all the eyes are taken together, regardless of whether they're missing values?
A01_RE A02_LE A02_RE A04_LE A04_RE A06_LE A06_RE A07_LE A08_LE A08_RE A10_LE A11_LE A11_RE A12_LE A12_RE
0 0.03033122 0.12144678 0.06508164 0.02029037 0.01297442 0.16000093 0.27670777 0.26304544 0.14034749 0.25247002 0.32309307 0.18078347 0.35398569 0.11246246 0.08947128
6 0.00670107 0.02961666 0.12848723 0.13292378 0.13531435 0.15334971 0.23601226 0.19022655 0.24937335 0.32174122 0.21479842 0.41660486 0.18580172 0.1374637 0.12659533
12 0.06050241 0.13912962 0.02770162 0.10471355 0.00685329 0.14044587 0.02270153 0.2340845 0.22009987 0.29048394 0.34464664 0.23882482 0.22483508 0.14286426 0.08280122
18 0.02353266 0.12635222 0.0827809 0.11403563 0.04035776 0.31779733 0.35442448 0.26649864 0.28906408 0.33412119 0.24049396 0.36830687 0.37591063 0.20738195 0.22654037
24 0.08786597 0.05391101 0.0025163 0.0563251 0.08545091 0.14512175 0.29455009 0.27030457 0.27959516 0.16988462 0.2887321 0.35748279

답변 (1개)

Vijay
Vijay 2022년 11월 15일
From the image I can see you have an excel file. You need to first import the data into MATLAB and then calculate its mean.
Step 1: Importing Data
Please go through the video below on how to import the data.
Step 2: Calculating mean
Use the mean function to calculate the mean in desired way.
myMean = mean(importedMatrix, all) ;
Please refer to the documentation of the mean function for more information
Hope that helps!

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

제품


릴리스

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by