I was asked to use an excel sheet containing names, user ID's, height, weight, and age.

Question

Hind Aljallaf 2021-11-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1594109-i-was-asked-to-use-an-excel-sheet-containing-names-user-id-s-height-weight-and-age

评论： Hind Aljallaf 2021-11-27

The excel sheet part is all covered, but we were also asked to display the user's ID's and BMI index. I am very lost since i don't know how to start, so can I please get some help to start?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Hind Aljallaf 2021-11-23

What are the codes I should be focusing on in order to find those two components?

请先登录，再进行评论。

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

Answer 1

Srijith Kasaragod 2021-11-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1594109-i-was-asked-to-use-an-excel-sheet-containing-names-user-id-s-height-weight-and-age#answer_840754

编辑：Srijith Kasaragod 2021-11-26

在 MATLAB Online 中打开

Hi Hind,

Once the table is imported into MATLAB workspace, any table variable can be accessed using dot syntax. For example, assuming the table 'User' contains the variablename 'UserID' it can accesed using the syntax given below:

values= User.UserID; %'values' would contain the elements under variable 'UserID' as table array

Please refer this page to know more on how to compute BMI index, given height and weight of a person. Once computed, the values could be added as a variable to the table and accessed using dot syntax.

Refer this page to read more about MATLAB tables and dot syntax.

Hope this helps!