The instructor in this video uses humor to teach people math, which is not a favorite subject for many. The video goes on to teach the students in the video different ways to cut the conic sections into different shapes. The teacher then focuses on parabolas and defines the formulas. The formula is y = x^2. The rest of the video dissects the equation breaking it down into much more meaningful statements so that the average human being who is not very good at math can understand the equation. ...
Are you slightly rusty on your math skills? This video demonstrates how to find the volume of a sphere with a given radius. The first step is to sketch a solid and cross-sectional view of your sphere to get an understanding of the process to come. Next, find a formula for the area of this cross-section. Third, find the limits of integration. This will allow you to take the area of each cross-section in the sphere, not just the singular one you are viewing. Lastly, integrate this formula from ...
This tutorial teaches you how to find a mathematical equation of a line given 2 points that exists on the line. The tutorial starts off with 2 points labeled (2,-4) and (3,6). The first step is to determine the slope of the line using the formula given in the tutorial in blue. The slope is then solved as 'm'. Plug the slope and the points into another formula given in green. The tutorial maker provides a tip that one can use x1 and y1 or x2 and y2, however, it must be consistent. After, solve...
In this instance we are going to Find the circumference of a circle by applying formula C=2pr where 'C' is circumference of a circle, approximate value of 'p' is 3.14 because it is irrational number and 'r' stands for radius i.e. half of diameter. So by applying this formula we can easily calculate circumference of a circle if radius is given or we can also calculate radius if circumference of a circle is given. One thing to remember is that unit we use for circumference of a circle is cm, in...
In this video tutorial, viewers will learn how to create a table for the VLOOKUP function in Excel. Create a dynamic table for the VLOOKUP function as well as a dynamic lookup area so that as you add new data or columns to the Lookup table. Create dynamic ranges using the Excel Table feature and Table Formula Nomenclature for the Data Validation drop-down list, the VLOOKUP table and the MATCH table. See an IF function formula that creates new labels as new columns are added to the lookup tabl...
In this video, the instructor shows you how to graph quadratic equations. When you have a quadratic equation in terms of x and y, first try to identify the coefficients of the terms. Now use front end of the quadratic formula to find the line of symmetry which is the first half of the vertex using the formula x = -b/2a. This gives the line of symmetry. Next, plot the line using a few points starting at the line of symmetry. Take sample values of x and find the corresponding values of y on eit...
If you have a fossil, you can tell how old it is by the carbon 14 dating method. This is a formula which helps you to date a fossil by its carbon. If a fossil contains 60% of its original carbon, how old is the fossil? The half life of carbon 14 is 5600 years. That means this is how long it takes for half the nuclei to decay. After 5600 years, if we start with a gram, we end up with half a gram. This rather complex formula shows you how to solve this puzzle using accepted scientific methods.
In this video the instructor shows how to do temperature conversions using y = m*x + b. Now if Celsius is represented by the variable C and Fahrenheit is represented by the symbol F, you can replace then in the previous equation in place of the variables x and y giving you the equation C = m*F + b. Now to solve for the values of the constants m and b you need to have values of two sample temperatures in both Celsius and Fahrenheit. Take the first sample and substitute in the above equation gi...
In this video the instructor shows how to factor the GCF and difference of squares. When you are asked to factorize a number or monomial or a polynomial, the way to do is break it down into individual terms. When asked to factorize a binomial, try to pull out any common terms and factorize the simplified equation. When you are asked to factorize the difference of squares use the general formula which states that the factors of (a*a - b*b) is (a-b) * (a+b). Now substitute the given values in t...
In this video you will learn how to find a slope of a line. The man in the video shows in a practical and easy way, how to do it with formulas. First he teaches how to find slopes of lines containing both negative and positive points. He shows with formulas how to do it. He teaches how to find slopes on a flat line and demonstrates that the slope of it is equal to 0. Next, he teaches a "trick" to help students learn how to identify zero and no slope lines. In the last example, he demonstrates...
This video teaches how to convert a value in Celsius to Fahrenheit in simple steps. First take a paper and marker and keep in mind a Celsius value (e.g-32) to convert into Fahrenheit. Now use the formula to convert Celsius to Fahrenheit which is F=1.8(32)+32. Use a calculator to calculate the formula and you will get the result as 89.6 Fahrenheit. Now round it off the and your final result will be 90 degree Fahrenheit.
To find the slope of a line you must have two points and then you must plug in the two points into the slope formula. The slope formula is m= y2-y1 over x2-x1. If the slope is a fraction be sure to reduce to the lowest. Remember if a number is divided into zero it is zero, if zero is divided into the number it is undefined. A calculator can help one remember this. Horizontal lines have slopes and vertical lines do not. Drawing the lines on a graph can help you see the actual slopes and which ...
For people who are learning geometry, this video will show you how to simply find the volume of a cube. This video provides the formula as well as some basic examples in order to get you started in finding the volume. The formula for the volume of a cube is the length of one side of a square^3. This is easy to remember since you are making a cube and all sides should be equal in length. By following the simple steps and by watching this video, you should be able to easily find the volume of a...
In this video the tutor shows how to find the volume of a cylinder. He relates the cylinder to real world examples of cans etc. Now he states the formula of the volume of the cylinder as the area of the base circle multiplied by the height of the cylinder. So the formula turns out to be V = Pi * r * r * h, where r is the radius of the base circle and h is the height of the cylinder. He solves a sample example to give you the idea of the problem. This video shows you how to find out the volume...
Easily learn how to graph a straight line using rise over run also known as slope.
This tutorial the shows how to find out the measure of an exterior angle of a regular polygon. He shows the formula to find it which is 360/n, where n is the number of sides of the regular polygon. He goes on further to explain the formula by taking an 18-sided regular polygon as example and computes its exterior angle as 360/18, which is 20 degrees. If you are looking to compute the exterior angel of a regular polygon, follow the procedure given in this tutorial.
In this video the instructor shows how to find the slope of an equation which is in the form Ax + By + C = 0. He says that the formula to find the slope of a line in the above form is slope m = -A/B, where A and B are the numeric constants of the variables x and y in the given equation. He goes on and further shows how to do this with a couple of examples. He shows how to reduce any equation into the general form and how to apply the slope formula then. This video shows how to find the slope ...
For people who are learning geometry and would like to be able to find the perimeter of a rectangle, this video provides and quick and simple tutorial which provides the formula as well as a good example. The formula for finding the perimeter of a rectangle is simple the sum of all sides, or l+l+w+w, where l is the length and w is the width of the rectangle. After attaining the values of the length and width of the rectangle, you can simply plug in the values to this equation in order to find...
In this video the author show how to find the volume of a sphere. The formula for finding the volume of a sphere is 4/3 * Pi * r*r*r, where r is the radius of the sphere. Now to compute the volume of a sphere you have to note down the radius of the sphere and substitute it in the above formula along with the other substitutions. The author shows this with an example by taking a sphere of some radius and calculating its volume. To find out how to calculate the volume of a sphere watch this vid...
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.
In this Excel magic trick video the tutor shows how to use the years worked formula using Yearfrac, Int and Datedif functions. He says that using this trick you can find out how many years some one has worked if we know his starting date and ending date i.e. he shows how to extract the difference in years directly by using formula to calculate it. He shows how to use Yearfrac function which gives the number of years in decimal form. He also shows how to extract integer from the decimal using ...
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...
This video teaches you how to use APT (Arbitrage Pricing Theory) models and formulas. This video shows two specific parts of the APT models the first being the after the fact version and the before the fact version. The before the fact version is focused on as being the most important which is used to calculate expected returns to calculate risk. It is discussed how flexible this model is and how different factors can be moved in and out of the formula and how each different factor is used. T...
This video tells you how to draft an equation in point-slope form. Consider the equation (y+4) = 2(x+7) for example. The formula for the point-slope form is (y-y1) = m(x-x1). To plot the graph you have to identify m the slope, the x intercept x1 and the y intercept y1. In this equation the slope is 2 and (x1,y1). The x intercept according to the formula is -x1 but the given value is +7 so you have to figure out what will give you +7,only -(-7) can give you +7 so the point is -7 and now the y ...
The riffle shuffle is the most basic of card shuffles, one that most card players and magicians can perform easily. False riffle shuffles, however, are difficult to perform convincingly, but essential for the effective performance of card magic or for cheating your friends at the card table. Whether you are a magician or a gambler, this trick will aide you in deceiving whoever it is you plan on deceiving for fun, profit, or both. The card trick master in this video performs the move three tim...
It looks like Samsung is stronger than ever, as evidenced by their quarterly forecast, which suggests a global profit of $8.8 billion, the company's highest mark in three years. Impressive, considering the spectacular failure of the Note7, Samsung's last flagship prior to the new Galaxy S8.
Welcome to the first chapter of Excel is Simple, a place where we will burst all myths around excel and try to make it simpler and fun to use.
For the most part, nobody makes money off of Facebook. Sure, some people make a living by updating pages for businesses and celebrities, but hardly anyone gets a dime from the site itself.
Part of the process to answer the topic question is to discover the answer to three other questions, which are: (1) Who am I? (2) Who do I want to help? (3) How do I want to help?
This tutorial teaches one on how to sort a given number of contacts in the Excel spreadsheet so that identical values in the sort appear after one another.
This video shows us how to use a formula to find the area of a parallelogram. The formula for finding the area of parallelogram is the same as finding the area of rectangle or a square which is equal to length time’s breadth. But the parallelogram looks a bit different and the parallelogram is basically a rectangle but it is not at right angles. If you draw two altitudes then it is a rectangle with two triangles and if you cut one of the triangles and paste it next to another triangle then we...
It’s time for science. You are able to calculate the molar mass for a compound using the periodic table and the amount of compound involved. You might need to know this in your everyday life but you will definitely need this in a chemistry class.
Is it that time? Time to wean your baby or toddler from the breast? In this tutorial, learn how to button your shirt for good with the help of these steps.
Is baby ready for their first solid meal? Cereal is a nutritious first food for little ones. You Will Need
Improve your skin’s appearance by choosing the right foundation formula and shade. You Will Need:
In a recently released video, it was revealed that Formula-E's partner Roborace has developed a driverless race car that can complete laps at full racing speed.
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...
Whether you're rooting for one of the teams or just love a contest, a pool will have you cheering. You will need:
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 681st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MIN and IF functions to find smallest number that is greater than zero in an array formula.
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 672nd installment in their series of digital spreadsheet magic tricks, you'll learn how you can use the non-Ctrl+Shift+Enter function AGGREGATE in place of SMALL in an array formula.
