Trying to find the number of people overweight gives zero

Question

Victor 2023-10-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2035879-trying-to-find-the-number-of-people-overweight-gives-zero

评论： Dyuman Joshi 2023-10-21

bodyInfo.xlsx

% Read data from the Excel file
data = xlsread('bodyInfo.xlsx');
% Extract columns
Gender = data(:, 2); % 0: Male, 1: Female
Height = data(:, 3); % measured in cm
Weight = data(:, 4); % measured in KG
% Calculate BMI
BMI = (703 * Weight) ./ (Height.^2);
% (a) Calculate average BMI for male group and standard deviation for female group
avg_BMI_male = mean(BMI(Gender == 0));
std_BMI_female = std(BMI(Gender == 1));
% (b) Determine the number of males classified as 'Overweight'
overweight_males = sum(Gender == 0 & BMI >= 25 & BMI < 30);
% (c) Determine the number of females classified as 'Obese'
obese_females = sum(Gender == 1 & BMI >= 30);
% Display the results
fprintf('Average BMI for Male: %.2f\n', avg_BMI_male);
fprintf('Standard Deviation of BMI for Female: %.2f\n', std_BMI_female);
fprintf('Number of Males classified as Overweight: %d\n', overweight_males);
fprintf('Number of Females classified as Obese: %d\n', obese_females);

2 个评论
显示无隐藏无

Dyuman Joshi 2023-10-19

There might not be any data in that particular category.

Why are you multiplying by 703 to find the BMI? And not converting the height to meters?

Jon 2023-10-19

Please attach your input .xlsx file so we can run your code

请先登录，再进行评论。

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

Answer 1

the cyclist 2023-10-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2035879-trying-to-find-the-number-of-people-overweight-gives-zero#answer_1336751

在 MATLAB Online 中打开

I agree with @Jon that uploading your data file will help, but the problem is almost certainly what @Dyuman Joshi hints at, which is that you are most likely not using the correct formula for BMI, given the units of your inputs.

The formula

BMI = (703 * Weight) ./ (Height.^2);

is a correct one, but appropriate only when using Imperial units (weight measured in pounds and height measured in inches).

According to the comments in your code, you have Weight in kilograms and Height in centimeters. So, I believe you need

BMI = (Weight) ./ ((Height/100).^2);

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

the cyclist 2023-10-19

在 MATLAB Online 中打开

bodyInfo.xlsx

I didn't look at the data to double-check, but running with my corrected formula, I see 35 males classified as "Overweight".

% Read data from the Excel file
data = xlsread('bodyInfo.xlsx');
% Extract columns
Gender = data(:, 2); % 0: Male, 1: Female
Height = data(:, 3); % measured in cm
Weight = data(:, 4); % measured in KG
% Calculate BMI
BMI = (Weight) ./ ((Height/100).^2);
% (a) Calculate average BMI for male group and standard deviation for female group
avg_BMI_male = mean(BMI(Gender == 0));
std_BMI_female = std(BMI(Gender == 1));
% (b) Determine the number of males classified as 'Overweight'
overweight_males = sum(Gender == 0 & BMI >= 25 & BMI < 30);
% (c) Determine the number of females classified as 'Obese'
obese_females = sum(Gender == 1 & BMI >= 30);
% Display the results
fprintf('Average BMI for Male: %.2f\n', avg_BMI_male);
Average BMI for Male: 29.05
fprintf('Standard Deviation of BMI for Female: %.2f\n', std_BMI_female);
Standard Deviation of BMI for Female: 1.01
fprintf('Number of Males classified as Overweight: %d\n', overweight_males);
Number of Males classified as Overweight: 35
fprintf('Number of Females classified as Obese: %d\n', obese_females);
Number of Females classified as Obese: 0