What is the formula for BMI on Excel?

By Useful Hints

What is the formula for BMI on Excel?

BMI = weight (kg) / height (m)2 The first step therefore is to capture this information in commonly used units. This is done in columns B (feet) C (inches) and D (pounds). Then the two values are simply added together to get a total height in meters.

How do you create a concentration curve in Excel?

Adding a linear trendline to your scatter chart will effectively create a normal curve line that represents the standard curve of your data.

  1. Open Excel and create a new spreadsheet.
  2. Enter the standard samples you are graphing into cells “A1” and “A2.” For example, enter “Concentration” and “Absorbance.”

How do you calculate BSA from height and weight?

References

  1. Equation: BSA (m2) = 0.0235 x Height(cm)0.42246 x Weight(kg)0.51456
  2. Equation: BSA (m2) = 0.024265 x Height(cm)0.3964 x Weight(kg)0.5378
  3. Equation: BSA (m2) = SQR RT ( [Height(cm) x Weight(kg) ]/ 3600 )

How do you calculate BSA for nursing?

The formula is as follows[1]: Body Surface Area= 0.007184 x (Height(m)^0.725) x (Weight(kg)^0.425)

How is BSI calculated?

Body mass index (BMI) and Body shape index (BSI):

  1. Body mass index (Reference) BMI (kg/m2) = Weight (kg) ÷ Height (m)2
  2. Body shape index (Reference) BSI (kg/m2) = Waist line (m) ÷ (BMI (kg/m2)2/3 × Height (m)1/2)

What is BSA on medical chart?

Body surface area: BSA. The total surface area of the human body. The body surface area is used in many measurements in medicine, including the calculation of drug dosages and the amount of fluids to be administered IV.

How do I calculate my weight loss percentage?

Weight Loss Percentage Formula The formula to calculate your weight loss percentage is: lbs lost divided by starting weight. Then, multiply the result by 100. So, if your starting weight is 150lbs and you lost 5lbs, you’ve lost 3.33% of your body weight.

How do you calculate BSA in Excel?

Mosteller Method:[1] BSA (m2) = (height (cm) x weight (kg)/3600)½. eg, BSA (m2) = square root of (height (cm) x weight (kg)/3600) Using their example a height and weight of 121cm and a weight of 25 the BSA calculates at 0.92. On my formula in Excel: =SQRT(X172*N172)/3600 I get 0.12.

What is the BSA formula for height and weight?

I have looked on Google and the formula is: Using their example a height and weight of 121cm and a weight of 25 the BSA calculates at 0.92. On my formula in Excel: =SQRT (X172*N172)/3600 I get 0.12. You need a subscription to comment.

How to calculate BSA (m2)?

Mosteller Method:[1] BSA (m2) = (height (cm) x weight (kg)/3600)½. eg, BSA (m2) = square root of (height (cm) x weight (kg)/3600) Using their example a height and weight of 121cm and a weight of 25 the BSA calculates at 0.92. On my formula in Excel: =SQRT(X172*N172)/3600 I get 0.12. Any suggestions please/.

When to use the second formula for BSA for a child?

You will use the SECOND formula below if the weight and height are in pounds (lbs) and inches (in). The last formula will help you calculate a child’s dose based on the child’s BSA and the normal adult dose. Your patient weighs 163 lbs and is 5 feet 7 inches. What is the patient’s BSA?