cara menghitung berat badan ideal dengan menggunakan microsoft excel

Summary

In this tutorial, Anggi explains how to calculate ideal body weight using formulas based on height and gender. Starting with male data, the process is shown step-by-step using the formula: height - 100, minus 10%, to find the ideal weight. Then, the same method is demonstrated for females, with a slight variation in the formula. The video also includes examples of two males and two females with varying heights, guiding viewers through the calculation for each. The tutorial is clear and concise, providing practical insights into calculating ideal body weight.

Takeaways

• 😀 The speaker introduces themselves as Anggi Angry and mentions their participation in the SEA Games.
• 😀 The topic of the presentation is how to calculate ideal body weight using a specific formula.
• 😀 The speaker demonstrates calculations for both male and female ideal body weights.
• 😀 The male ideal body weight formula involves subtracting 100 from height and then adjusting by 10%.
• 😀 For females, the body weight formula starts by subtracting 100 from height, with further adjustments based on the percentage of the height.
• 😀 The speaker uses example data to show the calculation process for both male and female body weights.
• 😀 The first example involves a male with a height of 175 cm and shows how to apply the formula.
• 😀 For the first female example, the speaker uses a height of 156 cm and applies the female formula to calculate the ideal weight.
• 😀 The second example for a male with a height of 170 cm uses the same formula as the first male, showing a result of 63 kg.
• 😀 The second female example demonstrates a height of 160 cm, and the speaker applies the female formula to get a result of 51 kg.
• 😀 The speaker concludes the presentation by apologizing for any potential mistakes and summarizing the method of calculating ideal body weight.

Q & A

What is the main topic of the presentation?

The main topic of the presentation is how to calculate ideal body weight using formulas for males and females based on their height.

What is the formula for calculating the ideal body weight for males?

The formula for calculating the ideal body weight for males is: (Height in cm - 100) - ((Height in cm - 100) × 10%).

How do you calculate the ideal body weight for a male who is 175 cm tall?

For a male who is 175 cm tall, the calculation is: (175 - 100) - ((175 - 100) × 10%) = 75 - 7.5 = 67.5 kg.

What is the formula for calculating the ideal body weight for females?

The formula for calculating the ideal body weight for females is: (Height in cm - 100) - ((Height in cm - 100) × 15%).

How do you calculate the ideal body weight for a female who is 156 cm tall?

For a female who is 156 cm tall, the calculation is: (156 - 100) - ((156 - 100) × 15%) = 56 - 8.4 = 47.6 kg.

What adjustments are made to the formula for males and females?

The main difference between the formulas for males and females is that males subtract 10% of the difference between their height and 100, while females subtract 15%.

What is the ideal body weight for a male who is 170 cm tall?

For a male who is 170 cm tall, the ideal body weight is calculated as: (170 - 100) - ((170 - 100) × 10%) = 70 - 7 = 63 kg.

How is the ideal body weight for a female calculated if her height is 160 cm?

For a female who is 160 cm tall, the calculation is: (160 - 100) - ((160 - 100) × 15%) = 60 - 9 = 51 kg.

What does the script suggest about the accuracy of the ideal body weight calculations?

The script does not mention any factors that could influence the accuracy of the ideal body weight, such as age, body composition, or health conditions, which may affect the actual ideal weight.

Why does the formula subtract 100 from the height when calculating the ideal body weight?

Subtracting 100 from the height is part of the formula designed to provide a baseline weight that is adjusted based on the individual’s height, with further adjustments based on gender.