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

1 view (last 30 days)
Abu Tahir Taha on 12 Nov 2022
Answered: Vijay on 15 Nov 2022
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

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) ;
Hope that helps!

### Categories

Find more on Spreadsheets in Help Center and File Exchange

R2021b

### Community Treasure Hunt

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

Start Hunting!