Trying to find the number of people overweight gives zero

% 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);

[Dyuman Joshi]

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]

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

Answer 1

[the cyclist]

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);

[Victor]

ok I have updated it

[the cyclist]

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

[Sam Chak]

@Victor, do you plot the chart or histogram as well?

[Dyuman Joshi]

Any updates? @Victor