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 722nd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate gross pay for the week from time values using the SUMPRODUCT function. Also see what to do if you get a #VALUE! error from blanks in cell using the IF function and an array logical test.
In this video, we learn how to calculate your waist to hip ratio using a tape measure. First, measure your waist round your belly button and write down what number it is. Next, measure your hips around the largest part of your butt, and then write down what number you get for this. After this, divide your waist measurement by your hip measurement. A healthy ratio for women is .8 and under and a healthy ration for men is .95 and under. It's important to watch the weight around your waist, beca...
Calculate the amount of days worked on a given project within MS Excel! Do you maintain work schedules for your projects? Are you manually subtracting weekends and holidays from your project estimates? There's a better way. And this digital spreadsheet tutorial will show you how. For detailed, step-by-step overview on how to easily and efficiently maintain a count hours of labor, watch this free video software tutorial.
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 22nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the NORMDIST function to calculate probabilities for a population with a normal (bell) distribution! You even get to see the four types of situations that you most commonly encounter -- plus visual pictures of each situation...
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 99th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF, MAX and the MIN functions to solve a basic problem in three different ways! See how to calculate the excess amount over a hurdle with three different methods!
This video shows you how to calculate the percentage yield in chemistry. To find the percentage yield, you will need to divide the actual yield by the theoretical yield. Then, multiply it by 100: i.e. % yield = actual yield/theoretical yield x 100. An actual yield is the amount of a substance produced in an actual laboratory experiment. It is based on an actual physical measurement of a quantity. The theoretical yield is the yield as is calculated on paper: i.e. through calculations. Therefor...
This video shows the viewer how to calculate friction in a body that it is not accelerating. The simple answer is that the force of friction will be equal to the force needed to maintain the constant speed. This means that is you pull a wooden block along a carpet at a constant speed and a Newton meter between you and the block measures 5 Newton’s then the force of friction between the carpet and the block is exactly 5 Newton’s. If the object is accelerating then this rule does not apply.For ...
In this video, ExcellsFun takes you step by step on how to calculate your employee payroll using an excel spread sheet. ExcellsFun teaches you how to take the base pay of various employees' salaries and determines how much you are paying them over a week, month, and year. Excellsfun also shows you how to incorporate various pay periods including weekly, semi-weekly, bi-weekly, and monthly on the same form using the same calculation for the entire spread sheet. After watching this video, you w...
This video explores how to get the limit by getting a common denominator. When you try and plug in a limit, for example when the denominator goes to zero, you can get yourself into a situation where you get the answer (0/0) which is mathematically irrelevant. To solve this problem, you must find a common denominator and split the problem up into its various parts. By setting common denominators in the numerator, you can then flip the fraction around allowing you to properly calculate the limi...
If you want to know how to calculate percent error easily, you should watch this video. Error is the amount of deviation from accurate values. Error calculation is not possible, unless you make a quantitative measurement of the various quantities involved in your experiment. Measurement can help us in calculating errors and knowing how right we are in our theoretical models. In calculating percent error, We need to get the experimental value and the value which you are aiming at, which is the...
Calculating the volume of a cube is very important in high school geometry classes. Calculating the volume of a solid can be confusing at first, but with a little practice you will be able to get it right. In this tutorial, high school math teacher Doug Simms teaches you exactly how to calculate the volume of a cube and offers examples so you can follow along. Listen to Mr. Simms and you will be at the top of your class!
This video will show you simply how to calculate the area of any triangle using basic geometry formulas. Since a triangle is basically half of a rectangle, the formula for calculating the area of a triangle is base times height. This video offers some insight and examples provided to you by a teacher about how to apply this formula to various types of triangles, whether they are right triangles, equilateral, isosceles, or another form of triangle. By watching this video, you will be well prep...
In this video the author explains how to calculate average acceleration along with some real world examples. Now if we subtract the starting speed of a moving vehicle from its maximum speed and divide it by the time taken to reach the maximum speed from the initial speed you will obtain the average acceleration of the vehicle. The author shows this with a racing video example. If you want compute the average acceleration of a moving object watch this video and use the simple method explained ...
This easy to understand video gives us two ways to calculate a percentage using a calculator. The video first shows us how to use the percent key on the calculator using the example of figuring out how much to tip at a restaurant. We can also convert a percentage to decimals before entering the information in the calculator and then just use simple multiplication. The instructions are easy to follow, as the video is less than a minute of watching someone use a calculator.
In this video tutorial the instructor shows how to calculate the acceleration of a car on an inclined plane. He goes on to solve a problem he came across which is based on the acceleration of a car on an inclined plane. He shows how to solve this problem by showing how to extract the data from the question and draws a diagram to get a clear understanding of the problem. Now he marks the forces acting on the vehicle and goes on to specify his axes and how to split the components of force along...
To calculate percentage composition we will take the example CO2 it stands for Carbon-Di-Oxide. It is the composition of Carbon and Oxygen. We have one carbon and its weight is 12.01 and 2 oxygen. So, we will multiply 2 with 16.00 which is the weight of the oxygen.
Do you need to brush up on your fraction and percentage skills or get ahead of the class in math? This video shows several different examples of how to calculate percentages by using fractions. Money is used as a frequent example because quarters and change are easier to figure out and can help you translate when solving a math problem. You can also solve equations by writing them down and diving the part by the whole. Sound complicated? Watch the video and see how easy you can master calcula...
Learn how to calculate simple interest with step-by-step instructions using the formula I=prt. Simply defined, interest equals principle times rate times time. The video shows various examples of calculating this formula by plugging different variables into the equation. Although, these calculations can seem hard to follow, the way they are presented is straightforward and simple to understand. The video also explains converting percentages to decimals, which is the cornerstone of applying th...
In this episode of Science Theater Dr. Carlson helps you understand the concept behind Density and how it relates to Mass and volume and how to calculate the Density of a substance if its Mass and Volume are known. The Density of various metals is demonstrated using aluminum, tin, zinc, lead and copper of the same mass but different sizes. The easiest way to measure the density of a substance is also mentioned. Next, Dr. Carlson measures his own density using a scale and a bathtub.
This video is about how-to calculate the area of a circle. It is in a very simple, and in an elementary school point of view. Of course, it can be done with either metric or imperial measures, as explained in the video. Only thing is that, it truly explains the simplicity of the calculation in every sense, which means, if you are not going for the ultimate knowledge on how things exist and survive in the form they are in, this video should be helpful. A grown man (woman) can't learn anything ...
In this video the tutors explain about the concepts of Circular Velocity and Acceleration. She explains the concepts using a real world small experiments. She shows that the equation to calculate circular velocity is v = (2 * Pi * r) / T, where r is the radius of the circle the object moves in, and T being its time period. Now she takes the values from the experiment and calculates the velocity of the other tutor who is the object that runs around in the circle for the experiment. She even co...
In this tutorial the instructor shows how to compute the area of irregular shapes. He demonstrates this with an example showing an irregular area and says that as there is no direct formula to calculate it, you need to break up the irregular area into identifiable simple geometric figures. He goes on and breaks the irregular shape into a square, a triangle and a trapezoid. Now he computes the individual areas using a standard formula and sums them up to arrive at the final complete area of th...
Knowing your BMI, or Body Mass Index, is a great way to see if you are at a healthy weight. In this simple and short video provided by Children's Hospital Boston, you will figure out how to calculate your BMI by taking your weight (in pounds) and multiplying it by the number 703 and then dividing it by your height (in inches) squared.
Watch this video tutorial to learn how to calculate your carbon footprint. A carbon footprint is an equation that estimates just how much you, personally, are contributing to global warming—and all you have to do is plug some info into an online calculator. Figuring out how to make your footprint smaller, of course, is another matter.
In this motorcycle tutorial you will learn how to calculate the manual valve shim size. Both exhausts have the same spec and both the intakes have the same spec so the video only shows one side being done.
The video shows how to calculate weight if the mass is given and vice versa.Later on in this unit you will learn about Newton's laws of motion and Newton's second law of motion gives us a way to change mass into weight and vice versa.This law will tell you what is happening to objects when the net force on the object is not equal to zero and the easy way to say what will happen is that the object will accelerate.But how much the object accelerates depends on two things,firstly the mass of the...
Calculating probablities can be used to help us make decision. PatrickJMT explains how to calculate probability in an "either A or not A" scenario. The probability of A plus the probability of not A is equal to one. Therefore, the probability of A is equal to one minus the probability of not A ; P(A)= 1 - P(not A). The probability of a major earthquake in San Francisco over a period of time is used as an example. The probablity of an earthquake of a magnitude of 7.5 or greater in San Francisc...
New to 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 Excel tutorial from ExcelIsFun, the 269th installment in their series of digital spreadsheet magic tricks, you'll learn how to
Learn how to find the area of circle by activity method. Requirements: A circle cut out, a pair of scissors, sketch pen, and a ruler.
Learn how tofind r-squared or the coefficient of determination in stats. Whether you need help studying for that next big stats text or just a hand finishing your homework, you're sure to be well served by this four-part free video math lesson from Salman Khan.
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 CI for the difference between means.
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 sampling distribution for the difference between means.
In this free video chemistry lesson from Salman Khan, we learn about vapor pressure and the ideal gas law. Whether you need help studying for that next big test or could just use a hand finishing your homework, you're sure to be well served by this video lesson. For all of the details, take a look.
The 'net present value' is the difference between the initial cost outlay of making a product or an investment, and the present value of expected cash flow. Using the equation given in this video, you can start with the initial estimation and determine the net present value for your endeavor.
If you want to lose weight on the Weight Watchers plan, it's important to know how many points you can eat per day. This video will teach you how to determine your Weight Watcher point score and stay under it.
All you hear about on the news, the radio, and in other media sources is how the unemployment rate is high. But how do they know that? How did they get to that conclusion? Well, wonder no more! In this video you will learn what formulas you can use and other statistics to find out what the unemployment rate is.
Your maximum heart rate is an important piece of information to know if you are exercising seriously and want to make sure you are going hard without damaging your body. This video will teach you an easy, conservative way to estimate your maximum heart rate. With this knowledge and a heart monitor you will be able to assess the quality of your workout more accurately.
Math, chemistry, physics can all be a very difficult thing to understand. But if you have the right teacher, then it can make life a bit easier. Maybe even a music video explaining it can be a bit easier. In this tutorial, if you're having a tough time with calculating the percent error, this music video may be what you need. So check it out and good luck!
Need help finding the area of a kite? 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).
Need to know how to find the greatest common factor or GCF for a set of 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).
