Tuesday, 28 February 2012

Calculate body mass index (bmi formula) in excel 2007

How to calculate ideal body weight in Excel 2007. With using microsoft excel we can calculate an ideal body weight which refers to the formula for calculating ideal body weight according to Body Mass Index. Body Mass Index (BMI) is an ideal weight calculation is based on the formula:
BMI (BMI) = Weight (kg) / (height (m) x Height (m)
If the index has been obtained from the above calculation, the next step is to match your weight criteria of BMI according to the version of the WHO (World Health Organisation):
a.BMI <18.5 means Underweight
b. BMI 18.5 - 24.9 means you ideal weight
c. BMI 25 - 29.9 means over weight
d. BMI >= 30 means obese

To calculate your ideal weight in excel do the following:
Create a table as below

Sunday, 22 January 2012

How to make a sine graph in excel 2007 (plot sine wave)

Make a sine graph in excel 2007 (plotting sine wave on Excel).By using Microsoft Excel, we can easily create a graph sine, cosine graphs, charts and graphs tangent of the other trigonometric functions. Specifically discussed in this post about how to create charts in Excel sinuses that might be useful for beginner friends.

To create a graph of sin in Excel 2007, following  procedure below:
1. Create a table as below
In column A with the contents of the data point, in the following example created scale with intervals of 15 degrees.
In cell B3 enter the formula "= SIN (radians (A3))"
Copy the formula from B3 up to B27

Create cosine graph/plot cosine wave in excel

With Using Microsoft Excel, we can make a variety of curves from mathemathic functions such as trigonometric functions : sine curve, cosine, tangent, hyperbolic sine (sinh), cosec (cosecant), sec, etc.. In addition trigonometry function can also be made logarithmic curve, the exponential curve, linear curve, the curve da various other mathematical equations. Basically to make a curve of mathematical equations in excel, need data that can be sorted vertically or horizontally. By using graphics features available in Excel toolbar, then we can easily create a graph cosines

In this post will be discussed on how to graph cosine in excel 2007 (special for beginner). Please follow the procedures of cosine graph below:

Random Posts