How do I pull data from excel in an automated method?

2017 6 19
1 个回答
更新时间：2017 6 20
8 次查看（30 天）

0 个投票

I need to develop an automated method to import each individual participant data set. One spreadsheet has a list of the participant's name, then each participant has their own spreadsheet with their corresponded data listed. Also, how can I find the mean of each individual's score on trial 1?

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Jan
Jan 2017-6-19
Please explain the details: How is the "list of names" stored in the file? How can the spreadshets be related to the names? How are the data stored in the sheets? What is a score? What is "trial 1"? Remember that the readers do not have the faintest idea about what you are doing.
Richard Wilson
Richard Wilson 2017-6-19
Good point, I should have thought of that. So I have an excel file named "Lab3" that contains the names of people that participated in my experiment (ex: mary, paul, simon, etc). Then each person has their own separate excel file with a list of 3 trials, next to eat trial is a score that I collected from the experiment. Does this help clarify?
Jan
Jan 2017-6-20
Yes, it helps. Do you have a specific question now?
Richard Wilson
Richard Wilson 2017-6-20
So I am guessing the teacher wants me to create a loop that goes through each individual spreadsheet and calculates the average for the values of trial 1 and save that result as variable "trial1_scores'. I am new to MATLAB and in desperate need of help!

请先登录，再进行评论。

请先登录，再回答此问题。

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by