Calculate Search Results

How To: Calculate commissions with Excel's IF & VLOOKUP

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 555th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF and VLOOKUP functions to make one of two types of commission calculations based on what is put in the referral column.

How To: Calculate the area of a trapezoid

Finding the area of a trapezoid is essential to high school and college mathematics. In this tutorial, learn how to find the area fast and easily. You will be aceing math tests in no time with this simple guide designed especially for students.

How To: Calculate and solve for density

Density is a means of representing how much mass is contained in the body of an object. The basic formula is: Density (D) = Mass (M) / Volume (V) so D=M/V. Density is important to know for buoyancy and to understand how heavy an object is. This video will show you three examples of measuring density so you can learn and put it to good use.

How To: Calculate age in Access using the DateDiff function

The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using the DateDiff function to work out age from birth date. For more, including detailed instructions, watch this Access how-to.

How To: Calculate square roots on paper the easy way

Perhaps not as easy as using a calculator, but easy nevertheless! With mathematics, as with anything else, not everyone progresses at the same rate. Happily, in the age of Internet video tutorials, this isn't a problem. Those who progress quickly can go beyond what's being taught them and those who are struggling likewise have all the time in the world to catch up. With this free video math lesson, you'll learn how to find square roots by hand.

How To: Calculate a t-statistic confidence interval for a small sample size

Want to find the value of a t-statistic confidence interval for a small sample? This clip's your ticket. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. For all of the details, watch this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials.

How To: Calculate Type I (Type 1) errors in statistics

Need a quick primer on how to solve type-1 error problem in stats? Let this video be your guide. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. For all of the details, watch this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials.

How To: Calculate how much you'll need for retirement in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, part of his "Excel Finance Class" series of free video lessons, you'll learn how to use the PV and PMT functions together to decide how much you need at retirement and how much you should deposit each month during your working years.

How To: Calculate sums in standard form

When a number is expressed in the form of x multiplied by 10^y such that, x < 10 and y is an integer, the number is said to be in standard form. Standard form of expressing numbers finds its use in scientific and statistical fields. This video demostrates how to express, as well as perform basic mathematical operations namely, addition/subtraction, multiplication and division of numbers in the standard form using four examples/mathematical problems. The first two examples demostrate multiplic...

How To: Calculate simple and compound interest in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 2nd installment in his "Excel Finance Trick" series of free video lessons, you'll learn how to use the FV function. See the math formula for calculating future value and for calculating the effective interest rate. Also see long hand how c...

How To: Calculate the weighted average of specific values

The way to convert 0.300 Moles of water into Grams is to start by writing what you have. Then put grams on top and moles on the bottom, then put one by the mole, the omler mass goes by grams. Now you figure out the moler mass of water which has 2 H and 1 O, its 2 times 1 which is the atomic mass for hydrogen plus 16.0 for oxygen which gives a total of 18.0 g/mol. So then you insert the 18 up by the grams, now you can cancel out the moles and multiply 0.300 times 18.0g and it gives you 5.40 g,...

How To: Calculate vacation days with TODAY, YEAR & IF in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 202nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that calculates the number of vacation days an employee gets based on hire date using the TODAY, YEAR and IF functions.

How To: Calculate percentages by example

In this tutorial the author explains of how to find percentages using examples. He explains that x percent of some number y is x multiplied by y and divided by 100. He goes on and explains this concept with numerous examples. He suggests a short cut to movie the decimal point of a number two digits to the left to divide that number by 100. The author demonstrates many more similar tricks and short cuts using which one can easily solve percentage problems. So if you are looking for a good tuto...

How To: Calculate the area of a parallelogram

Calculating The Area Of A Parallelogram A parallelogram is a 4-sided shape formed by two pairs of parallel lines. Opposite sides are equal in length and opposite angles are equal in measure. To find the area of a parallelogram, multiply the base by the height. The formula is:

How To: Calculate the percentage of a number

This video presented by Cris Ippolite makes a comparison between flat files and relational databases made with FileMaker Pro 10. It starts by showing flat files, which programs like Microsoft Excel use. Flat files have a big disadvantage: they cannot communicate with other files, even those with related data. If you wish to make your job easier, you should use relational databases. With databases, the tables communicate between one another. Once you store an entry in a table, you can use it i...

How To: Calculate your GPA step by step

Ever wanted to know what your GPA score is? Your GPA is your grade point average, which is a measure of a students achievement in college. This means all your grades are averaged and your are given a cumulative "GPA". Most colleges and universities will figure up your scores for you but you can learn to do it on your own so that you can keep checking up on your scores and stay at the top of your game. This can be beneficial to students looking to better their grades.

How To: Calculate your body mass index (BMI)

How do you know if you should lose weight is a question people often ask. For the most part the need for weight loss should be determined by how you feel in your own body. There are some calculations that doctors use to determine if you need to lose weight. One of those calculations is BMI or Body Mass Index. BMI is based upon a fairly difficult equation. BMI is figured by multiplying your weight by 703 then dividing by your height squared. A body mass index over 25 is considered overweight. ...

How To: Calculate weighted atomic mass

This video is about Level 2 atomic concepts, specifically the Pennium Lab. This helps you understand how atomic masses are derived for the periodic table. This teacher demonstrates how to do the calculation. He first reviews the Isotopes as they are different masses of the same type of atoms. He uses chromium as his example. It has a different number of neutrons in the nucleus. Using the equation, it could have either 26, 28, 29 or 30, with its 24 protons. So he subtracts the atomic number fr...

How To: Calculate and understand the concept of molar mass

Two college students; Kevin Martin and Joey Smokey introduce the concept of Molar Mass. They start of by explaining what molar mass is, which is the relationship of a mole and a gram, it totals up the weight(in g)of a molecule. An example: say you have this compound, Sodium phosphate (Na3PO4). You know you have three sodium atoms, one phosphorus atom, and four oxygen atoms. You basically find the weight of each atom, if you have three sodium atoms, you multiply it's atomic mass by 3 (the numb...

How To: Calculate variance and standard deviation using Excel

This video shows the method to find the variance and standard deviation using Excel. The variance shows the variability of the data points from the median. We find the difference of the median and the mean. We write the formula using '=' sign. The median and data points are put in it by selecting the appropriate cell. The median is made an absolute constant by pressing the F4 key. This is squared by using '^2'. This is multiplied to the frequency using '*'. The result is found for all the dat...

How To: Calculate azimuth in trigonometry

Azimuth is simply the angle of an object in the sky along the horizon. Yes, it's spherical trigonometry but it's not difficult! Check out this video and in just a few minutes you will be able to solve azimuth problems on your own.

How To: Calculate the area of a triangle by formula

From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. With this free math tutorial, you'll learn how to calculate the area of a triangle by formula.

How To: Calculate your GPA

In order to calculate your cumulative average (GPA), you need to know the value of the grades you receive. The grades you receive in your classes are based on the grading scale of each instructor in your classes. Your cumulative average is the resulting value of all of the grades.

How To: Calculate the area of a triangle using a basic formula

Free Math Tutoring teaches you in this video how to calculate the area of a triangle using a basic formula. The area of a triangle is (b times h)/2. B is the base of the triangle and h is the height. This formula works for all kinds of triangles. Sometimes you won't have the height in the triangle, so you need to draw a line from one angle to the base opposite that, at a 90 degree angle. Measure that and you have your height. It might seem difficult at first, but practice helps you understand...

How To: Calculate the width of a fence given its length and perimeter

From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to find the width of a fence when given numbers for its length and perimeter.

How To: Calculate unit rates with basic arithmeitc

From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve word problems that require you to find a unit rate.

How To: Calculate the GCF & LCM of a given number set

Need help figuring out how to find the greatest common factor and/or the least common multiple of two given numbers? Learn how with this free video lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test).

How To: Calculate the area of various polygons

We can calculate the area of the simple polygons like square, rectangle, triangle, pretty easily. Area of square can be calculated by drawing it on a graph paper, of unit cm length and breadth. Area of a rectangle is length X breadth. Area of a triangle is 1/2bh, half of product of base and height. For a parallelogram , area is the product of base and height. For a trapezoid , it is 1/2(b1+b2)h. For some other extreme polygons, we can calculate the area by making it different simple polygons ...

How To: Calculate math without a calculator

Before the calculator and even the abacus was invented, there was a little instrument called the human brain that we used to do math. Remember that? While most of us turn to our trusty Ti-84s to do calculus homework or whip out our cell phone calculators to determine how much we should tip at Johnny Rocket's, it can often be much faster to use our own brains, along with a piece of paper and pencil.

How To: Calculate a handicap in golf

This video presentation details the process of calculating a handicap in golf, in this presentation the handicap will be calculated on the USGA handicap system which is the official handicap system to be used in the United States. On each score card, there is a designation for the handicap and slope, these numbers do not vary frequently between sixty-eight and seventy-four, and one-fifteen, and one-thirty, respectively. The 'Slope' is a new calibration that is used to help make a handicap fai...

How To: Calculate the Cost of Driving

With gas prices soaring in the US and around the globe, the cost to drive to a vacation destination is becoming a much larger expense item in the overall travel budget. Although it's easy to see that gas prices have risen dramatically in the past several months, it's not nearly as easy to figured out how it will impact that upcoming car trip, so here are the items you need to take into consideration to calculate how much it will cost to drive to a destination.

How To: Calculate your bike's chain length

If it's time for a new bike chain, you'll need to figure out how to determine how much length your bike will need for the chain. It's pretty easy to determine and can take around five minutes to help figure out what you need. So check out the tutorial, pay attention, and enjoy! Calculate your bike's chain length.

How To: Calculate the area of a triangle with a simple method

There are only few steps to find the area of the triangle in a simple method. First you consider a triangle, and to find the area in a simple manner just add the triangle of same properties and side lengths as same as the first one and attach to it. Then we know the formula to calculate the area of the square. Then find area of the square by side*side. Then you will get the area of the square, now divide the area by two, as we add another triangle. Then the area of the triangle will be obtain...

How To: Calculate ordinary differential equations

MIT Professor Arthur Mattuck gives a lecture on how to calculate with ordinary differential equations (ODEs). He also covers the geometrical view of y'=f(x,y), directional fields, and integral curves. Calculate ordinary differential equations.