Clear Filters
Clear Filters

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

1 view (last 30 days)
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

Answers (1)

Vijay
Vijay on 15 Nov 2022
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!

Products


Release

R2021b

Community Treasure Hunt

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

Start Hunting!