Calculated Search Results

How To: Use calculated queries in Microsoft Office Access 2007

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 calculated field to work out the tax payable on an item, then adjusting item value. For more, and to get started using calculated queries yourself, watch this MS Access how-to.

How To: Create a Tangent Line with Excel

Given a function, you can easily find the slope of a tangent line using Microsoft Excel to do the dirty work. That is to say, you can input your x-value, create a couple of formulas, and have Excel calculate the secant value of the tangent slope. This is a fantastic tool for Stewart Calculus sections 2.1 and 2.2.

How To: Add dynamics to concave objects in Cinema 4D

In this tutorial, create concave objects in Cinema 4D such that particle objects behave and interact realistically with the concave object. The automatic setting for objects is configured in a way that simplifies calculation and speeds up rendering time. By changing the automatic setting within Cinema 4D, the physical properties of concave and curved objects are calculated more thoroughly and are rendered more realistically.

How To: Play the card game Sixteen

The multiple award-winning card game Sixteen is packed with head-to-head action. If you can you count to 16 and take calculated risks, then you can force your opponent to bust. But play your cards defensively at the right time or the tables will turn! Win the most sets and you'll win the game. It sounds simple (and it is), but Sixteen's unique strategy and cribbage-like counting will hold the attention of even the most seasoned game players.

How To: Calculate interest rates for payday loans in MS Excel

The video demonstrates the way of calculating the interest rates for payday loans using MS Excel. The person presenting the video has got his MS Excel sheet with all the formulas and data ready. He first starts with the nominal & effect & future value tab. He gives us an example where you give the lenders a check of $250 that has a date 25 days in future and get $200 loan today. Now he teaches us hot to calculate APR and EAR. HE has got the data ready there, the period of the loan which is 25...

How To: Make a quartile diagram (aka, box and whisker plot)

This is an interesting mathematical instructional video on how to make a quartile diagram. This example is about 34 grades obtained by chemistry class students. We need a minimum value, a maximum value, Q1, Q2 and Q3 values to make a quartile diagram. The minimum is 43 and the maximum is 92. To calculate Q2 median formula (n+1 over 2)is used. The Q2 median is 17.5. So the average of 69 and 71 is 70 and hence Q2 70. Similarly Q1 is calculated as 61 and Q3 is calculated as 79. Now you can draw ...

How To: Find the volue and surface area of a cylinder

This video both shows the viewer how to calculate the volume and surface area of a cylinder. It also explains what these different numbers mean. The volume is the amount of ‘matter’ that the cylinder can hold. The surface area is literally the area of the cylinders curved face and the two end circles.

How To: Use Heron's formula

Area of a triangle can be calculated when you have the length of its base and height. In this case the area is 1/2 times the base and its height. If you do not know the height of the triangle but know the lengths of all the sides of the triangle then you can calculate its area using the Herons formula. First to use it you need to computer the semi perimeter of the triangle S, which is S = (a + b + c)/2, where a, b, c are the lengths of the sides of the triangle. Now the area of the triangle i...

How To: Use SUMPRODUCT for deposit calculations in Excel

Excel Magic Trick 475 talks about Sumproduct for bank deposit calculation. Here, the total money can be calculated by just a click. Total is taken as Sumproduct and can be obtained by clicking on the number of bills that get added to give the final checked amount. If these steps are followed, the viewers will find themselves in a new world of deposit and bill calculation

How To: View the logic in a form template with InfoPath

You don't have to check the settings for every control individually — you can use the Logic Inspector to see a form's business logic displayed in a single window, grouped by features such as data validation, calculated data values, rules, and programming. Take a look at this instructional video and learn how to view the logic in a form template with Microsoft InfoPath.

How To: Complete the square

Quadratic equations are easy to solve when they can be factorized. This video teaches another method of solving a quadratic equation when its not easy to find factors for it.

How To: Find the area of a triangle given three points

In this tutorial, we learn how to find the area of a triangle given three points. First, you will need to plot the points on a graph. After this, find the base and the height using the graph. Next substitute into area of a triangle formula and then evaluate. When you finally find the area of the triangle, then you will write down the answer ending it with the units. This is a simple way to find the area of the triangle, you just have to make sure you count correctly and have calculated the ar...

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: Find density using the water displacement method

To find out the density of any given object there is a simple equation, mass divided by the volume equals the density. In this video a lady is showing how to get the volume of three objects using water. First the objects are measured on a scale to find out how much they weigh, the mass. Next each one of the objects is placed into a measured amount of water to find out the volume. Before you place the object into the water you will want to know just how much water in there. That way when the o...

How To: Calculate percent yield

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...

How To: Solve problems about linear equation

In this video the instructor shows how to write a linear equation. If you need to find the equation of a line that passes through the two given points then you need to find the linear equation of that line. The first step is to find the slope of the line that passes through these points. The slope can be calculated by finding the ratio of the difference of y coordinates to the difference of the x coordinates i.e. the change in y up on the change in x. Now substitute the value of slope and any...

How To: Find the surface area of a cone shape

In this tutorial the instructor shows how to compute the Surface Area of a Cone. He explains that you need to find the individual surfaces areas first. Hence the bottom part of the cone which is circular can be calculated as Pi*r*r, where r is the radius of the base circle. Now for the sides surface of the cone, it looks like a sector and he derives its area thorough some deduction. Now he adds both the base surface area of the cone, and the lateral surface of the cone which finally gives the...

How To: Figure out elapsed time with Mr Binkley

This video is an entertaining way of learning how to quantify how much time has elapsed from one point to another. It opens with a mischievous person using an unauthorized computer, claiming he had only been on for a shorter time than what was calculated by the owner. The video then instructs how to figure out such a calculation by creating a T-chart. One the left side of the T-chart, the previous time is shown, along with new times as each hour or minute is added. On the right, the desired t...

How To: Find the circumference of a circle in Geometry

In this tutorial the author shows how to find the circumference of a circle. He says that the circumference of a circle can be calculated by using the formula circumference C = 2 * Pi * R, where R is the radius of the circle. He shows how to solve these kind of problems using some examples and calculating the circumference by substituting the value of radius in the formula. This video gives a good introduction on how to find the circumference of a circle.

How To: Approximate the area under a curve using rectangles

The idea of finding the area under a curve is an important fundamental concept in calculus. Consider a function y = f(x). Now the area under the curve is to be calculated. The area under a curve problem is stated as 'Let f(x) be non negative on [a, b]. Find the area of the region lying beneath the curve y = f(x) and above the x-axes, from x = a to x = b. Note that finding the area under a curve will imply that you are dealing with a non negative function. The way to approach is to divide the ...

How To: Solve a linear system by graphing in math

This video teaches you how to solve a linear system by mathematically graphing it out. The video starts off with a problem, asking to solve the system, with two given equations. To solve the system, one would insert 0 for x and solve for y in the first equation to obtain a point. Then one would insert 0 for y and solve for x at the second point. Afterwards, insert 1 for x and solve for y to obtain the third point. For the second equation, do the same thing, inserting 0 for x, 0 for y and 1 fo...

How To: Find the Area and Volume of a Hemisphere

A hemisphere is sphere that has been cut in half. When you cut the sphere in half you are left with the great circle, plus half of a sphere. This fact can be used to find the area, and the volume of a hemisphere. The video works several example problems in which the area and volume of a hemisphere is calculated.

How To: Interpret a standard deviation

A rough definition of standard deviation is that it is a measure of expressing the observed variations about the average in statistical data i.e. by how much do the observed values vary from the mean. This video continues from the previous solved example and demonstrates the mathematical interpretation of the standard deviation that was calculated. We begin with stating the mean and standard deviation values and then calculating the upper and lower bounds of the data based on the standard dev...

Prev Page